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 |
Post New Answer View All Answers
What is view? Can we update view
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is trigger in pl sql with examples?
Why procedure is used in sql?
what is the syntax for using sql_variant_property? : Transact sql
Why stored procedure is faster than query?
how to escape special characters in sql statements? : Sql dba
Does group by remove duplicates?
What are reports usually used for?
How exception is different from error?
What is memory optimized table?
what is meant by nl2br()? : Sql dba
What is the use of function "module procedure" in pl/sql?
What is duration in sql profiler trace?
What steps server process has to take to execute an update statement?