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;
Nice. The index are well placed.
I was searching for something like that for quite a long time and at last I have found it here. Your blog is better than others because of useful and meaningful posts.
thank you.