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 much does sql certification cost?
how to load data files into tables with 'mysqlimport'? : Sql dba
Explain what is a column in a table?
What is the difference between Union and Union all. Which is faster.
what are enums used for in mysql? : Sql dba
What is the maximum size of sqlite database?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is optimistic concurrency control? : Transact sql
How many databases can sql express handle?
Do we need to rebuild index after truncate?
Why commit is not used in triggers?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is benefit of creating memory optimized table?
how can we find the number of rows in a table using mysql? : Sql dba
What does 0 mean in sql?