Thursday, 22 March 2012

How do i get the last generated Sequence number in Oracle

How do i get the last generated Sequence number in Oracle



SELECT fds.doc_sequence_id, fds.NAME, ds.sequence_name, fds.application_id,
       fds.audit_table_name, fds.TYPE, fds.table_name, fds.initial_value,
       ds.last_number
  FROM fnd_document_sequences fds, dba_sequences ds
 WHERE ds.sequence_name = fds.db_sequence_name
   AND ds.sequence_name = 'FND_DOC_SEQ_2116_S'

No comments:

Post a Comment