SQL & PL/SQL

Hi,

I am using Oracle 9i .. I have a table, in which one particular column called vesting period is there ..which do have values like 33.34,30.23,33.10 or it can have only integers .. like 25, 25,25 ..Each value is separated by comma.

Now, I have to find out what type of value is present in the field through coding i.e does it contain floating number or only integers ..

Whatever be the value whether its floating or integer, I have to extract the whole value before comma ..

Can you suggest how to proceed

Regards



Hi all,

Apologies for asking in a wrong way .. I have a column called sal which is of varchar data type .. and which do have values either only integers (like 24, 23, 22 etc., as a string of values) or floating numbers (like 33.33, 33.23, 34.55 etc., as string of values) .. Now I dont know whether that column is having only integers or only floating numbers ..

Now each value in that column is being separated by comma .. now I want to extract the values (whether it is floating number or integers ) before comma


For example

The sample data for your persual


select * from test;

ENO ENAME SAL
------ -------------------- ------------------------
1 A 25,25,25
2 B 23,23,23
3 C 34,34,34
4 D 33.33, 32.23, 34.12
5 E 32.11, 44.12, 41.12


Can u suggest the solution

Regards

Message was edited by:
Seshu

Message was edited by:
Seshu

Message was edited by:
Seshu

Message was edited by:
Seshu