Oracle quartz selectWithLockSQL value?

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

<prop key="org.quartz.jobStore.selectWithLockSQL">SELECT * 
                                                    FROM {0开发者_Go百科} 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?

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;