随笔分类 -  Oracle

Oracle
摘要:( select t.rid from (select rowid rid ,rownum rn from YJJBNTBHQ_2017 where rownum<100000 ) t where t.rn>99990 ) select t1.GEOMETRY.Get_WKT(),t1. BHQBH 阅读全文
posted @ 2020-06-10 09:47 leechg 阅读(231) 评论(0) 推荐(0)
摘要:SELECT t.table_name as "name", c.comments as "alias" FROM USER_TABLES t left join user_tab_comments c on t.TABLE_NAME = c.table_name select c.column_n 阅读全文
posted @ 2020-03-25 11:58 leechg 阅读(1537) 评论(0) 推荐(0)
摘要:select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 阅读全文
posted @ 2018-08-19 13:06 leechg 阅读(110) 评论(0) 推荐(0)
摘要:select 'alter system kill session '''||sid|| ','||serial#||''';' from v$session where username =' '; 阅读全文
posted @ 2018-08-19 13:05 leechg 阅读(269) 评论(0) 推荐(0)
摘要:Java使用 连接oracle数据库出现: 错误。 阅读全文
posted @ 2016-05-22 17:24 leechg 阅读(846) 评论(0) 推荐(0)