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
- 4938 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 substr & instr functions?
How to rename a column in an existing table?
What is hash cluster in oracle?
What is the data pump export utility?
How to define a cusotmer as a supplier in ORACLE R12
How to list all tables in your schema?
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?
what is IDE,DMV in sql server?
What is a sub query? What are its various types?
What is the sid in oracle?
How do we get field detail of a table?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to create a table in a specific tablespace?
How to delete all rows a table in oracle?
How to connect to oracle using service name instead of sid?
