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
- 20767 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
How to create a table in a specific tablespace?
How to use "in out" parameter properly?
Can we commit inside a function in oracle?
What is a schema in oracle?
How to return top 5 rows in oracle?
What is Undo Management Advisor in Oracle?
Where are the settings stored for each instance in oracle?
How data locks are respected in oracle?
What happens if the imported table already exists?
Can we connect to ORACLE db using Windows Authentication?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Will you be able to store pictures in the database?explain.
Why do we use bulk collect in oracle?
How does the on-delete-cascade statement work?
types of indexes and the rationale behind choosing a particular index for a situation.
