How can get sequence Log (Object log) history,

Question

How can get sequence Log (Object log) history,

kailashIndia

SSC Eights!

Points: 935
More actions
June 26, 2017 at 2:39 am

#343350

How can get sequence Log (Object log) history, date ,minimum and max values for a day wise in Oracle Or SQL.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Could you explain more what you're looking for?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

kailashIndia SSC Eights! Points: 935 More actions · Answer 2

I want to output Like
example: sequence Name, sequence min value, max value, last mumber, input_date

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

Start with sys.sequences, which exposes most of the information you're looking for.

John

kailashIndia SSC Eights! Points: 935 More actions · Answer 4

sys.sequences can not date column, acually i required day wise.

kailashIndia SSC Eights! Points: 935 More actions · Answer 5

sys.sequences have not date column, acually we required day wise.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 6

kailashsingh85 - Monday, June 26, 2017 4:09 AM
sys.sequences have not date column, acually we required day wise.

sys.sequences has both create_date and modify_date as it inherits all columns from sys.objects
😎

kailashIndia SSC Eights! Points: 935 More actions · Answer 7

Eirikur Eiriksson - Monday, June 26, 2017 4:29 AM
kailashsingh85 - Monday, June 26, 2017 4:09 AM
sys.sequences have not date column, acually we required day wise.
sys.sequences has both create_date and modify_date as it inherits all columns from sys.objects
😎

Yes this contains create_date and modify_date but not stored history of sequences , show last modify_date

kailashIndia SSC Eights! Points: 935 More actions · Answer 8

kailashsingh85 - Monday, June 26, 2017 5:11 AM
Eirikur Eiriksson - Monday, June 26, 2017 4:29 AM
kailashsingh85 - Monday, June 26, 2017 4:09 AM
sys.sequences have not date column, acually we required day wise.
sys.sequences has both create_date and modify_date as it inherits all columns from sys.objects
😎
Yes this contains create_date and modify_date but not stored history of sequences , show last modify_date

any options to get object Log history..

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 9

kailashsingh85 - Monday, June 26, 2017 5:15 AM
kailashsingh85 - Monday, June 26, 2017 5:11 AM
Eirikur Eiriksson - Monday, June 26, 2017 4:29 AM
kailashsingh85 - Monday, June 26, 2017 4:09 AM
sys.sequences have not date column, acually we required day wise.
sys.sequences has both create_date and modify_date as it inherits all columns from sys.objects
😎
Yes this contains create_date and modify_date but not stored history of sequences , show last modify_date
any options to get object Log history..

SQL Server does not hold the history for objects, you'll have to implement this yourself.
😎

kailashIndia SSC Eights! Points: 935 More actions · Answer 10

Eirikur Eiriksson - Monday, June 26, 2017 6:12 AM
kailashsingh85 - Monday, June 26, 2017 5:15 AM
kailashsingh85 - Monday, June 26, 2017 5:11 AM
Eirikur Eiriksson - Monday, June 26, 2017 4:29 AM
kailashsingh85 - Monday, June 26, 2017 4:09 AM
sys.sequences have not date column, acually we required day wise.
sys.sequences has both create_date and modify_date as it inherits all columns from sys.objects
😎
Yes this contains create_date and modify_date but not stored history of sequences , show last modify_date
any options to get object Log history..
SQL Server does not hold the history for objects, you'll have to implement this yourself.
😎

thanks any options in oracle

kailashIndia SSC Eights! Points: 935 More actions · Answer 11

kailashIndia

SSC Eights!

Points: 935

June 26, 2017 at 6:36 am

#1948147

Thanks to all.......