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

When can we use the where clause and the having clause?

575

Define commit?

547

What is a behavioral trigger?

513

what are the authentication modes in sql server? : Sql dba

525

What are the datatypes available in pl/sql ?

607

explain the difference between myisam static and myisam dynamic. : Sql dba

513

how to get help information from the server? : Sql dba

526

Is truncate ddl or dml?

541

Can we create view in stored procedure?

522

How run sql*plus commands that are stored in a local file?

516

What is field delimiter?

633

What are sql objects?

538

What is the maximum size of sqlite database?

546

What's the procedure?

490

How do I install microsoft sql?

526