When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 50453 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
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
What is the need of a partition key?
How to change the order of columns in Oracle SQL Plus ?
What is application trigger?
What is the use of prepared statement?
How run sql*plus commands that are stored in a local file?
In a distributed database system, can we execute two queries simultaneously?
What is set serveroutput on in pl sql?
What is time based sql injection?
Does sql require a server?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do you update a sql procedure?
Why is sharding used?
Mention what are different methods to trace the pl/sql code?
which types of join is used in sql widely? : Sql dba
What is pl sql record in oracle?
