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
How to write pl sql program in mysql command prompt?
What is delimiter sql?
Why left join is used in sql?
What are types of joins?
What is sql and db2?
How do you know if a relationship is 2nf?
How to run sql*plus commands in sql developer?
Explain the uses of a database trigger?
Can we have two clustered index on a table?
What are all types of user defined functions?
what is oracle database ? : Sql dba
What is a left inner join?
Does sql backup shrink transaction log?
What is a behavioral trigger?