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

Explain the purpose of %type and %rowtype data types?

928

How to disable a trigger name update_salary?

1266

how to use like conditions? : Sql dba

1108

What are all the different normalization?

1037

What are the packages in pl sql?

1009

Can a primary key be a foreign key?

1022

how can we repair a mysql table? : Sql dba

979

What do you mean by stored procedures?

1012

can sql servers linked to other servers like oracle? : Sql dba

1005

Which certification is best for sql?

985

Explain the working of foreign key?

1067

What are user defined functions?

1016

What is sqlerrm?

934

What is full join?

951

How many times can we commit in a loop?

1017