The demand of a recent customer is really abnormal .

A system number string is required , String by 3 Part composition , The first two are Pinyin abbreviations of Chinese characters , It's not difficult .

The last part is one 4 Pure number of digits from 0001~9999,

Every time you insert a piece of data, you have to judge whether 0001 Start to 9999 between , The first number that doesn't exist , If the number has been reached, it will not be repeated , Possible continuity ,( If it is not deleted, you only need to retrieve it every time max+1 that will do , However, it may be deleted in the middle , There is a disconnection , Then the newly inserted data must be filled in ).

Now the idea is to take a list , Sort by number , And then rownu Go and compare , And then rownum Compare it with his number number

rownum      ||    systemno

1             1

2             2

3             3

4             4

5             5

6             7

So find the first one rownum Unequal numbers are not impossible

select min(rn) from (
select rownum rn,bts_system_no from (select bts_system_no from bo_bts where
bts_system_no is not null
 order by to_number(bts_system_no))) where  rn < to_number(bts_system_no)

Basically, we can get the first number 6

©2019-2020 Toolsou All rights reserved,
Send love - A little romance for programmers VHDL—— Design of frequency divider Python Implementation of Hanoi Tower code It's over , Starting salary 30khtml+css+js Make a simple website home page QQ Login interface implementation Hill sorting of sorting algorithm ——c++ realization 【 Wechat applet learning 】 Netease music cloud code page implementation details Resume the 13th session python Blue Bridge Cup 2022 Solution to the 13th Blue Bridge Cup ( whole )