Whatz the main diff between Subquery and a Join
- 14 Answers
- 29120 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / suramya biswas
Sub Query can be used for UPDATE,DELETE statements where as
Join Query is only used in SELECT statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Oracle
How to get a list of all background sessions in the database?
What is the usage of analyze command in oracle?
Can we insert data in view oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is bulk load in oracle?
Why do we need oracle client?
Please explain compound trigger in oracle?
How to change system global area (sga) in oracle?
Explain index?
What are temporal data types in oracle?
How to write date and time literals in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to estimate disk space needed for an export job?
