在Oracle中调用函数时,参数的传递方式可以分为以下几种:
SELECT function_name(param1, param2) FROM dual;
SELECT function_name(param2 => value2, param1 => value1) FROM dual;
SELECT function_name(param1 => value1) FROM dual;
SELECT function_name(param1 => NULL) FROM dual;
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
推荐阅读:Oracle procedure的参数传递方式有哪些