Oracle gets the desired data analysis from string resources

Oracle gets the desired data analysis from string resources the Requirements: order analysis, analyze the trend of various transaction data according to the game, account level, game account occupation, regional server, and price range. Target: order table (order) Processing analysis: The indications that can be read directly in the order include the game, regional server, and price. And there are already relevant configurations that can be associated with this class information. Problem Analysis 1: Account occupation, account level and other transaction information are not marked in detail in the order, and can only be obtained through other information Pick. the Solution 1: Analyze the occupation and account level roughly through the title in the order. The format of the title is as follows: the Processing idea: extract the occupation and account level from the title. Profession: substr (www.2cto.com o5.bizooffername, instr(o5.bizoffername, ”【’,1,1)+1, instr(o5.bizoffername,' ',1,1)-(instr(o5.bizoffername,'【',1,1)+1) ) level: substr ( o5.bizooffername, instr(o5. bizoffername, ”, ”, 1, 3)+1, instr(o5.bizoffername,'level',1,1)-(instr(o5.bizoffername,' ',1,3)+1) ) The processing result is shown in the figure: the Problem Analysis 2: Levels like ’50’ are extracted from strings and compared with account level interval dimensions as parameters invalid characters occur. Processing idea 2: Decisively think of converting characters into numbers, to_number. Problem…