Inappropriate behaviour
You pick up little funny things in the day to day with Oracle. Like this one when you try to
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
Video 2: Ranking rows https://livesql.oracle.com/apex/livesql/s/ch1tefsz0mc75pk4ix2jbfja7 Video 3: More options for ranking rows https://livesql.oracle.com/apex/livesql/s/clebs8f5n4kr2b3vjvnvvgxkn Video 4: Using the Tabibitosan method for
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
Well, the annual spectacle of enormous proportions has come to a conclusion again. And thats probably the first reason I’d
Thanks to anyone that came along to my sessions at OpenWorld. You can review the slides via the links below: