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.

How do I save the results of sql query in a file?

0 Answers  

---

Where is pl sql used?

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

How many tables can you join in sql?

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What is sql and its types?

0 Answers  

---

Mention what does plv msg allows you to do?

0 Answers  

---

What is not null in sql?

0 Answers  

---

what is top in tsql? : Transact sql

0 Answers  

---

Can we use pl sql in sql server?

0 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---