function can return value ,procedure also return value through
out parameter then what is the difference?
Answer Posted / dinakar
Though a procedure returns a value through OUT parameter,
it cannot be used in a SELECT statement. Whereas a function
can be used in a SELECT statement.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is a Mapplet?
What are the parts of a sql statement?
Is t sql a programming language?
Does normalization improve performance?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What are literals in sql server?
Is record in pl sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
can sql servers linked to other servers like oracle? : Sql dba
Is pl sql a scripting language?
What are all the different types of indexes?
what is msql? : Sql dba
What does sql stand for?
What is use of term?