PL/SQL (MOSC)

MOSC Banner

How to select range of data from the column 'WO_NOS'

edited Mar 22, 2020 4:12AM in PL/SQL (MOSC) 4 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center