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
- 20846 Views
- I also Faced
- E-Mail Answers
Answer Posted / rpk
adding to the above answer to_char function takes only the
number value
i.e select to_char(10) from dual;
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is transport network substrate (tns) in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to update values in a table in oracle?
How to return top 5 rows in oracle?
What is a cursor variable?
When do you get a .pll extension in oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is a Garbage Collection? and what is full recursive Garbage collection?
How do I start tns listener?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to use null as conditions in oracle?
Why do we need oracle client?
What is a parameter file in oracle?
