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 PK1
PRIMARY KEY(COLUMN_NAME)';
END;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does <> sql mean?

1085

Can we use the cursor's to create the collection in PL/SQL?

1026

What is foreign key and example?

936

What will you get by the cursor attribute sql%notfound?

1068

Does truncate require commit?

972

Why do we use procedures in pl sql?

1039

What is %s in sql?

1014

What does t sql mean?

944

How many disk partitions should I have?

988

What is sql key?

989

What is difference between stored procedures and application procedures?

1013

What is the plv (pl/vision) package offers?

1051

What are the types of optimization?

959

In what condition is it good to disable a trigger?

1010

what is the difference between $message and $$message? : Sql dba

997