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

What does trigger mean in psychology?

708


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

837


how to dump a table to a file with 'mysqldump'? : Sql dba

739


Who developed sql?

758


How many types of primary keys are there?

710






What operating systems are supported by oracle sql developer?

714


What is the use of procedures?

716


How do I debug a stored procedure?

812


Is natural join same as inner join?

683


What is set serveroutput on?

843


What is crud diagram?

677


How can we store rows in PL/SQL using array?

884


Does inner join return duplicate rows?

704


Where can I learn sql for free?

702


How to create a menu in sqlplus or pl/sql?

809