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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Selecting

Re: Selecting

From: Conan <conan_at_>
Date: Fri, 1 Sep 2000 09:03:03 +0100
Message-ID: <qoJr5.20126$r4.10609@news.indigo.ie> 






Hi,


in sqlplus type break on category



then run the query


select category,subcategory


from table


order by category


/



HTH


Conan



Bhavin Shah wrote in message ...


>Thanks, but this still returns duplicate categories

>(ie) USA CA

>     USA AZ


>I was looking for:

>     USA CA


>         AZ

>

Received on Fri Sep 01 2000 - 03:03:03 CDT












Original text of this message













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