When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 50454 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / babapps
hi
we enter this query then oracle engine takes this query and
to search particular given table in database table then
select command act as a cursor to retrieve the data or to
fetched the
data from database table then to print the data on sql prompt
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is trigger and stored procedure in sql?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How is sql used in oracle?
Does view store data in sql?
What is trigger types in sql?
What is the difference between having and a where in sql?
What is sql keyword?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Do foreign keys improve performance?
what is the use of set statement in tsql? : Transact sql
What is dml statement?
What are the parts of a basic sql query?
Is drop table faster than truncate?
What is left join in sql?
What is compute?
