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