Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Data conversion using sql

sagar pinnamaneniMar 14 2024 — edited Mar 14 2024

I have a column in a base table of varchar type which is expected to have only numbers( positive, negitive, decimal and zeros).But it also contains character values (e.g ‘SAMPLE’, ‘NODATA’) i am trying to create a view which uses this column and I want to replace any character type clues in the column to be replaced with 0 and leave the numbers as is.

How to achieve this?

Comments
Post Details
Added on Mar 14 2024
3 comments
69 views