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

Answer Posted / belal ansari

The sql engine select the records from the table EMS and it store in IMPLICIT CURSOR then display these recordes.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is full join in sql?

526


what is the difference between char_length and length? : Sql dba

576


Is sql a oracle?

527


Why we use sql profiler?

564


What is primary key and unique key?

547






explain the difference between bool, tinyint and bit. : Sql dba

531


What is nosql example?

585


What is procedure explain with program?

554


What are the different schemas objects that can be created using pl/sql?

534


How do you update f as m and m as f from the below table testtable?

1092


What is dynamic sql in pl sql?

498


Is t sql a programming language?

541


what is the command used to fetch first 5 characters of the string? : Sql dba

1140


What is native sql query?

554


What are the different types of functions in sql?

516