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!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: newdbprgr
  • Content: Threads
  • Order by date
  1. newdbprgr

    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'...
  2. newdbprgr

    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...

Part and Inventory Search

Back
Top