DB Wiki

User Tools

Site Tools

Trace: • plsql_sequence
plsql_sequence

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
plsql_sequence [2016/10/05 14:45] – z0hpvkplsql_sequence [2016/10/05 14:45] (current) – z0hpvk
Line 22: Line 22:
  
 -- Check sequences are OK by running below SQL -- Check sequences are OK by running below SQL
-select owner, sequence_name, valueint ANDRACA_VALUE, valuepoc MOLBB_VALUE,+select owner, sequence_name, valueint 10g_VALUE, valuepoc 12c_VALUE,
        case when mod(ValueInt,2) = mod(ValuePOC,2) then 'ERROR'        case when mod(ValueInt,2) = mod(ValuePOC,2) then 'ERROR'
          else 'ODD EVEN SUCCESS'          else 'ODD EVEN SUCCESS'
plsql_sequence.1475678705.txt.gz · Last modified: (external edit)