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 is difference sql and mysql?

1030

Can we join more than 2 tables in sql?

1086

Why are cursors used?

1164

What are % type and % rowtype?

1075

Is sql pronounced sequel or sql?

1331

What does count (*) mean?

981

What is example of database?

1124

Can you load data into multiple tables at once? : aql loader

1116

How do I partition a table in sql?

1196

How global cursor can be declare with dynamic trigger ?

2268

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1088

Is sql database free?

1020

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1006

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

1004

what are different types of collation sensitivity? : Sql dba

1114