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
- 20850 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the type of synonyms?
How to create a table index?
What are the uses of synonyms?
Explain the use of online redo log files in oracle.
What is redo log?
What are the tools for Oracle ?
What happens to indexes if you drop a table?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What happens if the imported table already exists?
How to find the duplicate rows count from employees table in oracle?
what is IDE,DMV in sql server?
What is an oracle table?
Why packages are used in oracle?
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?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
