select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL
why? pls help
Answers were Sorted based on User's Feedback
Answer / mohammad islam
The format is to_char('10','0,999.99')
or to_char(10,'0,999.99')
What is the meaning of it? It means 10 has to be 4 digit
long number with comma after the first digit and 2 digit
decimal places
like 0,010.00
But for to_char('10','0999.99'), the result would be
0010.00 because 4 digit before the decimal place with no
comma and 2 digit after the decimal place
And for TO_CHAR(1230,'00,999.99'), the result is
01,230.00(as you see 5 digit before decimal and 2 digit
after decimal and comma after 2 digit.
I hope it will clear everything
Thanks,
Mohammad Islam
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / avinash
To_char function accepts only 1 parameter.
So the syntax should be as follows.
select TO_CHAR(10) from dual;
Is This Answer Correct ? | 16 Yes | 6 No |
Answer / 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 |
Answer / neha k
to_char function can take both Number and String Values but
one at a time.
ie. select to_char(10) from dual;
select to_char('10') from dual;
both are valid.
Another form of overloaded function to_char accepts two
arguments first is Date and second if its format in which
it needs to be converted as string.
ie. select to_char(sysdate,'YYYYMMDD') from dual;
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kanan
in this query first 10 is value you want to convert to
character and second value is format ;format can
be '9999.99' or '09999.99' but '10' is not valid
format .you should be thorough at the formats used on
to_char before implementing this .To_char can take upto
three parameters .
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / rpk
adding to the above answer to_char function takes only the
number value
i.e select to_char(10) from dual;
Is This Answer Correct ? | 3 Yes | 3 No |
What is difference between sid and service name in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Name the various constraints used in oracle?
What is a nested table?
What is a nvl function?
How to do paging with oracle?
Explain the use of control file?
How to recover a dropped table in oracle?
Can we insert data in view oracle?
How to recover a dropped index?
How many types of auditing in Oracle?
how to get the no employee in each department including the dept which has 0 employee