摘要:
declare cnt number; begin ---查询要创建的表是否存在select count(1)into cntfrom colswhere table_name = upper('APPR_EXCHANGE_INST')and column_name = upper('feedbac... 阅读全文
摘要:
去空方法:nvl(列名,默认值)select nvl(name,'ii') as studentname from student ;select nvl(age,99) as studentage from student;pl创建临时表空间:create temporary tablespace... 阅读全文