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

How do I pipe the output of one isql to another?

990

What is audit logout in sql profiler?

1006

What is the difference between between and in condition operators?

985

What is an example of translating a date into julian format?

1100

Can we use ddl statements in stored procedure sql server?

990

Is ms sql traffic encrypted?

909

What is assignment operator in pl sql?

1017

What is a table partition?

1106

How do we use distinct statement? What is its use?

1013

Explain the rollback statement?

987

Why do we use triggers?

955

Is record in pl sql?

949

List the different type of joins?

1056

How global cursor can be declare with dynamic trigger ?

2189

What is lookup table in sql?

1019