adding to the above answer to_char function takes only the number value

select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL

why? pls help

Question Posted / rpk

6 Answers
20541 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

Please Help Members By Posting Answers For Below Questions

Please explain drop constraint oracle?

1026

Explain the types of exception?

1081

Does facebook use oracle?

979

Explain enable novalidate constraint.

1030

How to load data through external tables?

1070

What is recycle bin in Oracle?

1085

What is archive log in Oracle?

1068

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2396

How to define and use table alias names in oracle?

883

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1788

What are operators in oracle?

1009

Can select statements be used on views in oracle?

981

What is the difference between a user and a schema in oracle?

981

What is the purpose of save points in oracle database?

1004

What is recovery manager in Oracle?

992