Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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


Please Help Members By Posting Answers For Below Questions

What is view? Can we update view

1352


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1041


What is trigger in pl sql with examples?

979


Why procedure is used in sql?

970


what is the syntax for using sql_variant_property? : Transact sql

987


Why stored procedure is faster than query?

949


how to escape special characters in sql statements? : Sql dba

967


Does group by remove duplicates?

979


What are reports usually used for?

967


How exception is different from error?

970


What is memory optimized table?

985


what is meant by nl2br()? : Sql dba

974


What is the use of function "module procedure" in pl/sql?

1134


What is duration in sql profiler trace?

1021


What steps server process has to take to execute an update statement?

920