Re: Using date and increment as row id
Compound-value columns run afoul of the basic atomicity rule of relational databases. A compound key like (year.month.index) is best implemented as an index defined with year, month and incrementing index columns. Elementary SQL easily displays the compound value wherever required.
You asked this question a week ago and evidently didn't like the answer, so please tell us what problem you think you are solving by combining such values in one column.
Subject
Written By
Posted
Re: Using date and increment as row id
June 10, 2021 11:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.