DECLARE
CURSOR temp IS SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME=‘表名’;
v_num NUMBER;
BEGIN
FOR i IN temp
LOOP
execute immediate ‘SELECT Count(*) FROM 表名 WHERE ‘||i.COLUMN_NAME||’ IS NOT null’ INTO v_num;
IF v_num<>0 THEN
Dbms_Output.put_line(’’||i.COLUMN_NAME);
END IF;
NULL;
END LOOP;
END;
oracle查询显示数据表中有值的字段名
最新推荐文章于 2024-04-30 23:37:55 发布