Skip to Main Content

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!

What to do when column name is same with function

SainaaMay 10 2020 — edited May 11 2020

I have problem running query when my column name is called date.

select * from table1

WHERE to_char(DATE,'yyyymmdd')>='20200101'

This post has been answered by mathguy on May 10 2020
Jump to Answer
Comments
Post Details
Added on May 10 2020
8 comments
4,121 views