oracle - stored PL/sql function using select statement -

example have stored pl/sql

create or replace procedure number( test in number ) ........ // rest of code

isn't possible don't want run execute

execute number(2);

i want run with

select * number(2);

isn't possible run stored pl/sql script select statement call function instead of execute?

you can't execute procedure sql; however, can execute function sql.

first, redefine number function:

create or replace function number(ptest in number) return number   somevalue number := ptest * 100; begin   -- whatever   return somevalue; end;

then execute select statement as

select number(2) dual;

share , enjoy.

My