Differences

This shows you the differences between two versions of the page.

--- sequenceother [2016/05/29 10:13] – created z0hpvk
+++ sequenceother [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+==== PL/SQL for Other Objects ====
+Below is the code required in order to create ...
+  * Database Links
+  * Tables
+  * Scheduled Jobs
+... for sequences in a bi-directional format.
 <code>-- Create on 10g Database
-Create public database link ggint
+Create public database link ggmolbb
 connect to ggate identified by ggate123
-using ‘molintpc’;
+using 'molintpc';
 -- Create on 12c Database
-Create public database link ggpoc
+Create public database link ggandraca
 connect to ggate identified by ggate123
-using ‘molinta’;
+using 'molinta';
 Create table sync_sequences_log (owner varchar2(20), sequence_name varchar(50),
@@ Line 15: / Line 22: @@
 Create table mol_gg_sequences (owner varchar2(20), sequence_name varchar(100),
                                valuint number(12), valuepoc number(12));
+-- Example Scheduled Job that runs every hour to keep sequence values in sync.
 BEGIN
 DBMS_SCHEDULER.create_job (