Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
- 3 Answers
- 6797 Views
- I also Faced
- E-Mail Answers
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 a trigger on view?
Can dml statements be used in pl/sql?
How to rename a column in the output of sql query?
How many sql are there?
Show how functions and procedures are called in a pl/sql block.
What is dbo in sql?
How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000
10 Answers Mind Tree, Polaris, Sonata,
What is the difference between a subquery and a join?
how to add a new column to an existing table in mysql? : Sql dba
What language is oracle sql developer?
How is debugging done?
How do you modify a table in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
