Interested to Buy Any Domain ? << Click Here >> for more details...
Without giving condition how to retrieve the unmatched
records from table.
- 1 Answers
- 4985 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 are Schema Objects ?
What's dateware house and what's clustor with practicle example
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
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 to store pictures on to the database?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Can sub procedure/function be called recursively?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is BBED in Oracle?
how to insert the image in table
What do you mean by redo log file mirroring?
What does COMMIT do ?
Oracle General 
