Results 1 to 3 of 3

Thread: Order by

  1. #1
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60

    Unanswered: Order by

    Hi

    The following query

    Select OBJECT_NAME from SYS.ALL_OBJECTS
    WHERE OWNER = 'SYS'
    Order by OBJECT_NAME

    gives this "strange" result

    ALL_REPCAT_USER_PARM_VALUES
    _ALL_REPCOLUMN
    ALL_REPCOLUMN

    and not this one

    ALL_REPCAT_USER_PARM_VALUES
    ALL_REPCOLUMN
    _ALL_REPCOLUMN

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    Hmmmmmmmmmmm.

  3. #3
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: Order by

    Is this strange ordering happening in a query tool (ie Toad, Benthic, etc) or are you seeing it in Sql-Plus?

    Could it have something to do with your NLS parameters?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •