Interested to Buy Any Domain ? << Click Here >> for more details...
Show how functions and procedures are called in a pl/sql block.
- 1 Answers
- 1223 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rajesh Tejan
Functions can be called using the function name followed by parentheses, while passing any required arguments. Procedures are called using the PROCEDURE name, followed by parentheses containing any required arguments enclosed within IS keyword (if any). For example:ntFUNCTION MyFunction(p1 NUMBER) RETURN VARCHAR2 IS ... END; ntPROCEDURE MyProcedure(p1 IN NUMBER) IS ... END; nntBEGINnttMyFunction(1);nttMyProcedure(1);ntEND;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the current version of postgresql?
what are the advantages of sql ? : Sql dba
what is collation? : Sql dba
Can we use distinct and group by together?
What is your daily office routine?
Is primary key always clustered index?
What is the best sql course?
Is inner join faster than left join?
what is sql server agent? : Sql dba
Can we rollback truncate?
define sql insert statement ? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Does group by remove duplicates?
Is primary key clustered index?
how many tables will create when we create table, what are they? : Sql dba
