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;

How do I find duplicates in a single column in sql?

0 Answers  

---

What are the disadvantages of file system?

0 Answers  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

How do you delete a table?

0 Answers  

---

What are all the different normalization?

0 Answers  

---

---

What is the process of debugging?

0 Answers  

---

What are the types pl/sql code blocks?

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What is left inner join in sql?

0 Answers  

---

What is difference between inner join and cross join?

0 Answers  

---

List the ways to get the count of records in a table?

0 Answers  

---

Which operator is used in query for pattern matching?

0 Answers  

---