When we give SELECT * FROM EMP; How does oracle respond?
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
Is sql a scripting language?
Is oracle and sql same?
what is try_catch block in procedure
Why we use stored procedure instead of query?
What is cte sql?
Why function is used in sql?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Which one is faster ienumerable or iqueryable?
How do I edit a stored procedure?
What are two statement types in sql?
What are stuff and replace function?
How does a trigger work?
What is difference between my sql and sql?
How to run sql statements with oracle sql developer?
What is the difference between the conventional and direct path loader? : aql loader