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

Answer Posted / vinay dixit

Oracle search for this table in the database and returns
all the rows.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is left join example?

504


Is vs as in pl sql?

494


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

1091


What are stuff and replace function?

578


What are % type and % rowtype?

578






how to drop an existing index in mysql? : Sql dba

543


What does trigger mean in psychology?

539


What is before trigger?

558


What is autocommit sql?

540


How do you pronounce sql?

552


what is online transaction processing (oltp)? : Sql dba

531


how to run 'mysql' commands from a batch file? : Sql dba

612


What are the properties of a transaction?

571


Is nosql relational?

549


What are different functions in sql?

521