Explain how procedures and functions are called in a PL/SQL
block ?
Answer Posted / tulsi
PACKAGE NAME.PROCEDURE NAME (parameters);
variable := PACKAGE NAME.FUNCTION NAME (arguments);
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
Does pl sql work in mysql?
What is nvl?
What is database migration?
What is primary key and foreign key?
What is thread join () in threading?
Is pl sql and postgresql same?
What are joins in sql?
Is id a reserved word in sql?
Why stored procedure is faster than query?
How can we debug in PL/SQL?
what are the disadvantages of mysql? : Sql dba
What is basic structure of pl sql?
Can we write dml inside a function in sql server?
Why is stored procedure faster than query?