Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56904 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / ch. nageswar subudhi
Hi All,
When we'll excute any type of Query or SELECT statment in
the SQL prompt. There are some steps proceed through which
we'll get proper results. These steps are given belows
1. After write the Query
2. First it Parses according to their priority. (i.e Check
the Correct syntax)
3. Binding the variables
4. Fetch for proper data from proper table or not
5. Execute the whole query
6. Finally u'll got OUTPUT.
Regards\
Nageswar
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Can you have more than one trigger on a table?
Why function is used in sql?
What type of join is sql join?
what is the difference between join and union? : Sql dba
How can we find duplicate records in a table?
How is debugging done?
how do you tune the slow running queries in oracle db , explain the methodology
Explain the insert into statements in sql?
Is oracle sql free?
What is the use of %rowtype?
What is server name sql?
What is a behavioral trigger?
What is rank dense_rank and partition in sql?
What is sql and how does it work?
What is the non-clustered index in sql?
