Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 58676 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 cross join sql?
what are date and time intervals? : Sql dba
Explain the order of sql statement execution?
Which is faster count (*) or count 1?
What are the sql versions?
What is the difference between an inner and outer join?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is set serveroutput on?
what is denormalization. : Sql dba
How to check if a column is nullable before setting to nullable?
what is difference between delete and truncate commands? : Sql dba
What are hotfixes and patches?
what are the advantages and disadvantages of views in a database? : Sql dba
Which join is like an inner join?
what is 'trigger' in sql? : Sql dba
