Answer / nitin

The phase of sql query execution is as follows.
1)Syntax Checking: Query will be checked if it is syntactically correct.
2)Semantic Checking:Query will be checked for user has rights on tables etc.
3)Cursor sharing:query will be checked against cursor sharing if soft parse can be done or hard parse required.
4)The creation of cost based decision tree for possible plans.
5)The execution of lowest cost execution plan.
6)Binding the execution plan.
7) Executing the query and fetching the rows.

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

What are triggers and its uses?

0 Answers  

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

How do I view output in sql developer?

0 Answers  

---

there are .......different types of serializability

1 Answers   Wipro,

---

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

What is cursor and why it is required?

0 Answers  

---

What is the order of sql select?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---