Oracle – Sync Any Sequence And Any Table Column In A Generic Fashion To Avoid ORA-00001

Table to Sequence relation Typically, you have tables that rely on a sequence for their PK. Almost all of the time the relationship between a table and its sequence is one-to-one. Often times, as releases are done with manual data inserts, not too much attention is paid to use the value from the sequence and … Continue reading Oracle – Sync Any Sequence And Any Table Column In A Generic Fashion To Avoid ORA-00001

Advertisements

Oracle Tip – Generate “N” rows of dates or numbers serially

Sometimes, you would have a situation where you need to generate a table with N number of rows that you can use as the basis to join and restrict other tables. For example, to get the 100 dates starting from a certain date as rows, a typical technique is to select ROWNUM from all_objects to … Continue reading Oracle Tip – Generate “N” rows of dates or numbers serially