function can return value ,procedure also return value through
out parameter then what is the difference?
Answers were Sorted based on User's Feedback
Answer / 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|
Answer / 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|
What is the usage of nvl function?
What is compute?
How do I create a sql database?
Can we use delete in merge statement?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What does where 1/2 mean in sql?
is mysql query is case sensitive? : Sql dba
If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
how to shutdown mysql server? : Sql dba
What is sql mysql pl sql oracle?