Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56980 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 does seeding a database mean?
What is the trigger in sql?
What are inner outer left and right joins in sql?
What is the use of index in sql?
What is the use of index in hive?
What are stored procedures used for?
Which type of cursor is used to execute the dml statement?
How global cursor can be declare with dynamic trigger ?
What is latest version of sql?
Mention what are the benefits of pl/sql packages?
What is a heap in sql?
Is a table valued function object?
What is the limitation on the block size of pl/sql?
how to convert character strings to numeric values? : Sql dba
Can we create index on primary key?
