Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57920 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
Do we need commit after truncate?
Is stored procedure faster than query?
What is full form of rtm?
What is the difference between execution of triggers and stored procedures?
Explain the difference between triggers and constraints?
How do you use join?
What is full join in sql?
Why do we need cursor in pl sql?
What is trigger and types?
What is a record in a database?
What is the process of debugging?
What is sql and explain its components?
What is oracle and pl sql?
Can you upgrade sql express to full sql?
When is the update_statistics command used?
