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
- 20765 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
What the is the diff between local index and global index. give some example.
what are the default admin accounts in Oracle 10g ?
How to define a procedure inside another procedure?
What is logical backup in oracle?
Explain the use of Merge statement in oracle 11g
Is there a combination of "like" and "in" in sql?
what is Single Byte Overhead...?
Describe the types of sub query?
What is enter substitution variable in oracle?
How to create a stored program unit?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is difference between cartesian join and cross join?
ABOUT IDENTITY?
How to use "startup" command to start default instance?
How to test null values?
