Interested to Buy Any Domain ? << Click Here >> for more details...
select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL
why? pls help
- 6 Answers
- 20858 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the advantages of oracle?
How to end the current transaction in oracle?
What is the scope of a local variable?
Is oracle a language?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to pass parameters to procedures?
What is recovery manager in Oracle?
what is IDE,DMV in sql server?
What is SQL access advisor in Oracle?
Difference between the “verify” and “feedback” command?
What is an oracle wallet?
What are the database administrators utilities available?
How many types of segments in Oracle?
How to get the Installed Oracle Version Information ?
How to fetch the row which has the max value for a column?
