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 primary key and foreign key and how they work?

745


what are the differences between char and varchar? : Sql dba

748


How do I save the results of sql query in a file?

711


How do I count records in sql?

731


What is Materialized View? In What Scenario we Use Materialized View?

8941






What is data type in database?

730


What is data manipulation language?

880


Can we rollback after truncate?

754


Explain isolation levels. : Transact sql

744


what is an alias command? : Sql dba

729


What is a crud api?

684


Explain what is a database?

816


Why do we need unique key in a table?

673


What is identity column in sql server?

718


What is a unique key and primary key and foreign key?

742