When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 52194 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
What is normalisation in sql?
What is the difference between clustered and non-clustered index in sql?
what is difference between delete and truncate commands? : Sql dba
How is pl sql different from sql?
Explain what is an index?
What is the difference between between and in condition operators?
How do you declare a user-defined exception?
how can we submit a form without a submit button? : Sql dba
What are literals in sql server?
What is pl sql record in oracle?
Can we perform dml on view?
How to prepare for oracle pl sql certification?
What is rank dense_rank and partition in sql?
What is scope and visibility in PL/SQL?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
