DECLARE
CURSOR c_tab IS SELECT * FROM user_tables;
v_row user_tables%ROWTYPE;
v_count INTEGER;
BEGIN
OPEN c_tab;
LOOP
FETCH c_tab INTO v_row;
EXIT WHEN c_tab%NOTFOUND;
dbms_output.put_line(v_row.table_name);
SELECT COUNT(*) INTO v_count FROM v_row.table_name;
IF v_count<>0 THEN
dbms_output.put_line(v_row.table_name||'is not null');
END IF;
END LOOP;
CLOSE c_tab;
END;
ORA-06550: line 12, column 52:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 12, column 12:
PL/SQL: SQL Statement ignored
请各位大神指导,游标的值最终给了变量,但是说找不到这表