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


Please Help Members By Posting Answers For Below Questions

What are the events on which a database trigger can be based?

598


Why do you partition data?

536


What is data control language?

532


What is the main reason behind using an index?

557


how to calculate the difference between two dates? : Sql dba

550






how can we repair a mysql table? : Sql dba

540


How can you create an empty table from an existing table?

596


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2097


How do you break a loop in pl sql?

528


Show the two pl/sql cursor exceptions.

616


Why do we use triggers?

522


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

669


What is acid property in a database?

586


How do I kill a query in postgresql?

554


What are pl/sql packages?

573