The sql engine select the records from the table EMS and it store in IMPLIC

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

Question Posted / belal ansari

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

Please Help Members By Posting Answers For Below Questions

What is Materialized View? In What Scenario we Use Materialized View?

9397

what is the use of friend function? : Sql dba

971

What is the use of primary key?

952

Define concurrency control. : Transact sql

1103

Why we use join in sql?

915

What is the difference between rename and alias?

1268

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

921

Is sql harder than python?

1037

What is sql architecture?

982

explain the options of myisamchk to improve the performance of a table. : Sql dba

950

what are the 'mysql' command line options? : Sql dba

1016

Is inner join same as self join?

1060

What are the advantages of pl sql?

1071

What is difference between function and trigger?

969

Explain spool.

1111