try without using view .
Regards
Sreeraman
- Original Message -
From:
sultan
To: Multiple recipients of list ORACLE-L
Sent: Monday, May 13, 2002 10:53 AM
Subject: SQL Help Urgent!
Hi gurus
I have two tables like this
SQL select * from bb
Hi gurus
I have two tables like this
SQL select * from bb;
ID AMOUNT
DT-- --
--
1
1000
10-MAY-02
SQL select * from cc;
ID AMOUNT--
---
1
200
1
300
1 500
My query like this
=
SQL select
Hi gurus
I have two tables like this
SQL select * from bb;
ID AMOUNT
DT-- --
--
1
1000
10-MAY-02
SQL select * from cc;
ID AMOUNT--
---
1
200
1
300
1 500
My query like this
=
SQL select
PROTECTED]]Sent: Monday, May 13, 2002 10:53
AMTo: Multiple recipients of list ORACLE-LSubject: SQL
Help Urgent!
Hi gurus
I have two tables like this
SQL select * from bb;
ID AMOUNT
DT-- --
--
1
1000
10-MAY-02
sultan wrote:
Hi gurus
I have two tables like this
SQL select * from bb;
ID AMOUNT DT
-- -- --
1 1000 10-MAY-02
SQL select * from cc;
ID AMOUNT
--
Hi,
Select a, decode(sign(a), -1, 0, a-1) from Table Name
For summing up : sum(decode(sign(a), -1, 0, a-1))
Hope this helps
Bye
Sundar
Ravindra Basavaraja wrote:
I have a table with a number column(Col A).I want to display A-1.There could
be some negative values in
this A-1 column.But
I have a table with a number column(Col A).I want to display A-1.There could
be some negative values in
this A-1 column.But I want to display 0 whereever negative value appears.I
can use the ROUND(A-1) but this
will round the other positive value to the next positve integer which I
don't want to
.Subject: sql help --urgent
com
select sum(column) where column 0
or try a decode
-Original Message-
Basavaraja
Sent: Friday, July 20, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
I have a table with a number column(Col A).I want to display A-1.There could
be some negative values in
this A-1 column.But I