![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
文章平均质量分 68
javawjy
这个作者很懒,什么都没留下…
展开
-
plsql连接oracle 及启动服务时候需要注意的问题
1.本地连接(windows) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ...原创 2010-12-20 16:27:43 · 258 阅读 · 0 评论 -
导出、导入数据库一个表
---- 导出、导入数据库一个表 exp gds/gds@GDS_192.168.1.10 tables=(usersynclog_tab) file=c:\gds_user20110110.dmp log=c:\gds_user20110110.log imp gds1/gds1@GDS_192.168.1.10 tables=(usersynclog_tab) file=c:\gds_u...原创 2011-01-10 20:20:22 · 85 阅读 · 0 评论 -
时间查询相关
" AND TO_CHAR(SYNCFAILTIME, 'yyyy-MM-dd HH:mm:ss') = "+"'"+syncfailtime+"'"; to_date to_timestamp to_date(?,'yyyy-MM-dd HH24:mi:ss') to_date(?,'yyyy-mm-dd hh24:mi:ss') SELECT E_UUID...原创 2011-01-10 20:21:25 · 140 阅读 · 0 评论 -
地球上最全的SQL命令
地球上最全的SQL命令地球上最全的SQL命令原创 2011-03-23 11:10:26 · 99 阅读 · 0 评论 -
行转列
select product_id,product_name,product_type,area,sum(num) as total, (max(case product_state when '1' then num else 0 end)) as a, (max(case product_state when '2' then num else 0 end)) ...原创 2011-03-23 11:15:36 · 105 阅读 · 0 评论