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


Please Help Members By Posting Answers For Below Questions

List different type of expressions with the example.

551


What is the purpose of cursors in pl/sql?

636


what is cursor. write example of it. What are the attributes of cursor.

747


What is dynamic sql in pl sql?

497


Can we use update in sql function?

586






What is a data manipulation language?

571


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1711


How to use sql statements in pl/sql?

581


what is transaction? : Sql dba

532


What is cross join sql?

503


What is duration in sql profiler trace?

555


What is bitemporal narrowing?

739


How delete all data from table in sql?

574


how would you enter characters as hex numbers? : Sql dba

517


How to run sql functions in pl/sql?

540