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

Previous Topic: Select rows with non zero values
Next Topic: database writer process
Goto Forum:

Current Time: Tue Aug 22 00:37:54 CDT 2017

Total time taken to generate the page: 0.02574 seconds