Learning is not a spectator sport

RETURNING BULK COLLECT and database links

Looks like the nice PL/SQL facility for returning a set of updated rows is restricted when it comes to database

I encountered this during some testing – the optimizer can be a little overzealous when it encounters nested group-by’s SQL>

You pick up little funny things in the day to day with Oracle. Like this one when you try to

I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when

We had an interesting issue on 12.1.0.1, where users were reporting very slow performance on queries to external tables. When

Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in

Just curious if anyone else is seeing this behaviour.. SQL> set long 500000 SQL> @pt “select * from v$sql where

The annual two day AUSOUG conference in Perth is well underway, and so far, its been a wonderfully successful event.

Its not immediately obvious the significance of this query…but trust me…you’ll love it 🙂 SQL> select table_name, column_name from dba_tab_cols