OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query [message #255578]

Wed, 01 August 2007 04:22

meeta
Messages: 28
Registered: January 2000

Junior Member

Hi all,
i have a table with thse structure abc(vi number,v2 number,v3 number)
Data is like this

Quote:

abc
vi v2 v3
0 0 10
30 0 0
0 20 0

i want to have following output

Quote:

v
10
20
30

Kindly help me how to do so, i need to select any non zero value from thses 3 columns

Report message to a moderator

Re: query [message #255582 is a reply to message #255578]

Wed, 01 August 2007 04:26

azamkhan
Messages: 557
Registered: August 2005

Senior Member

use DECODE function... I m 100% sure that your problem will be solved... Razz

Report message to a moderator

Re: query [message #255593 is a reply to message #255582]

Wed, 01 August 2007 04:37

meeta
Messages: 28
Registered: January 2000

Junior Member

Hi thanks,
i tried using decode but it didnt work out
can u tell me hw to do it using decode

Report message to a moderator

Re: query [message #255810 is a reply to message #255593]

Wed, 01 August 2007 16:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

GREATEST might be a function you are looking for:

SQL> select * From abc;

        VI         V2         V3
---------- ---------- ----------
         0          0         10
        30          0          0
         0         20          0

SQL> select greatest(vi, v2, v3) from abc;

GREATEST(VI,V2,V3)
------------------
                10
                30
                20

Report message to a moderator

Previous Topic:	Save seleted record
Next Topic:	regarding quries using in oracle forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 18:25:58 CST 2025