Learning is not a spectator sport

Complete listing of posts

  • ORA-4068 and CONSTANT keyword…good and bad

    Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in a session due to a package variable, and then when you change the package, the state is cleared along with an ORA-4068.  Here’s a quick example:   Session 1 SQL> create or replace 2 package Read more

  • truncated ddl in 12c (and 11.2.0.4)

    Just curious if anyone else is seeing this behaviour.. SQL> set long 500000 SQL> @pt “select * from v$sql where sql_id = ‘1km492z723vpu’” SQL_TEXT : alter table scott.emp SQL_FULLTEXT : alter table scott.emp SQL_ID : 1km492z723vpu … Suffice to say, there’s a lot more to that SQL statement, but its lost in v$sql. Once complete, Read more

  • AUSOUG conference Perth

    The annual two day AUSOUG conference in Perth is well underway, and so far, its been a wonderfully successful event. In particular, we Australians are notorious for not really getting into the networking thing, so conferences often have a lot of ‘awkward silences’ when sessions are not on, and we are meant to be (god Read more

  • A simple 12c query with a cool result …

    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 2 where column_name like ‘%\_VC’ escape ‘\’ 3 and owner = ‘SYS’ 4 order by 1,2; TABLE_NAME COLUMN_NAME —————————— ———————- ALL_CONSTRAINTS SEARCH_CONDITION_VC ALL_VIEWS TEXT_VC CDB_CONSTRAINTS SEARCH_CONDITION_VC CDB_VIEWS TEXT_VC DBA_CONSTRAINTS SEARCH_CONDITION_VC DBA_VIEWS TEXT_VC INT$DBA_CONSTRAINTS SEARCH_CONDITION_VC INT$DBA_VIEWS Read more

  • Openworld

    Well, the annual spectacle of enormous proportions has come to a conclusion again. And thats probably the first reason I’d recommend OpenWorld to anyone who works with Oracle who has never been to it. It’s a jaw dropping moment just to see the scale of the event, and how impressively its organised in terms of Read more

  • Slides from OakTableWorld and OpenWorld

    Thanks to anyone that came along to my sessions at OpenWorld. You can review the slides via the links below: OakTable World Sep14 clonedb from Connor McDonald OpenWorld Sep14 12c for_developers from Connor McDonald   Read more

  • Openworld day minus 3

    Its day minus 3, or day +1 depending on your point of view at Openworld 2014. I’m here a few days early for the Ace Director briefings, where a selection of product managers provide an insight into what is coming in the Oracle world, either at Openworld or in the coming year. I must admit, Read more

  • Openworld bound..

    I’ll be in Openworld again this year, and have a couple of speaking slots… I’ll talk about new features for developers in 12c on Sunday, Sep 28, 2:30 Moscone South 303 https://oracleus.activeevents.com/2014/connect/sessionDetail.ww?SESSION_ID=2244 and of course, at the awesome Oaktable world.. http://www.oraclerealworld.com/oaktable-world/agenda/ Drop in, learn some cool things, or just pop up and say Hello! Read more

  • MERGE and IOT’s ….. unhappy bedfellows

    Anyone who has used Oracle for a while will be familiar with the Parent/Child locking “issue” when it comes to tables and indexes on foreign keys. For many years you’d hear people crying “bug” etc but thankfully most now know the reason, and accept it as sensible behaviour. But lets take a look at a Read more

  • 12c – Nested tables vs Associative arrays

    This was going to the be the immediate follow up to my previous post, but 12.1.0.2 came out and I got all excited about that and forgot to post this one 🙂 Anyway, the previous post showed how easy it is to convert between nested tables and associative arrays. The nice thing in 12c is Read more

  • 12.1.0.2 security grrr…

    One of my favourite security “tricks” used to be the following: SQL> [create|alter] user MY_USER identified by values ‘impossible’; Looks odd, but by setting the encrypted value of someone’s password to something that it is impossible to encrypt to, means you’ll never be able to connect as that account. (Think schema’s owning objects etc). I Read more

  • Associative arrays and Nested tables

    A common criticism of PLSQL is that the “original” array datatype, now called associative arrays are perfect for passing stuff back and forth to 3GL environments (for example .Net), but canno be used within SQL natively, for example: SQL> create or replace 2 package BLAH is 3 type num_list is table of number index by Read more