Answer Posted / r98
select to_char(sysdate,'ddsp-month-yyyysp') from dual;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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
What is the difference between nested table and varray?
Is sqlexception checked or unchecked?
How do you create a db file?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Which join condition can be specified using on clause?
Which operator is used in query for pattern matching?
What is the use of non clustered index?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
how to get help information from the server? : Sql dba
What is relationship? How many types of relationship are there?
Is sql a microsoft product?
Which is better varchar or nvarchar?
How do I count rows in sql query?
How do I use google cloud in sql?