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


Please Help Members By Posting Answers For Below Questions

How to start a new transaction in oracle?

586


What is a system tablespace?

596


What suggestions do you have to reduce the network traffic?

540


What is an oracle user account?

572


What happens if you lost a data file?

576






How many data types are supported?

612


Explain the use of rows option in imp command.

604


Explain integrity constraint?

641


Explain temporal data types in oracle

603


What are the arithmetic operations?

578


What is user managed backup in Oracle?

610


How many anonymous blocks can be defined?

581


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1558


What is primefaces used for?

557


 How to use an oracle sequence generator in a mapping?

562