Home » RDBMS Server » Server Administration » MINUS function
MINUS function [message #373848] Tue, 15 May 2001 15:21 Go to next message
Bruce Weinstein
Messages: 4
Registered: May 2001
Junior Member
Can someone explain how the MINUS function works.

For example,

select APPOINTMNT_PROCESS
,EFFDT
,EFF_STATUS
,DESCR
,DESCRSHORT
from TBL1@prod
minus
select APPOINTMNT_PROCESS
,EFFDT
,EFF_STATUS
,DESCR
,DESCRSHORT
from TBL2;

In this example, does ORACLE compare the columns from both tables and if each column in tbl1 is equal to each column in tbl2, it will not select the record. Therefore, it only selects the row from tbl1 if all its columns are not same as tbl2? Therefore, the conclusion is it will tell me what rows are in TBL1 that are not in TBL2?

Thanks in advance.

Report message to a moderator

Re: MINUS function [message #373877 is a reply to message #373848] Wed, 16 May 2001 06:38 Go to previous message
Naresh
Messages: 27
Registered: March 2001
Junior Member
Hi Buddy,

What's up.

You ask a Question and then give the answer as well.

Naresh

Report message to a moderator

Previous Topic: Re: How to get date (&time) in any timezone
Next Topic: Re: how to count no. of rows in a table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 23:44:41 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.