Oracle SQL TO_CHAR Function return values

Question

I don't understand why these two code results are identically the same? I thought if I have quotes it just concatenate strings. Why not first one is 300.5100? I know second one is 400.5 anyway. Thank you

Select to_char('300.5' + '100') From Dual;

Select to_char(300.5 + 100) From Dual;

user330315 · Accepted Answer · 2017-12-13 22:40:06Z

4

To concatenate strings in SQL you have to use ||. The + is only there to add numbers. If you didn't pass '300.5' + '100' you would simply get an error, e.g. the following is invalid SQL:

select '300.5' + '100'
from dual;

But as to_char() expects a number as the input parameter Oracle implicitly converts those strings to numbers and then adds them, just like in the second statement.

answered Dec 13, 2017 at 22:40

user330315

Sign up to request clarification or add additional context in comments.

Comments

Randy · Accepted Answer · 2017-12-13 22:39:59Z

3

concatenation is

'xxx' || 'yyy'

your example allows the literals to be converted to numeric then treated as normal numbers.

answered Dec 13, 2017 at 22:39

Randy

16.7k2 gold badges40 silver badges56 bronze badges

Collectives™ on Stack Overflow

Oracle SQL TO_CHAR Function return values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related