Answer / prativa mishra

begin
execute immediate('alter table table_name add constraint constraint_name primary key(column_name)');
end;

Answer / prativa mishra

BEGIN
EXECUTE IMMEDIATE 'ALTER TABLE TABLE_NAME ADD CONSTRAINT PK1
PRIMARY KEY(COLUMN_NAME)';
END;

Answer / saran

alter <tablename> attributename,constriantname

Write a unique difference between a function and a stored procedure.

0 Answers  

---

What is ttitle and btitle?

0 Answers  

---

Explain what is an index?

0 Answers  

---

What are sql data types?

0 Answers  

---

How to assign sql query results to pl sql variables?

0 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

Is delete faster than truncate?

0 Answers  

---

How many sql statements are used?

0 Answers  

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---