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
What are the events on which a database trigger can be based?
Why do you partition data?
What is data control language?
What is the main reason behind using an index?
how to calculate the difference between two dates? : Sql dba
how can we repair a mysql table? : Sql dba
How can you create an empty table from an existing table?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How do you break a loop in pl sql?
Show the two pl/sql cursor exceptions.
Why do we use triggers?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is acid property in a database?
How do I kill a query in postgresql?
What are pl/sql packages?