06 2016 档案
摘要:select to_number( extractvalue( xmltype( dbms_xmlgen.getxml('select count(*) c from shipment') ) ,'/ROWSET/ROW/C')) countfrom dual;
阅读全文
摘要: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...
阅读全文