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!

determine an decimal in a data set without looking at the data

user13328581Apr 1 2015 — edited Apr 1 2015

Hello Experts;

I have a data set similar to this below

create table test

(

     id number(30),

     info varchar2(1000)

);

insert into test values (1, '9.4');

insert into test values (2, '10.350');

insert into test values (3, '6.987');

I need a way to determine without looking at the data which of the column contains the decimal values. In this case, it is the info column even though it is created as as a varchar2. All help is appreciated. Thank you

This post has been answered by John Spencer on Apr 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2015
Added on Apr 1 2015
24 comments
3,383 views