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'
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