 Related Questions What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ? Procedures and Functions,Packages and Database Triggers. 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 Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database. Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance Latest Answer : pakage having more advantages1)Modularity2)Easily application dision ... 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 View Question | Asked by : sivaraman.n 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
