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
Type: Posts; User: vijay.akki; Keyword(s):
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