drop table t
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table t
(
instance number ,
id_sup number ,
id number ,
srt number ,
v01 number ,
v02 number ,
v03 number ,
value_01 number ,
value_02 number
)
Table created.
insert into t values (200,1,2,2,26,20,13,20,13)
1 row(s) inserted.
insert into t values (200,1,3,3,30,23,15,23,23)
1 row(s) inserted.
insert into t values (200,1,4,4,18,13,9,13,13)
1 row(s) inserted.
insert into t values (200,1,5,5,22,16,11,16,16)
1 row(s) inserted.
insert into t values (200,1,75,6,24,18,12,24,12)
1 row(s) inserted.
insert into t values (200,74,76,8,26,20,13,20,26)
1 row(s) inserted.
insert into t values (200,74,77,9,28,21,14,28,21)
1 row(s) inserted.
insert into t values (200,74,10,10,28,21,14,14,21)
1 row(s) inserted.
insert into t values (200,74,79,11,34,26,17,26,17)
1 row(s) inserted.
insert into t values (200,74,80,12,22,16,11,16,16)
1 row(s) inserted.
insert into t values (200,74,81,13,17,13,8,13,17)
1 row(s) inserted.
insert into t values (200,74,82,14,27,20,14,20,27)
1 row(s) inserted.
insert into t values (200,74,83,15,22,16,11,11,11)
1 row(s) inserted.
insert into t values (200,74,84,16,24,18,12,18,24)
1 row(s) inserted.
insert into t values (200,85,20,18,18,13,9,9,13)
1 row(s) inserted.
insert into t values (200,85,21,19,34,26,17,17,34)
1 row(s) inserted.
insert into t values (200,85,22,20,21,16,11,11,11)
1 row(s) inserted.
insert into t values (200,85,86,21,19,14,9,9,9)
1 row(s) inserted.
insert into t values (200,23,30,23,29,21,15,15,21)
1 row(s) inserted.
insert into t values (200,23,24,24,30,23,15,15,30)
1 row(s) inserted.
insert into t values (200,23,90,25,30,23,15,23,23)
1 row(s) inserted.
insert into t values (200,23,26,26,30,23,15,30,30)
1 row(s) inserted.
insert into t values (200,23,87,27,30,23,15,23,23)
1 row(s) inserted.
insert into t values (200,23,88,28,24,17,12,17,24)
1 row(s) inserted.
insert into t values (200,29,89,30,16,12,8,8,8)
1 row(s) inserted.
insert into t values (200,29,94,31,40,30,20,30,40)
1 row(s) inserted.
insert into t values (200,29,91,32,21,16,11,21,16)
1 row(s) inserted.
insert into t values (200,29,92,33,36,27,18,27,18)
1 row(s) inserted.
insert into t values (200,29,95,34,38,28,18,28,38)
1 row(s) inserted.
insert into t values (200,29,93,35,36,27,18,18,18)
1 row(s) inserted.
select *
from t
order by srt
INSTANCE | ID_SUP | ID | SRT | V01 | V02 | V03 | VALUE_01 | VALUE_02 | 200 | 1 | 2 | 2 | 26 | 20 | 13 | 20 | 13 | 200 | 1 | 3 | 3 | 30 | 23 | 15 | 23 | 23 | 200 | 1 | 4 | 4 | 18 | 13 | 9 | 13 | 13 | 200 | 1 | 5 | 5 | 22 | 16 | 11 | 16 | 16 | 200 | 1 | 75 | 6 | 24 | 18 | 12 | 24 | 12 | 200 | 74 | 76 | 8 | 26 | 20 | 13 | 20 | 26 | 200 | 74 | 77 | 9 | 28 | 21 | 14 | 28 | 21 | 200 | 74 | 10 | 10 | 28 | 21 | 14 | 14 | 21 | 200 | 74 | 79 | 11 | 34 | 26 | 17 | 26 | 17 | 200 | 74 | 80 | 12 | 22 | 16 | 11 | 16 | 16 | 200 | 74 | 81 | 13 | 17 | 13 | 8 | 13 | 17 | 200 | 74 | 82 | 14 | 27 | 20 | 14 | 20 | 27 | 200 | 74 | 83 | 15 | 22 | 16 | 11 | 11 | 11 | 200 | 74 | 84 | 16 | 24 | 18 | 12 | 18 | 24 | 200 | 85 | 20 | 18 | 18 | 13 | 9 | 9 | 13 | 200 | 85 | 21 | 19 | 34 | 26 | 17 | 17 | 34 | 200 | 85 | 22 | 20 | 21 | 16 | 11 | 11 | 11 | 200 | 85 | 86 | 21 | 19 | 14 | 9 | 9 | 9 | 200 | 23 | 30 | 23 | 29 | 21 | 15 | 15 | 21 | 200 | 23 | 24 | 24 | 30 | 23 | 15 | 15 | 30 | 200 | 23 | 90 | 25 | 30 | 23 | 15 | 23 | 23 | 200 | 23 | 26 | 26 | 30 | 23 | 15 | 30 | 30 | 200 | 23 | 87 | 27 | 30 | 23 | 15 | 23 | 23 | 200 | 23 | 88 | 28 | 24 | 17 | 12 | 17 | 24 | 200 | 29 | 89 | 30 | 16 | 12 | 8 | 8 | 8 | 200 | 29 | 94 | 31 | 40 | 30 | 20 | 30 | 40 | 200 | 29 | 91 | 32 | 21 | 16 | 11 | 21 | 16 | 200 | 29 | 92 | 33 | 36 | 27 | 18 | 27 | 18 | 200 | 29 | 95 | 34 | 38 | 28 | 18 | 28 | 38 | 200 | 29 | 93 | 35 | 36 | 27 | 18 | 18 | 18 |
---|