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.

Is left join faster than inner join?

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

---

please explain database architecture..

1 Answers   Infosys,

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

what is a record in a database ? : Sql dba

0 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

What is sql entity?

0 Answers  

---

Explain the the delete statements in sql?

0 Answers  

---

How do sql databases work?

0 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---