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 a table?

725


What is a left join?

689


Can we join two tables without common column?

695


What is %rowtype in pl sql?

679


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

726






How many rows can sqlite handle?

777


What is online transaction processing (oltp)?

747


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1729


What is multiple partition?

689


What is the most restrictive isolation level? : Transact sql

763


What does t sql mean?

702


What is the difference between left join and right join?

666


How to select all records from the table?

802


Can a foreign key have a different name?

693


what is text? : Sql dba

766