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.

Define sql delete statement.

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

Which query operators in sql is used for pattern matching?

0 Answers  

---

What are secondary keys?

0 Answers  

---

What is a rank in sql?

0 Answers  

---

What is data control language (dcl)?

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

what are numeric data types? : Sql dba

0 Answers  

---

What is pivot in sql?

0 Answers  

---

How do I find sql profiler?

0 Answers  

---

what are the 'mysql' command line options? : Sql dba

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---