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 |
Explain the types of exception?
what is difference between table and view? where to use views? thanks in advance!
How do I escape a reserved word in oracle?
6. Display the client name and order date for all orders using the traditional method.
Can a formula column be obtained through a select statement ?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
What privilege is needed for a user to connect to oracle server?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
what is null value?
How to lock and unlock a user account in oracle?
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,