Answer Posted / reddyreddy143
1.Yes we can use out parameters in a function.but we have
to assign the out parameter value to the return datatype.
2.But when we use out parameters in function we can't call
the function from a select statement
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the types of functions in sql?
Describe sql comments?
How to run pl/sql statements in sql*plus?
What is the difference between partition and index?
What is a pl/sql block?
what is offset-fetch filter in tsql? : Transact sql
What is offset and limit in sql?
What is the difference between left join and right join?
Explain what is a database?
Define the select into statement.
When can we use the where clause and the having clause?
Is there a 64 bit version of ssms?
Which software is used for pl sql programming?
Can instead of triggers be used to fire once for each statement on a view?
Why commit is not used in triggers?