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 write a cron which will run a sql query and mail the results to agroup?

0 Answers  

---

Define a temp table?

0 Answers  

---

Explain the uses of database trigger.

0 Answers  

---

Can ddl statements be used in pl/sql?

0 Answers  

---

What are different types of keys?

0 Answers  

---

Explain mutating table error.

0 Answers  

---

What is the purpose of primary key?

0 Answers  

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

How to revise and re-run the last sql command?

0 Answers  

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

How is pl sql different from sql?

0 Answers  

---