Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57854 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 the sql case statement?
What are the events on which a database trigger can be based?
what is the difference between char and varchar data types? : Sql dba
What is clause in sql?
What is foreign key and example?
How many tables can a sql database have?
Why cross join is used?
What does trigger mean in psychology?
What is graph sql?
Is there any restriction on the use of union in embedded sql?
What is a sql statement?
What is partition in sql query?
What is nosql vs sql?
Can two tables have same primary key?
What is normalization in sql?
