06 2016 档案

摘要:select to_number( extractvalue( xmltype( dbms_xmlgen.getxml('select count(*) c from shipment') ) ,'/ROWSET/ROW/C')) countfrom dual; 阅读全文
posted @ 2016-06-17 14:45 平安奕程 阅读(690) 评论(0) 推荐(0) 编辑
摘要:select case when r = 1 then (select s.COMMENTS from user_tab_comments s where Table_Name= aa.table_name) else '' end as table_comments, case when r = 1 then aa.table_name else '' end as table_nam... 阅读全文
posted @ 2016-06-07 23:54 平安奕程 阅读(2155) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示