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
- 20527 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to get a create statement for an existing table?
What is a connect identifier?
How to delete a user account in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How many types of tables supported by oracle?
Explain coalesce function?
Why packages are used in oracle?
How to convert characters to dates in oracle?
Explain mutating triggers.
How to load a large xml file?
How to invoke the data pump import utility?
What is a subquery?
What happens to the current transaction if the session is ended?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How many categories of data types?
