select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL
why? pls help
Answer Posted / kumar
We can use TO_CHAR function in two ways.
1. To convert a number into a character.
TO_CHAR(-) will take one parameter i.e, number
2. To convert a date into a character.
TO_CHAR(-,-) will take two parameters
i) first parameter is the date
ii) Second parameter is format in which we have to
convert, that to the second parameter should be enclosed
with single Quotes.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different type of segments?
What happens to the current transaction if the session is ended?
What is the database name in oracle?
Explain what does a control file contain?
ABOUT IDENTITY?
What is a tns service name?
What is program global area (pga) in oracle?
How to best split csv strings in oracle 9i?
how the indexes are stored in the Oracle Database?
How are extents allocated to a segment?
how to handle exceptions in post production
How to update a table row with a record?
How to run the anonymous block again?
How to drop an index in oracle?
What is Reduced List of Values?