huh?
new value
> ANAND 1 4-1+1 = 4
> BALU 2 4-2+1 = 3
> CHANDU 3 4-3+1 = 2
> DAVID 4 4-4+1 = 1
looks right to me.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Thursday, October 03, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L
the below query adds/substracts the value in the age column...
SELECT NAME, 4-AGE+1 FROM test;
does not work..
-----Original Message-----
SALAYMEH
Sent: Thursday, October 03, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L
TRY THIS :
SELECT NAME, 4-AGE+1 FROM test;
--- Naveen Nahata <[EMAIL PROTECTED]> wrote:
> why do u want such a query?
>
> -----Original Message-----
> Sent: Thursday, October 03, 2002 1:33 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have a table test((NAME VARCHAR2(10),AGE
> NUMBER(2));
>
> data of the table is
>
> NAME AGE
> ---------- ---------
> ANAND 1
> BALU 2
> CHANDU 3
> DAVID 4
>
>
> I want a query which give me the result as
>
> NAME AGE
> ---------- ---------
> ANAND 4
> BALU 3
> CHANDU 2
> DAVID 1
>
> Can any body pl. help me.
>
> Anand Kumar
> ITW Signode India Ltd
>
>
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ASHRAF SALAYMEH
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Santosh Varma
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
