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

Answer Posted / gvprasad

The oracle engine will execute the command,and retrives all
the data from the database and give it to the end user.

Is This Answer Correct ?    23 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete data from a table?

546


Does a primary key have to be a number?

522


How long does it take to learn pl sql?

610


Define concurrency control. : Transact sql

587


what is the difference between a having clause and a where clause? : Sql dba

521






What is trigger in sql? Explain

538


How do I enable sql encryption?

519


What is the difference between cross join and natural join?

567


What is not null in sql?

580


How many subqueries can be nested in a statement?

506


What is data type in database?

548


How to run sql commands in sql*plus?

589


Can we call procedure in select statement?

520


What is the difference between partition and index?

485


How many sql databases can you have on one server?

595