 Related Questions A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks. Latest Answer : Procedure is a named PL/SQL block and a reusable database object which can accept multiple arguments, execute PL/SQL statements, do exception handling and return multiple results. Procedures are stored and executed in the database. ... A Function returns a value to the caller where as a Procedure does not. Latest Answer : Function always returns a value. Procedure may or may not return a value.Functions can be called in SQL statements. Procedure can not be called in an SQL statement. ... A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table. Wht is the logic to find whether the entered input is a number or the character. How can we design this program using a procedure or the function Which is better to use, procedures or packages? If a procedure within a package is called, will it load the entire package into memory? What is the best way to handle it? Read Answers (1) | Asked by : hari
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
