How to return more than one value from a function?
Answer Posted / re
hey kumaran ...
its not like out paramaters cannot used.........
but its not preferred ...
its just simple ... just move basics why/for what a function
, procedures is used..
also with conditional if stmts... result is that a single
value is returned
re
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
how to drop an existing view in mysql? : Sql dba
What is a natural join?
What does sql stand for?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is acid property in a database?
Why is sql better than hql?
What are the different operators available in sql?
Define a temp table?
Explain foreign key in sql?
What is sql partition?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Does user triggers have entry for trigger with compilation errors?
What is oracle sql called?
what are enums used for in mysql? : Sql dba