Oracle quartz selectWithLockSQL value?

Question

I have this in my spring config for quartz....

<prop key="org.quartz.jobStore.selectWithLockSQL">SELECT * 
                                                    FROM {0} LOCKS WITH (UPDLOCK ROWLOCK) 
                                                   WHERE LOCK_NAME = ?</prop>`

That works fine for MS SQL Server, but I don't know what to use for Oracle.

Can anyone help me out please?

Answer 1

so what are you trying to do there? the syntax in Oracle to lock a row is:

SELECT * FROM <table_name> WHERE <condition> FOR UPDATE;