Describe the stored procedure for all tables, views, and columns in Oracle.

Create or replace procedure pro_drop_comment is

Cursor c_table_column is

Select * From user_tab_columns;

Cursor c_table is

Select * From user_tables;

Cursor c_view is

Select * From user_views;

SQL _drop_comment string (100 );

Begin

 

For r_C in c_table_column Loop

SQL _drop_comment: = 'comment on column' | r_c.table_name | '.' |

R_c.column_name | 'is '| '''''';

Execute immediate SQL _drop_comment;

End loop;

 

For r_C in c_table Loop

SQL _drop_comment: = 'comment on table' | r_c.table_name | 'is' | '''''';

Execute immediate SQL _drop_comment;

End loop;

 

For r_C in c_view Loop

SQL _drop_comment: = 'comment on table' | r_c.view_name | 'is' | '''''';

Execute immediate SQL _drop_comment;

End loop;

 

End pro_drop_comment;