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 – Explain Plan Basics & Brief History

Whenever a SQL statement is submitted to the database server (be it Oracle or SQL Server), the server generates an execution plan which it uses to get the data in a well-defined order. The engine that does this work is called the “optimizer”. History of optimizers: RBO – Rule based optimizer Back in the day, … Continue reading Oracle – Explain Plan Basics & Brief History

Oracle – Quick Tip – Run OS Commands Within SQL*Plus

There are occasions when you might have the need to run Operating System commands inside SQL*Plus either as part of a script or as an individual command. If you have something simple to run as part of your .sql file that makes your script, just run them as follows: Here is an example that ran … Continue reading Oracle – Quick Tip – Run OS Commands Within SQL*Plus