A stored procedure is a sequence of statements that perform specific function.
Latest Answer : A procedure is a named PL/SQL block that can accept parameters (sometimes referred to as arguments), and be invoked. Generally speaking, you use a procedure to perform an action. A procedure has a header, a declaration section, an executable section, ...
A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or
Latest Answer : 1. Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter. 2. Function can be called from SQL statements where as procedure can not ...
FUNCTION name (argument list .....) Return datatype is local variable declarations Begin
Latest Answer : create or replace function function_name(formal parameters list with only IN mode) return datatypeislocal variable declarationsbegin executable statments; return value;end function_name; ...
Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');
Latest Answer : Procedure can be called in the following waysa) CALL direcb) EXCECUTE from calling environmentc) from other procedures or functions or packagesFunctions can be called in the following ...
a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS
Latest Answer : a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME (arguments); b. BEGIN PACKAGE NAME.PROCEDURE ...
How to return more than one value from a function?What are the types of triggers?What are the features of oracle 9i
What steps should a programmer should follow for better tunning of the PL/SQL blocks?Difference between procedure and function?What is the use of ref cursor return type?
What is a purity level? How it is should be taken into consideration when your writing any database objects i.e., trigger,function, procedure etc.,
What is difference b/w stored procedures and application procedures,stored function and application function..
