How to implement oralce with the serial number of the letter-CodePudding

Home > database > How to implement oralce with the serial number of the letter

How to implement oralce with the serial number of the letter

Time：10-01

As specified number of 4 yards starting field for 0001, when 9999 serial number for A001, when use A999 serial number to B001, analogy, when Z999 finished using the serial number to AA01... When AZ99 finished using the serial number to BA01... The largest number of ZZZZ, thank you ~ ~

CodePudding user response:

Triggers and functions can be realized, the original poster said it which use scenarios,

Page link：https//www.codepudding.com/database/45125.html

Prev:Oracle 12 c across a network connection

Next:The table which is more efficient segmentation and table partitioning

Tags：

The development of

Links：
CodePudding