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
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,
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: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use XXBUNDLES(...)+5

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

Current Time: Wed Oct 26 02:49:15 CDT 2016

Total time taken to generate the page: 0.13467 seconds