Answer / muralidhar v

To Activate any integrity constraint, use Enable command
with Alter and to deactivate use disable with Alter.

To drop any constraint other than NOT NULL, use Drop
command with Alter. We can't drop not null, but we can
change it to NULL with Alter --Modify option.

Answer / j

Alter table table_name ENABLE constraint constraint_name;

Alter table table_name DISABLE constraint constraint_name;

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

---

Does sql use python?

0 Answers  

---

What is the limitation on the block size of pl/sql?

0 Answers  

---

What is query optimization in sql?

0 Answers  

---

What is pl sql in oracle?

0 Answers  

---

Is a secondary key the same as a foreign key?

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

Why use triggers in sql?

0 Answers  

---

Why we use pl sql?

0 Answers  

---

What are stored procedures in mysql?

0 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---