Answer / esakkiraja

One more diff between function and procedure

Functions can be used in sql query but procedure we can't
used in sql query

For eg:
tax is a function we can use like

select ename,tax(sal) from emp where ename='saki';


In this we can use.....

Answer / aleena

PROCEDURE:

cannot return a value

SYNTAX:
CREATE PROCEDURE procedure_name [argument datatype]
AS
BEGIN
sql statements
END;
/

FUNCTION:

returns a value

SYNTAX:

CREATE FUNCTION function_name [argument[IN] datatype]
RETURN datatype
AS
BEGIN
sql statements
END;
/


PACKAGES

Pakages are groups of functions,procedures,sql blocks
goruped together in a single unit.

there are two parts to creating a PACKAGE --1>CREATE
PACKAGE & 2> CREATE PACKAGE BODY

SYNTAX :
CREATE PACKAGE :

CREATE PACKAGE package_name
AS

FUNCTION function_name(datatype);
PROCEDURE procedure_name (datatype);
.......
.......(sql/plsql statements )
........
END;

CREATE PACKAGE BODY :

CREATE PACKAGE BODY packagebody_name
AS
FUNCTION function_name (datatype)
RETURN datatype
AS
.....
.....
.....
END function_name;
PROCEDURE procedure_name (datatype)
AS
......
.....
.....
END procedure_name
END PACKAGE;

Answer / suresh

Function must return one value
Procedure may or may not return one or more values.
Can call functions in Sql statements
we can't call a procedure in sql statements
Functions can not return images
procedure returns images

Answer / subhasish dutta

If no write (i.e. insert,delete,update,merge) operation is
made in a function then that function can be used sql
query. if only read operation (i.e. Select) is used in a
function, that can be called from sql query.

Answer / deepak

Note:- procedure may or may not return value.function must
return value
Procedure return one or more value & function return only
single value.
Pakages are groups of functions,procedures,sql blocks
goruped together in a single unit.
Package & packagebody are two different thngs. Variable
defined in packages are global & they can use in anywhere
in packagebody. Variable defined in packagebody have
limited scope. & they can used in defined limit only.

Answer / rashmipriya

procedure call is pl/sql statement by itself.

function call is part of an expression.

Answer / karunakar remala

Procedure and functions contains scope with in package
only..but coming to it contains scope out side of the
package also.i.e we can access package elements from out
side of the package also.

Answer / ezhumalai

A Procedure that performs an action.
A Function that computes a value.

We can call a Function in SELECT Statement.
We can't call a Procedure in SELECT Statement.

Answer / san

can access package elements from out
side of the package only if its declare in package specification

Answer / kalaiselvan.j

The Function will return a value where procedure wont.

what is correlated subquery

3 Answers  

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

please send me oracle pl/sql exp resume. and also faqs...

0 Answers  

What is the mandatory setup in cyclecount ?

0 Answers   Oracle,

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

0 Answers  

how can it possibble to see the report output in excel sheet in oracle applications

4 Answers   Oracle, Wipro,

Is it possible to drop a column in a table which contains only one column? How?

1 Answers  

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers  

What is auto invoicing? Explain : oracle accounts receivable

0 Answers  

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,