Interested to Buy Any Domain ? << Click Here >> for more details...
Without giving condition how to retrieve the unmatched
records from table.
- 1 Answers
- 5023 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How data locks are respected in oracle?
What is raw datatype?
What privilege is needed for a user to query tables in another schema?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What to do if the startbd.bat failed to start the xe instance?
Why does oracle 9i treat an empty string as null?
What is a directory object?
What is a cursor and what are the steps need to be taken?
What is a database schema in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to drop a stored procedure in oracle?
various types of hints and their usage
How to revoke create session privilege from a user in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Why does Oracle not permit the use of PCTUSED with indexes?
