Advertisement

07.07.2008 at 11:58PM PDT, ID: 23545658
[x]
Attachment Details

Need help with a conditional type statement on an Oracle table.

Asked by rgn2121 in Oracle 10.x, Oracle Database, PL / SQL

Tags: SQL, PL/SQL

I have a table that contains many Items....Item1, Item2, Item3...
Each of these items can have multiple id's associated with them...ID1, ID2, ID3.
I want one of every item, but only ID2 if ID1 is not available and only ID3 if ID1 and ID2 are not available.

So if I had the following data...

Item1, ID 1
Item1, ID2
Item2, ID3
Item3, ID2
Item3, ID3

I would return...  
Item1, ID1
Item2, ID3
Item3, ID2

thanks...



Start Free Trial
[+][-]07.08.2008 at 12:54AM PDT, ID: 21951757

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:19AM PDT, ID: 21951841

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:21AM PDT, ID: 21951855

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:25AM PDT, ID: 21951874

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:32AM PDT, ID: 21951905

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:35AM PDT, ID: 21951920

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:41AM PDT, ID: 21951946

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:46AM PDT, ID: 21951964

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:51AM PDT, ID: 21951985

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:54AM PDT, ID: 21952001

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:57AM PDT, ID: 21952013

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 02:05AM PDT, ID: 21952056

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Oracle Database, PL / SQL
Tags: SQL, PL/SQL
Sign Up Now!
Solution Provided By: sujith80
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.08.2008 at 02:11AM PDT, ID: 21952079

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628