How to find sequencer table of a primary key field

Friday, November 1, 2013

How to find sequencer table of a primary key field

How to find sequencer table of a primary key field 

SELECT *
  FROM dba_sequences a
  WHERE a.sequence_name LIKE '%SURROGATE_KEY_FIELD_NAME%' 

*** This is part of primary key

Error 404

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage