Explain how procedures and functions are called in a PL/SQL
block ?
Answer Posted / nishi
PACKAGE NAME.PROCEDURE NAME (parameters);
variable := PACKAGE NAME.FUNCTION NAME (arguments);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When do we use triggers?
Can we create foreign key without primary key?
what are the 'mysql' command line arguments? : Sql dba
Mention what pl/sql package consists of?
How to combine two stored procedures in sql?
What are the different tcl commands in sql?
what is the difference difference between procedure and packages
How to add a column ‘salary’ to a table employee_details?
What is the process of debugging?
What is the difference between the conventional and direct path loads? : aql loader
What is nosql db?
What is java sql connection?
how can we find the number of rows in a table using mysql? : Sql dba
How do I run a pl sql procedure in sql developer?
what is the difference between rownum pseudo column and row_number() function? : Sql dba