DECLARE
text VARCHAR2(200);
v_text long;
BEGIN
for text in(select table_name,column_name from user_tab_columns order by table_name)
loop
v_text:=v_text||text.table_name||’.’||text.column_name||chr(10);
end loop;
dbms_output.put_line(v_text);
END;

Reklamlar