begin execute immediate('alter table table

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

Question Posted / prativa mishra

Answer Posted / prativa mishra

begin
execute immediate('alter table table_name add constraint constraint_name primary key(column_name)');
end;

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What packages(if any) has oracle provided for use by developers?

5793

How to convert comma separated string to array in pl/sql?

1169

What is memory optimized table?

1037

What are different types of triggers?

1099

How can I tell if sql is running?

1050

Are stored procedures faster than queries?

940

How many triggers can be applied on a table?

928

how to calculate the difference between two dates? : Sql dba

1050

Mention what are the benefits of pl/sql packages?

1069

How many rows can sqlite handle?

1100

what are the disadvantages of mysql? : Sql dba

1139

what's the difference between a primary key and a unique key? : Sql dba

1038

What is a temporal data type?

1039

Is sql similar to python?

965

Can variables be used in sql statements?

1024