Answer / roopesh kumar

(1) Procedure may or may not return value but function
should.

(2) We can't call a procedure inside a sql stmt but
function can.

Answer / guest

Hi,

Basic Difference is Function must return a value and
Procedure can or cannot return a value using out parameter.



Thanks!

Answer / manojbatra071

a procedure can return none,one or more than one value but a
function can return one and only one value everytime

Answer / shasi

Hi,

The main think is function canbe used in sql select
statement but procedure wer can't use.procedure redurn more
then value(max:1024)funcion must return 1 value

Answer / sandeep sahoo

Prcocedure Will do Action whereas Function Will do Calculation

Answer / devi

1.procedure does not return any value whree as functions
return values
2.a procedure can be called independently where as a
function is called inside a procedure

What are the benefits of triggers?

0 Answers  

What is the purpose of design view?

0 Answers  

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

How can you view the errors encountered in a trigger?

0 Answers  

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

what is a composite primary key ? : Sql dba

0 Answers  

Enlist some predefined exceptions?

0 Answers  

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

How to call a javascript function from pl sql?

0 Answers  

write the Sql query for creating database backup?

7 Answers   TCS,

How do I view tables in sql developer?

0 Answers