Allan

Allan has asked 4 questions and find answers to 69 problems.

Stats

About

Allan questions

Set "Start With" value for Oracle sequence dynamically
Pythonic Boolean Conversion
Identifying and Resolving Oracle ITL Deadlock

Allan answers

Oracle stored procedure - CASE v_Variable WHEN 'value' OR 'value' THEN
Can anyone help me with my pl/sql script to update/merge in the database
Declaring SYS_REFCURSOR and ROWTYPE in stored procedure
How to use a string as a variable in NOT IN clause?
When you do not need to close a cursor in oracle?
Merge join CARTESIAN
Why does this Oracle 10g SQL run slow only when I query a subquery with a where clause?
How to trim all columns in all rows in all tables of type string?
PLS-00540: Object not supported in this context while trying to compile package specification
If Else Statement within an inner join