Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE USU_TDRILOC 
(USU_CODEMP NUMBER(4,0), 
	USU_CODFIL NUMBER(5,0), 
	USU_SIGFAB VARCHAR2(3), 
	USU_CODDRI VARCHAR2(5), 
	USU_CODLOC VARCHAR2(5), 
	USU_SITLOC VARCHAR2(1), 
	USU_CODLOT VARCHAR2(50), 
	USU_CODPRO VARCHAR2(14), 
	USU_SUGLET VARCHAR2(5), 
	USU_SOMEST VARCHAR2(1), 
	USU_SEQITE NUMBER(4,0), 
	USU_QTDEST NUMBER(14,5), 
	USU_CODDER VARCHAR2(7), 
	USU_MESLOT VARCHAR2(7)
);
Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','555','2B','A','T7538/W2','25806',' ',' ',1,0,' ',' ');
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','561','4A','A','FB 23867-03','00001',' ',' ',1,0,' ',' ');
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','4B','A',null,'00002',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','4A','A',' ','08974',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','3B','A',' ','25299',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','3A','A',null,'00001',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','2B','A','M 7382-01','00001',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','2A','A',' ','00001',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','1B','A',' ',' ',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','091','1A','A',' ',' ',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','4B','A',null,'00001',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','4A','A',' ','00001',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','3B','A',null,'25300',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','3A','A',' ','00001',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','2B','A',' ','00002',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','2A','A',' ','00002',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','1B','A',' ',' ',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','092','1A','A',' ',' ',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','093','4B','A',null,'25300',' ',' ',1,null,null,null);
1 rows affected

Insert into USU_TDRILOC (USU_CODEMP,USU_CODFIL,USU_SIGFAB,USU_CODDRI,USU_CODLOC,USU_SITLOC,USU_CODLOT,USU_CODPRO,USU_SUGLET,USU_SOMEST,USU_SEQITE,USU_QTDEST,USU_CODDER,USU_MESLOT) values (1,1,'ITA','093','3B','A',null,'00002',' ',' ',1,null,null,null);
1 rows affected

SELECT * FROM (SELECT USU_TDRILOC.*, row_number() over (ORDER BY USU_CODEMP, USU_CODFIL, USU_SIGFAB, USU_CODDRI, USU_CODLOC, USU_SEQITE) line_number FROM USU_TDRILOC) WHERE line_number BETWEEN 0 AND 20 ORDER BY line_number


USU_CODEMP
USU_CODFIL
USU_SIGFAB
USU_CODDRI
USU_CODLOC
USU_SITLOC
USU_CODLOT
USU_CODPRO
USU_SUGLET
USU_SOMEST
USU_SEQITE
USU_QTDEST
USU_CODDER
USU_MESLOT
LINE_NUMBER


1
1
ITA
091
1A
A
 
 
 
 
1
null
null
null
1

1
1
ITA
091
1B
A
 
 
 
 
1
null
null
null
2

1
1
ITA
091
2A
A
 
00001
 
 
1
null
null
null
3

1
1
ITA
091
2B
A
M 7382-01
00001
 
 
1
null
null
null
4

1
1
ITA
091
3A
A
null
00001
 
 
1
null
null
null
5

1
1
ITA
091
3B
A
 
25299
 
 
1
null
null
null
6

1
1
ITA
091
4A
A
 
08974
 
 
1
null
null
null
7

1
1
ITA
091
4B
A
null
00002
 
 
1
null
null
null
8

1
1
ITA
092
1A
A
 
 
 
 
1
null
null
null
9

1
1
ITA
092
1B
A
 
 
 
 
1
null
null
null
10

1
1
ITA
092
2A
A
 
00002
 
 
1
null
null
null
11

1
1
ITA
092
2B
A
 
00002
 
 
1
null
null
null
12

1
1
ITA
092
3A
A
 
00001
 
 
1
null
null
null
13

1
1
ITA
092
3B
A
null
25300
 
 
1
null
null
null
14

1
1
ITA
092
4A
A
 
00001
 
 
1
null
null
null
15

1
1
ITA
092
4B
A
null
00001
 
 
1
null
null
null
16

1
1
ITA
093
3B
A
null
00002
 
 
1
null
null
null
17

1
1
ITA
093
4B
A
null
25300
 
 
1
null
null
null
18

1
1
ITA
555
2B
A
T7538/W2
25806
 
 
1
0
 
 
19

1
1
ITA
561
4A
A
FB 23867-03
00001
 
 
1
0
 
 
20

USU_CODEMP	USU_CODFIL	USU_SIGFAB	USU_CODDRI	USU_CODLOC	USU_SITLOC	USU_CODLOT	USU_CODPRO	USU_SEQITE	USU_QTDEST	USU_CODDER	USU_MESLOT	LINE_NUMBER
1	1	ITA	091	1A	A			1	null	null	null	1
1	1	ITA	091	1B	A			1	null	null	null	2
1	1	ITA	091	2A	A		00001	1	null	null	null	3
1	1	ITA	091	2B	A	M 7382-01	00001	1	null	null	null	4
1	1	ITA	091	3A	A	null	00001	1	null	null	null	5
1	1	ITA	091	3B	A		25299	1	null	null	null	6
1	1	ITA	091	4A	A		08974	1	null	null	null	7
1	1	ITA	091	4B	A	null	00002	1	null	null	null	8
1	1	ITA	092	1A	A			1	null	null	null	9
1	1	ITA	092	1B	A			1	null	null	null	10
1	1	ITA	092	2A	A		00002	1	null	null	null	11
1	1	ITA	092	2B	A		00002	1	null	null	null	12
1	1	ITA	092	3A	A		00001	1	null	null	null	13
1	1	ITA	092	3B	A	null	25300	1	null	null	null	14
1	1	ITA	092	4A	A		00001	1	null	null	null	15
1	1	ITA	092	4B	A	null	00001	1	null	null	null	16
1	1	ITA	093	3B	A	null	00002	1	null	null	null	17
1	1	ITA	093	4B	A	null	25300	1	null	null	null	18
1	1	ITA	555	2B	A	T7538/W2	25806	1	0			19
1	1	ITA	561	4A	A	FB 23867-03	00001	1	0			20