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;

Why do we use partitions in sql?

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Can a select statement fire a trigger?

0 Answers  

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

What is sql used for?

0 Answers  

---

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

---

Why do we use view in sql?

0 Answers  

---

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

What is sequence in sql?

0 Answers  

---

What is database white box testing and black box testing?

0 Answers  

---

why use cursors?

5 Answers   Oracle,

---