Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45088 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answer Posted / katty
When data is to be retrieved from one table based on the condition from another table subquery is used
When the data is to be retrieved from both the tables join is used
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
What privilege is needed for a user to insert rows to tables in another schema?
What is columnar storage what is the advantage?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to define a procedure inside another procedure?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is set operator oracle?
What is a sub query and what are the different types of subqueries?
Explain enable novalidate constraint.
What is clustered table in Oracle?
Write a trigger example in oracle?
How to create a table in a specific tablespace?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How can we create the complete backup of data in the oracle.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
what is port in oracle? how is it related to database application.
