[Home] [Help]
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
2794: and t.table_name = c.table_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
2812: -- and t.table_name = c.table_name
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
2958: and t.column_name = 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
2973: and syn.synonym_name = a.table_name
3159: l_return boolean;
3160: --
3161: cursor c1(l_oracle_schema in varchar2) is
3162: select con.constraint_name
3163: from all_constraints con
3164: where con.table_name = p_tablename
3165: and con.constraint_type = 'P'
3166: and con.owner = upper(l_oracle_schema);
3167: --
3164: where con.table_name = p_tablename
3165: and con.constraint_type = 'P'
3166: and con.owner = upper(l_oracle_schema);
3167: --
3168: l_constraint_name all_constraints.constraint_name%type;
3169: l_proc varchar2(80) := 'benutils.get_pk_constraint_name';
3170: --
3171: begin
3172: --