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

Does postgresql run on the cloud?

1134

Write a sql select query that only returns each name only once from a table?

1001

How do I run a query in pl sql developer?

981

What is a variable in sql?

990

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

999

Why are cursors used?

1112

What are aggregate and scalar functions?

1012

What are few of the schema objects that are created using PL/SQL?

1019

How do I remove duplicates in two columns?

1045

how is myisam table stored? : Sql dba

1046

What is difference between joins and union?

1113

what is table? : Sql dba

1049

How do I restart sql?

954

What is the difference between a primary key and a unique key?

1050

What are the different operators available in sql?

993