开发者

How do you call a function in a package via an sql query

开发者 https://www.devze.com 2023-02-02 15:57 出处:网络
I have got a function in PL SQ开发者_运维问答L called FUNCTION names_active(name_entity IN NUMBER) in a package called names_package

I have got a function in PL SQ开发者_运维问答L called FUNCTION names_active(name_entity IN NUMBER) in a package called names_package how can I call it a query


SELECT names_package.names_active(42) 
FROM dual

More details are in the manual:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_packages.htm#sthref993

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号