Whatz the main diff between Subquery and a Join
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
What are the limitations of check constraint?
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?
Describe varray?
What are a collation and state the different types of collation sensitivity?
How to find the duplicate rows count from employees table in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is a cursor in oracle?
How to select some rows from a table in oracle?
How to create tables for odbc connection testing?
How to pass parameters to procedures?
What is materialized view in Oracle?
Explain temporal data types in oracle
How can we create the complete backup of data in the oracle.
What are the differences between lov and list item?
Explain the use of constraints option in exp command.