HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is view explain with example?

523


What is a database event trigger?

601


Can we write dml inside a function in sql server?

502


what are the advantages and disadvantages of cascading style sheets? : Sql dba

556


Define SQL and state the differences between SQL and other conventional programming Languages?

692






Explain aggregate functions are available there in sql?

537


What is an intersect?

657


What is trigger types in sql?

537


What is data types in sql?

538


What is the use of index in sql?

562


Can we use insert statement in function?

519


Is left join faster than inner join?

625


What sql does db2 use?

547


how can we destroy the cookie? : Sql dba

561


How many types of normalization are there?

493