Allan

Allan has asked 5 questions and find answers to 76 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 11g - FOR loop that inserts only weekdays into a table?
PL/SQL EXECUTE IMMEDIATE inside LOOP (procedure to truncate all tables in schema)
Shortening nested SQL Query
How can you tell which columns are unused in ALL_TAB_COLS?
SQLServer Subquery units as column
Different table fields in one result set Oracle
Oracle - Materialized View, can this MV be fast refreshable?
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