[Home] [Help]
2785: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
2786: /* cursor c1(l_oracle_schema in varchar2) is
2787: select t.column_name
2788: from all_tab_columns t,
2789: all_cons_columns c,
2790: all_constraints a
2791: where a.constraint_type = 'P'
2792: and a.table_name = p_tablename
2793: and a.constraint_name = c.constraint_name
2803: select col.column_name
2804: from --all_tab_columns t,
2805: user_synonyms syn,
2806: dba_tab_columns col,
2807: all_cons_columns c,
2808: all_constraints a
2809: where a.constraint_type = 'P'
2810: and a.table_name =p_tablename
2811: and a.constraint_name = c.constraint_name
2937: -- get_primary_key
2938: ------------------------------------------------------------------------
2939: function get_primary_key(p_tablename in varchar2) return varchar2 is
2940: --
2941: l_primary_key all_cons_columns.column_name%type;
2942: l_proc varchar2(80) := 'benutils.get_primary_key';
2943: l_status varchar2(1);
2944: l_industry varchar2(1);
2945: l_application_short_name varchar2(30);
2949: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
2950: cursor c1(l_oracle_schema in varchar2) is
2951: /* select c.column_name
2952: from all_tab_columns t,
2953: all_cons_columns c,
2954: all_constraints a
2955: where a.constraint_type = 'P'
2956: and a.table_name = p_tablename
2957: and a.constraint_name = c.constraint_name
2964: select c.column_name
2965: from --all_tab_columns t,
2966: user_synonyms syn,
2967: dba_tab_columns col,
2968: all_cons_columns c,
2969: all_constraints a
2970: where a.constraint_type = 'P'
2971: and a.table_name =p_tablename
2972: and a.constraint_name = c.constraint_name