Interested to Buy Any Domain ? << Click Here >> for more details...
Which Functions Using Integer ==> String's i.e 2 ==> Two...
Like that string's ==> integer values ? It is Possible ?
- 2 Answers
- 5049 Views
- Oracle, SAH, I also Faced
- E-Mail Answers
Answer Posted / rajesh.mca
Using To_char() function
ex: select sal , To_char(To_Date(sal,'j'),'jsp') as "Sal in
words" from emp
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is the difference between $oracle_base and $oracle_home?
What is an oracle function?
How can we find out the current date and time in oracle?
How to start your 10g xe server?
How to get execution path reports on query statements?
Why do we use bulk collect in oracle?
How many memory layers are in the oracle shared pool?
What is a subquery in oracle?
defination of bitmap index
How to convert dates to characters in oracle?
What are the differences between lov and list item?
How many data types are supported?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What happens in oracle commit?
