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 not null constraint? : Sql dba

1 Answers  

---

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

What is rtm in testing?

1 Answers  

---

What are packages in pl sql and also explain its advantages?

1 Answers  

---

How many types of triggers are there in pl sql?

1 Answers  

---

What is sql select statement?

1 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What is the cause of mutating table error and how can we solve it?

1 Answers  

---

what is the command for user data type?

2 Answers  

---

What is cross join example?

1 Answers  

---

What is difference between group by and partition by?

1 Answers  

---