Difference between join and a subquery?
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
How to start a new transaction in oracle?
What is a system tablespace?
What suggestions do you have to reduce the network traffic?
What is an oracle user account?
What happens if you lost a data file?
How many data types are supported?
Explain the use of rows option in imp command.
Explain integrity constraint?
Explain temporal data types in oracle
What are the arithmetic operations?
What is user managed backup in Oracle?
How many anonymous blocks can be defined?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is primefaces used for?
 How to use an oracle sequence generator in a mapping?