
oracle查看所有表信息
select tabschema, tabname, ta...
select tabschema, tabname, ta...
–创建删除所有表的存储过程CREATE OR REPLACE FUNCTION delAllTable() RETURNS voidAS $BODY$DECLAREtmp VARCHAR(512);DECLARE names C...
SELECT (case when a.colorder=1 then d.name else null end) 表名, &...