Home » SQL & PL/SQL » SQL & PL/SQL » using reslts from a function (sql developer)
using reslts from a function [message #281293] Fri, 16 November 2007 06:21 Go to next message
senganga
Messages: 15
Registered: November 2007
Location: South Africa
Junior Member

I have 6 fields on my select, in which 3 of them are calculated. I used a function to calculate one field called "Bundle_Pack",
XXBUNDLES( bom.item_type,
bom.ATTRIBUTE1,
bom.ATTRIBUTE8,
wsh.SHIPPED_QUANTITY,
bom_inv.ATTRIBUTE1,
tb.publication_id) as Bundle_Pack

now I need to calculate the next fied which I must use "Bundle_Pack" (example: Bundle_Pack + 5)

Pls help
Re: using reslts from a function [message #281296 is a reply to message #281293] Fri, 16 November 2007 06:23 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use XXBUNDLES(...)+5

Regards
Michel
Previous Topic: Getting invalid identifier in DBMS_SQL.Parse
Next Topic: how t0 generate missing dates
Goto Forum:
  


Current Time: Wed Dec 07 18:38:00 CST 2016

Total time taken to generate the page: 0.08462 seconds