function can return value ,procedure also return value through
out parameter then what is the difference?

Answer Posted / damodharan

function should always return only one value
but procedure may return a value value it may one or more
than one value

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sqlite thread safe?

611


How do you rename a table in sql?

534


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

543


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

525


How can we avoid duplicating records in a query?

568






What is the difference between a primary key and a unique key?

563


What is sql injection vulnerability?

499


What is a system versioned table?

538


Does google use sql?

518


What are the types of operators available in sql?

554


What are the popular database management systems in the it industry?

571


How many scalar data types are supported in pl/sql?

530


Why do we use procedures?

519


What is a sql schema used for?

546


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1068