what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?

Answer Posted / gavini srikanth

function can return value,procedure may or may not return
value,through procedures can store images

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a primary key? : Sql dba

650


What is flag in sql?

641


What is denormalization in a database?

671


What is the difference between cluster and non-cluster index?

715


What are joins in sql?

625






how can we find the number of rows in a table using mysql? : Sql dba

681


Is sqlite free?

641


what are all the common sql function? : Sql dba

677


what is the difference between sql and t-sql? : Transact sql

701


How do I find duplicates in the same column?

635


Show the two pl/sql cursor exceptions.

711


Can we join 3 tables in sql?

602


Is oracel sql developer written in java?

750


Which data type is a composite type?

629


What is sql*loader and what is it used for? : aql loader

704