Sequence number in JDBC

[malathi2608]

Hello All,

I wanted to get a PK sequence/Sequence number from the database. i was just given with this information and when i searched about it in blogs mostly the sequence number were fetched from DUAL table. But i only see dummy field for DUAL table while doing lookup. Please provide your suggestion here or am i missing any information to get sequence number?

Many Thanks,

Malathi

[JamesZ]

Dear Malathi,

Do you need database level sequence? I am afraid we should create our own sequence:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6015.htm

What do you mean by "But i only see dummy field for DUAL table while doing lookup."? Maybe give some screenshots to describe it?

Best regards,

James