When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
Computer & Technology RelatedPost here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.
wouldn't it be better to maintain your constants in their own 'tblConstants' rather than coded in a package, especially when you know you'll be referencing them from SQL?
like this?
procedure ProcName(ioCursor out ref_cursor)
is
ConstantVar varchar2(3);
begin
ConstantVar := 'boll0x';
open ioCursor for
select table.*,ConstantVar
from table;
end;
Good try, but it has to be a view not a procedure, so I can't use an intermediary variable I don't think it's possible without placing the data in a table
SELECTing an Oracle constant in a view
I don't think it's possible without placing the data in a table
