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: order by

Re: order by

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 01 Jan 2004 08:04:25 -0800
Message-ID: <F001.005DB749.20040101080425@fatcity.com>


It is for the same reason that 'select empno from emp' without and order by, also returns the same results.

Take a look at $ORACLE_HOME/sqlplus/demo/demobld.sql

Didn't you ask this same question earlier this week?

Jared

On Thu, 2004-01-01 at 01:14, bulbultyagi_at_now-india.net.in wrote:
> List can you please explain to me why
>
> select empno from emp
> order by empno ;
>
> is the same as
>
> select empno from emp
> order by sqrt(3.14);
>
> but not the same as
>
> select empno from emp
> order by dbms_random.value;
>
> What does sort by a random value do ? and why isn't dbms_random.value in
> the documentation for 9i Release 2 ?
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, December 29, 2003 03:34
>
>
> > bulbultyagi_at_now-india.net.in wrote:
> > >
> > > Hello list,
> > > Can someone please explain to me why the following order by clauses are
> > > valid and yield the same results :
> > >
> > > select empno, deptno from emp
> > > order by sqrt (1) ;
> > >
> > > and
> > >
> > > select empno, deptno from emp
> > > order by sqrt ( 3.14234 ) ;
> > >
> > > The docs say that in the order by clause you could specify only (a)
> column
> > > names or (b) positional parameters or (c) expressions involving the
> columns
> > >
> >
> > A constant falls under the c) category. It's an expression, which
> > involves anything you want. That said, I fail to see any practical use
> > .
> >
> > --
> > Regards,
> >
> > Stephane Faroult
> > Oriole Software
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Stephane Faroult
> > INET: sfaroult_at_oriole.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 01 2004 - 10:04:25 CST

Original text of this message

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