When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / geetha priya
It will retrieve all the columns of emp table. There is no
need to check for conditions as there are no conditions
specified in the given command.
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Why do we use set serveroutput on?
What is the use of primary key?
What are the types of index in sql?
What is restrict in sql?
What is the difference between explicit and implicit cursors in oracle?
Can we write ddl statements in functions?
what are properties of a transaction? : Sql dba
What are types of indexes in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is a record in pl/sql?
How can I delete duplicate rows?
What is the difference between delete, truncate and drop command?
What does t sql mean?
How many indexes can be created on a table in sql?
How can I see all tables in sql?