How do I select distinct values when user executes query?

From: John Smithy <me_at_me.com>
Date: Wed, 21 Jul 1999 18:50:22 GMT
Message-ID: <3796165c.1117445_at_news.ikea.com>

Hi,

[Quoted] I know this is probably dumb. I have a single table with all my data. One column is called ship_no. For each ship_no, there are many rows. So when a user queries on this, he/she will see many rows for each ship_no. I have this table divided into three blocks. The master block just has ship_no. The details are in the other blocks. The user will query on ship_no. I only want to display the unique value. Can someone help me out? I am a new Oracle Developer. I am coding with Forms 5.0

Thanks,
John Received on Wed Jul 21 1999 - 20:50:22 CEST

This message: [ Message body ]
Next message: paul4_at_my-deja.com: "Adhoc"
Previous message: lynn_bassler_at_my-deja.com: "Re: Memory leak ADO-MSDAORA"
Next in thread: Randy DeWoolfson: "Re: How do I select distinct values when user executes query?"
Reply: Randy DeWoolfson: "Re: How do I select distinct values when user executes query?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message