hi we enter this query then oracle engine takes this query and to sear

When we give SELECT * FROM EMP; How does oracle respond?

Question Posted / babapps

24 Answers
57874 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

Please Help Members By Posting Answers For Below Questions

How to get list of all tables from a database?

1160

what is a constraint? Tell me about its various levels. : Sql dba

986

How do you use a while loop in pl sql?

1011

Can we write ddl statements in functions?

1116

what is try_catch block in procedure

1748

What is prepared statement in sql?

1049

Is sql pronounced sequel or sql?

1261

What is t-sql? : Transact sql

985

What are stored procedures in mysql?

1019

what tools available for managing mysql server? : Sql dba

1085

What are the advantages of normalization?

1078

define join and explain different type of joins? : Sql dba

954

What is data type in sql?

963

What is sql*loader?

1189

Is left join same as join?

994