1. how to use the check option constraints in sql query..? 2.how to add data in a complex query ? 3.is it possible to use commit or rollback or savepoint in triggers...if not why please explain with examples...? 4.what is the difference between meterialized view and normal view..how to create materialized view and how to use it..? 5.what is varray...? what is the advantage of the varray ? please expalin with a simpel example..i want to load into a table (student no and name and his marks..) please give example.. 6.what are the bulk bind exceptions...how to use bulk bind and how to use bulk collect..please explain with example... 7.what is for update of and where current of ...? 8 what is the use of nowait ? 9.please give an example for nocopy in a simple plsql query 10.create an index in a table...tellme how to use the index in a where clause to do performance tunning...

3 Answers   Satyam,

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

Which data type is a composite type?

0 Answers  

---

How do I run a script in sql developer?

0 Answers  

---

What is union and union all keyword in sql?

0 Answers  

---

How do I remove sql plus from windows 10?

0 Answers  

---

What is schema in sql example?

0 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

What is the life of an sql statement?

0 Answers  

---

What is coalesce in sql?

0 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---