clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36289 in the last week).

create table test_t(num_col number);
 hidden batch(es)


insert into test_t(num_col) values(7045069949);
1 rows affected
 hidden batch(es)


insert into test_t(num_col) values(9449087591);
1 rows affected
 hidden batch(es)


select num_col, mod(num_col, 100) from test_t;
NUM_COL MOD(NUM_COL,100)
7045069949 49
9449087591 91
 hidden batch(es)