远程导出数据库
摘要：
exp zhkuser/zhk_conec@192.168.0.200:1521/orcl file=d:\aaaa.dmp owner=zhkuser 阅读全文
posted @ 2018-05-29 12:01 一碗白开水* 阅读(121) 评论(0) 推荐(0) 编辑
2018年5月29日 #
jetty插件配置
摘要：
<plugin> <groupId>org.eclipse.jetty</groupId> <artifactId>jetty-maven-plugin</artifactId> <version>9.4.6.v20170531</version> <configuration> <httpConn 阅读全文
posted @ 2018-05-29 12:00 一碗白开水* 阅读(163) 评论(0) 推荐(0) 编辑
查看表结构
摘要：
SELECT--t1.Table_Name AS "表名称",--t3.comments AS "表说明", t1.Column_Name AS "字段名称",t1.Data_Type AS "数据类型",t1.Data_Length AS "长度",t1.NullAble AS "是否为空",t1 阅读全文
posted @ 2018-05-29 11:58 一碗白开水* 阅读(108) 评论(0) 推荐(0) 编辑
连接Oracle时ORA-12541 TNS 无监听程序
摘要：
http://www.cnblogs.com/Qian123/archive/2016/08/24/5803085.html 阅读全文
posted @ 2018-05-29 11:58 一碗白开水* 阅读(148) 评论(0) 推荐(0) 编辑
判断时间差，返回1或2或3
摘要：
--select t.*, t.rowid from TEST tselect id, (case when (TRUNC(TO_DATE(s.jssj, 'YYYYMMDDhh24miss') - TRUNC(TO_DATE(kssj, 'YYYYMMDDhh24miss')))) <= s.fk 阅读全文
posted @ 2018-05-29 11:57 一碗白开水* 阅读(137) 评论(0) 推荐(0) 编辑
两数据库Dblink数据抽取blob
摘要：
在目标数据库建一张临时表Create global temporary table test3 on commit preserve rows as select * from TEST1 ;在目前数据库执行insert into test3 select * from test1 where us 阅读全文
posted @ 2018-05-29 11:56 一碗白开水* 阅读(221) 评论(0) 推荐(0) 编辑
MERGE INTO
摘要：
MERGE INTO T T1USING (SELECT '1001' AS a,2 AS b FROM dual) T2ON ( T1.a=T2.a)WHEN MATCHED THEN UPDATE SET T1.b = T2.bWHEN NOT MATCHED THEN INSERT (a,b) 阅读全文
posted @ 2018-05-29 11:55 一碗白开水* 阅读(133) 评论(0) 推荐(0) 编辑