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!

How to replace a date by a null value ?

Christian PitetJul 24 2017 — edited Jul 25 2017

Hi

In the table EMP, there is a column named "HIREDATE". I would like to replace the date value '17/12/80' (format DD/MM/YYYY) in the output of the select statement by a null value. How to do ?

As the table EMP is provided as an example with Oracle DB, I think you may all have this table in your DB.

Regards.
This post has been answered by Frank Kulash on Jul 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2017
Added on Jul 24 2017
11 comments
9,686 views