oracle
梅八哥
懒人推动技术进步
展开
-
ojdbc maven
ojdbc有权限问题,需要 自己install到本地或者私服https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.htmlmvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.4.0 -Dpa...原创 2020-02-27 14:33:27 · 483 阅读 · 0 评论 -
mysql和oracle大小写
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_nameshttps://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html表和数据库名称在磁盘上的存储方式以及如何在My...原创 2020-02-26 14:03:50 · 316 阅读 · 0 评论 -
oracle中sql注意事项总结
select * from awhere a.id not in (select aid from b)----- 这条sql必须保证b表中aid不能有null值,否则查询结果为0原创 2015-05-28 16:28:34 · 140 阅读 · 0 评论 -
Oracle的getColumnName和getColumnLabel区别
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) ...原创 2016-08-23 17:24:16 · 1357 阅读 · 0 评论 -
Oracle的表结构查询
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...原创 2016-08-24 13:51:08 · 112 阅读 · 0 评论 -
oracle所有表的基本信息
原文:http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htmALL_TAB_COLUMNSALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user...原创 2016-08-24 15:41:50 · 291 阅读 · 0 评论 -
oracle和mysql的数据库移植复制工具
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...原创 2018-01-05 11:08:34 · 193 阅读 · 0 评论 -
oracle10g下载地址
转自:http://blog.itpub.net/27006877/viewspace-739059/ Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86http://download.oracle.com/otn/linux/oracle10g/10201...原创 2018-06-08 15:48:03 · 555 阅读 · 0 评论 -
sqldeveloper连接
在下载页面,连续点击下面的Previous Version寻找。把8.0.13.jar移动到第一个。原创 2018-06-09 15:09:41 · 2870 阅读 · 0 评论