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,

---

Can we call dml statement in function?

0 Answers  

---

Is drop table faster than truncate?

0 Answers  

---

What Is a Trigger? How Do You Use It?

3 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---

What is sharding in sql?

0 Answers  

---

What is a unique key and primary key and foreign key?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

How do I save a stored procedure?

0 Answers  

---

How to create your own reports in sql developer?

0 Answers  

---

What do you mean by query optimization?

0 Answers  

---

What is the use of prepared statement?

0 Answers  

---