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 constraint_name primary key(column_name)');
end;

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is not in sql?

996

Is sql port 1433 encrypted?

1082

Explain the order of sql statement execution?

1085

Is mariadb a nosql database?

1093

What is difference between sql and mysql?

1184

how to include numeric values in sql statements? : Sql dba

1142

Why should I use postgresql?

1063

What is trigger in sql and its types?

1107

How to get help at the sql prompt?

1159

What is application trigger?

1050

What is difference between cursor and trigger?

1126

Which tcp/ip port does sql server run?

1064

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1129

How can I see all tables in sql?

1139

How do you drop a trigger?

1033