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 is sharding in sql?

0 Answers  

---

How does postgresql compare to mysql?

0 Answers  

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

what is bcp? When is it used?

0 Answers  

---

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

---

---

What is the usage of sql functions?

0 Answers  

---

Is a foreign key always unique?

0 Answers  

---

Describe different types of general function used in sql?

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

---

Which is faster view or stored procedure?

0 Answers  

---