How does the conversion occur in MQ (Message Queue) to AQ (Advance Queue) through OMB (Oracle Message Broker)
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?
Latest Answer: A forms trigger may do nothing more than change the focus to a new item or show a new canvas ...
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
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 ...
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.
View page [1] 2 Next >>
Go Top
