How to select range of data from the column 'WO_NOS'
Hi All,CREATE TABLE WOS_MISSING_WO_NOS( COMPANY_ID VARCHAR2(2 BYTE), USER_ID VARCHAR2(10 BYTE), WO_NOS VARCHAR2(32000 BYTE), WO_COUNT NUMBER)/Insert into WOS_MISSING_WO_NOS (COMPANY_ID, USER_ID, WO_NOS, WO_COUNT) Values ('01', 'SUPER', '190141013, 190141088, 190141125, 190141133, 190141149, 190141154, 190141162, 190141168, 190141185, 190141297, 190141301, 190141302, 190141303, 190141308, 190141309, 190141310, 190141311, 190141316, 190141317, 190141318, 190141323, 190141324, 190141325, 190141330, 190141331, 190141332, 190141333, 190141338, 190141339, 190141340, 190141345, 190141346, 190141347, 190141348, 190141349, 190141501, 190141502, 190141504, 190141505, 190141506, 190141508, 190141509, 190141510, 190141513, 190141514, 190141517, 190141518, 190141522, 190141523, 190141524, 190141525, 190141526, 190141528, 190141529, 190141533, 190141534, 190141537, 190141538, 190141541, 190141542, 190141545, 190141546, 190141547, 190141550, 190141555, 190141612, 190141629, 190141641, 190141669, 190141701, 190141702, 190141703, 190141704, 190141707, 190141708, 190141710, 190141711, 190141712, 190141713, 190141714, 190141716, 190141717, 190141718, 190141719, 190141720, 190141721, 190141722, 190141723, 190141724, 190141725, 190141728, 190141729, 190141730, 190141731, 190141732, 190141733, 190141735, 190141738, 190141739, 190141740, 190141741, 190141742, 190141743, 190141744, 190141745, 190141746, 190141747, 190141748, 190141749, 190141750, 190141753, 190141781, 190141790, 190141801, 190141824, 190141901, 190141936', 117);COMMIT;
----Please help me,How to select range of data from the column 'WO_NOS'
Select Company_id,User_idFrom Wos_Missing_Wo_NosWhere Company_Id = :repCompanyId And User_Id = :repUser and WO_NOS between '190141317' and '190141332'
Query result something like
Thanks and Regards,
PKR
1