When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / reddy
IT WILL GIVES THE ALL THE ATTRIBUTS IN EMP TABLE
| Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What are the different set operators available in sql?
How do you define a foreign key?
How do you use collections in procedure to return the resultset?
How many types of keys are there in sql?
What do we need to check in database testing?
List the different type of joins?
what is the use of set statement in tsql? : Transact sql
What does where 1/2 mean in sql?
How to create your own reports in sql developer?
Explain the uses of database trigger.
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 ?
What is nosql vs sql?
what is the difference between nested subquery and correlated subquery?