Interested to Buy Any Domain ? << Click Here >> for more details...
Without giving condition how to retrieve the unmatched
records from table.
- 1 Answers
- 4914 Views
- TCS, I also Faced
- E-Mail Answers
Answer / sudipta santra
SELECT * FROM (
(
SELECT * FROM T1
UNION
SELECT * FROM T2
)
MINUS
(
SELECT * FROM T1
INTERSECT
SELECT * FROM T2
) ) ;
| Is This Answer Correct ? | 3 Yes | 0 No |
What happens if recursive calls get out of control?
What is clustered table in Oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What are the attributes of the cursor?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Difference between an implicit & an explicit cursor.?
why pl sql doesn't support retrieving multiple records
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Explain an extent?
How many types of cluster table in Oracle?
Oracle General 
