Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32883 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
How to create a server parameter file?
How to display row numbers with the records?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Difference between hot backup vs. Cold backup?
What is dual table oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
what are actual and formal parameters?
What happens if you use a wrong connect identifier?
What is raw datatype in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
State and explain about oracle instance?
How to convert numbers to characters in oracle?
How many data types are supported?
Give the different types of rollback segments.
What is index in Oracle?
