[Home] [Help]
436: -- No need to modify the below cursor to use ev.
437: -- because we are not checking here with us.table_name
438: cursor c_column is
439: select distinct col.column_name, col.column_id
440: from user_synonyms syn, dba_tab_columns col
441: where syn.synonym_name = X_table_name
442: and col.owner = syn.table_owner
443: and col.table_name = syn.table_name
444: and col.column_name <> 'ORG_ID'
555: -- No need to modify the below cursor to use ev.
556: -- because we are not checking here with us.table_name
557: cursor c_column is
558: select distinct col.column_name, col.column_id
559: from user_synonyms syn, dba_tab_columns col
560: where syn.synonym_name = X_table_name
561: and col.owner = syn.table_owner
562: and col.table_name = syn.table_name
563: and col.column_name <>'ORG_ID'
1845: cnt number :=0;
1846: id number :=0;
1847: begin
1848: select count(*) into cnt
1849: from dba_tab_columns
1850: where table_name= X_table_name and
1851: column_name='SET_OF_BOOKS_ID' and
1852: nvl(owner, 'null') = nvl(owner, 'null');
1853: if (cnt > 0)