dyn sql

2001-08-24 Thread Tatireddy, Shrinivas (MED, Keane)
Hi lists can anybody post me this query: I need to generate a dynamic sql that will create a statement to add a constraint of composite primary key . alter table xyz add constriant xyz_comp_pk (col1,col2,col3); when I generated this from dba_cons_columns i am getting the flwng: alter

Re: dyn sql

2001-08-24 Thread JOE TESTA
i'd just got a piece of code from metalstink the other day that will generate the constraints on a table for you into sql code. if you want it let me know and i'll email it to ya(its really too big for the list). joe [EMAIL PROTECTED] 08/24/01 12:31PM Hi listscan anybody post me this

dyn sql(get the constraints script)

2001-08-24 Thread JOE TESTA
for those of you with metalstink, its Doc ID: Note:1016836.6 for those of you who dont(and want it, email me). have a good weekend everyone(for those of you already into the weekend in Australia and NZ, what does the weekend look like, good? joe