Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: What is "select all" doing?

Re: What is "select all" doing?

From: Michael Ivanov <mivanov_at_tdera.ru>
Date: Wed, 23 Oct 2002 06:09:09 -0800
Message-ID: <F001.004F0E3F.20021023060909@fatcity.com>


> We have ORACLE 8.1.7 running on server. My question is what difference on
> following select statement:
>
> select col1 form table1;
> select all col1 form table1;

compare select distinct ...

>
> Look like output are the same. Thanks.
> _________________________________________________________________
> Surf the Web without missing calls! Get MSN Broadband.
> http://resourcecenter.msn.com/access/plans/freeactivation.asp

-- 
Best regards
Michael Ivanov, TD "ERA"
y筅~'"jS
kڝاzN
nu楊w{Zx
I_at_ND
Received on Wed Oct 23 2002 - 09:09:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US