Search:

Yes ur right.but Acc to their syntax...we can not use any RETURN Statement in procedural declaration..I think it may be in the body section

1) Both are strored subprogrames
2) functions can return a value back to the calling environment by its return statement
3) procedures can not have any return statement ,but it can return more...

if u dont know How to using the PRAGMA AUTONOMOUS and PL/SQL programming ..
better to use save point to every SQL statment,then we can rollback to the particular area

no, that restriction is only upto Ora8i

No, there is no limit for declaring the parameter in procedures.

Hi Guys ....Gud Morning to ALL

select ename from Emp
group by ename where rownum<=4;

hi vijaya
WISH U WELCOME TO GeekINtrvw
Really its very good platform to share different aspects in TECHNICAL areas
Have a nice touch

vijay:p

hi jothy
A warm WELCOME TO GeekInterview
and let us Share the topics on differnt platform(ORACLE,JAVA etc);
Vijju