select * from emp
what happened internally when we write this query in the sql
prompt?
Answer Posted / vijay sonawane
show all records of table as output
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What happens to the current transaction if a ddl statement is executed?
When system tablespace is created?
What do you mean by merge in oracle and how can you merge two tables?
What is a package in oracle?
How to check your oracle database 10g xe installation?
How oracle handles dead locks?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to check the oracle tns settings?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to count groups returned with the group by clause in oracle?
How many types of tables are there in oracle?
How to empty your oracle recycle bin?
How to create a table index in oracle?
What does sharding mean?
How to join two tables in a single query using oracle?