can i use dbms_output.put_line in a function u are telling
as return statement
Answer Posted / a.jyothsna
instead of return we can't use document_output......
But for general we can use
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is %rowtype in pl sql?
Write the command to remove all players named sachin from the players table.
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
how to create a new view in mysql? : Sql dba
Why is partition used in sql?
What are the different types of triggers?
What pl/sql package consists of?
Which type of cursor is used to execute the dml statement?
How do I kill a query in postgresql?
Does truncate remove indexes?
differentiate between float and double. : Sql dba
How many types of privileges are available in sql?
What is type and rowtype in pl sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Can you join a table to itself?