Rob van Wijk

Rob van Wijk has asked 4 questions and find answers to 113 problems.

Stats

About

Rob van Wijk questions

Why does dbms_sql.parse containing incorrect PL/SQL block with bind variables succeed unexpectedly?
Using sed to replace numbers
Cycle detection with recursive subquery factoring

Rob van Wijk answers

Is using "select *" for a cursor in PL/SQL considered bad programming?
Oracle SQL group by cube with distinct ID
Hierarchical query with min value calculated at each level in Oracle
Why is Oracle using a skip scan for this query?
Is there a way to do an INSERT INTO SELECT statement while specifying a commit count?
Oracle - Parameterized Query has EXECUTIONS = PARSE_CALLS
Is there an efficient way to avoid UNIONs of fixed values in SQL?
Oracle: normalized fields to CSV string
How can I implement this a recursive join in a group between two tables?
Exracting substring from given string