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

Answer Posted / nagender k

It will retrieve all the columns from emp table.

Is This Answer Correct ?    21 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is self join and what is the requirement of self join? : Sql dba

848


What are the most important characteristics of pl/sql?

777


Write a sql query to find the names of employees that begin with ‘a’?

739


how to calculate the difference between two dates? : Sql dba

719


Explain select statements in sql?

752






how can you create an empty table from an existing table? : Sql dba

852


Is sql developer case sensitive?

720


What is scalar data type in pl sql?

774


How to add new employee details in an employee_details table with the following details

821


what are date and time data types? : Sql dba

697


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

716


How can we make an if statement within a select statement?

731


What is record in pl sql?

762


What are pl/sql packages?

760


How long will it take to learn pl sql?

685