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
List different type of expressions with the example.
What is the purpose of cursors in pl/sql?
what is cursor. write example of it. What are the attributes of cursor.
What is dynamic sql in pl sql?
Can we use update in sql function?
What is a data manipulation language?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
How to use sql statements in pl/sql?
what is transaction? : Sql dba
What is cross join sql?
What is duration in sql profiler trace?
What is bitemporal narrowing?
How delete all data from table in sql?
how would you enter characters as hex numbers? : Sql dba
How to run sql functions in pl/sql?