aoeace

ojdbc有权限问题，需要 自己install到本地或者私服 https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.4.0 -Dpa...

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_names https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html 表和数据库名称在磁盘上的存储方式以及如何在My...

select * from a where a.id not in (select aid from b) ----- 这条sql必须保证b表中aid不能有null值，否则查询结果为0  

  getColumnName返回的是sql语句中field的原始名字。getColumnLabel是field的SQL AS的值。 比如：select a.name as name,a.description as description,b.description as relatedDescription from a,b where ... 此时,getColumnName(3) ...

  select * from all_tables WHERE table_name='STUDENT'; select * from all_tab_columns where owner='chipmunk' and table_name='STUDENT'; select column_name,comments from all_col_comments where ow...

原文：http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm ALL_TAB_COLUMNS ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user...

Navicat Premium和sqldeveloper.exe   oracle sql developer中添加mysql连接： JDBC for MySQL官网下载地址:http://www.mysql.com/downloads/connector/j/ 文件名大致是 mysql-connector-java-5.1.18.zip, 下载完成后解压, 提取mysql-connec...

  转自：http://blog.itpub.net/27006877/viewspace-739059/   Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86 http://download.oracle.com/otn/linux/oracle10g/10201...

在下载页面，连续点击下面的Previous Version寻找。把8.0.13.jar移动到第一个。