HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Can we create table in function?
what is transaction? : Sql dba
Explain the difference between rename and alias?
Are subqueries better than joins?
What is the difference between a subquery and a join?
What is native sql query?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is a record in pl/sql?
What is the difference between sql and t sql?
What is data profiling in sql?
Can 2 queries be executed simultaneously in a distributed database system?
How to call a javascript function from pl sql?