Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiples TO_CHAR

b1e9fd4b-1906-488d-a164-d698ae9e2abaJun 10 2020 — edited Jun 11 2020

My version: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

Why can't you convert the same column more than once without causing problems?

It's just an example, I could do:

   TO\_CHAR(PROD.Descricao) || '-A'  AS A,

   TO\_CHAR(PROD.Descricao) || '-B'  AS B

And it would give equal problem.

01.png

02.png
Comments
Post Details
Added on Jun 10 2020
16 comments
1,124 views