Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

returning a number with precsion in pl/sql function

user11989050Sep 8 2010 — edited Sep 9 2010
How can I return a number with desired precision in oracle function

e.g

Function return_number ( --- )
return number
is
v_number number(10,2)
begin
select no into v_number from table;

return v_number;
end;

will this work
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2010
Added on Sep 8 2010
4 comments
975 views