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

Answer Posted / veni

WE give this query when, we need to view the entire record
of emp table. ( i.e) it will display all the rows and
columns of emp table. and the oracle respond the same as
per the query given.

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is csv? : Sql dba

759


Why indexing is needed?

729


How much does sqlite cost?

724


Can a procedure in a package be overloaded?

754


What is sqlite used for?

699






What are the sql aggregate functions?

815


How delete all data from all tables in sql?

687


how to rename an existing table in mysql? : Sql dba

726


What is the basic form of sql query?

679


What is sql and its types?

818


How many sql statements are used? Define them.

776


What are records give examples?

743


how to include comments in sql statements? : Sql dba

723


How is data stored on a disk?

726


What are the two characteristics of a primary key?

667