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
How many tables can a sql database have?
Does a primary key have to be a number?
Can 2 queries be executed simultaneously in a distributed database system?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How do I kill a query in postgresql?
How do I trace sql profiler?
What is left join in postgresql?
What is pragma in sql?
Does pdo prevent sql injection?
What is a left join?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How do you rank data in sql?
How would you reference column values before and after you have inserted and deleted triggers?
How to write html code in pl sql?
What is a recursive join sql?