Re: Select distinct and all
Just figured out one way to do it. Instead of selecting *, select DISTINCT ID from the cont table.
I created two functions (getName and getCategory) that use the ID as an argument to grab the name and category from the cont table based on the ID.
It increases the query time a little more than I like... Does anybody know any other ways?
Thanks again,
James.
Subject
Written By
Posted
February 16, 2005 04:51PM
Re: Select distinct and all
February 16, 2005 05:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.