Whatz the main diff between Subquery and a Join
Answer Posted / adil khan
main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is a lookup table in oracle?
What is meant by joins?
What is an Oracle Instance?
Can group functions be used in the order by clause in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to use "for" statements in oracle?
What is object data modeling?
What is proxy method?
How to write date and time literals in oracle?
What is analyze command used for?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is a private synonym?
What is set verify off in oracle?
What is the relation of a user account and a schema in oracle?