Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by newdbprgr
-
Row Count in UNION for DB2
just as i thought... you've helped to confirm my thought. thanks. -
Row Count in UNION for DB2
Faced with this problem, any idea how to go about it? SELECT * FROM ( (SELECT COL1, COL2, MAX(COL3), ROWNUMBER() OVER (ORDER BY COL1) AS ROW_NEXT WHERE COL1 = 'A' GROUP BY COL1, COL2) UNION (SELECT COL1, COL2, COL3, ROWNUMBER() OVER (ORDER BY COL1) AS ROW_NEXT WHERE COL1 != 'A'... -
Problem encountered (Urgent)
Thanks. Case Closed. I've requested vendor to change it to NUMBER.- newdbprgr
- Post #7
- Forum: Oracle: All versions
-
Problem encountered (Urgent)
I need to cover at least 99999999.999999 to 0.000001. IF I didn't specify the precision of the DECIMAL, what will the default precision?- newdbprgr
- Post #5
- Forum: Oracle: All versions
-
Problem encountered (Urgent)
I've escalated this matter to the other company, as I can't do much on my part. The code is on another server with firewall setting, unable to request to open to view source. Thanks SantaMufsa and thargtheslayer for your reply. I will tell them to change the datatype over at their side, which...- newdbprgr
- Post #4
- Forum: Oracle: All versions
-
Problem encountered (Urgent)
Hi all, due a recent update to 10g Oracle, the application doesn't seem to be working properly. CREATE OR REPLACE PROCEDURE INS_APPL ( P_QTY IN DECIMAL, P_NAME IN VARCHAR2) I've always passed in String for both the variables and it has been working fine with the previous...- newdbprgr
- Thread
- Replies: 7
- Forum: Oracle: All versions
