Rob van Wijk

Rob van Wijk has asked 4 questions and find answers to 116 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

Counting no. of records from multiple tables; Oracle DB
Oracle Hierarchical query: how to include top-level parent
Oracle Scalar function in select vs table valued function join
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?