Upgrade Oracle XE from 10 to 11: A word of caution

Finally I had some time to upgrade my Oracle XE database from version 10 to version 11, something I wanted to try out but could never find the time to do it. I wanted to try it out, to see if it all worked as advertised, usually it does. This time however I ran into some problems with the export and import of the APEX applications, good thing it was just on my sandbox database.

Splitting a comma delimited string the RegExp way, Part Two

Over two years ago I wrote about a way to split a comma delimited string using Regular Expresssions. Just a little while ago someone asked how to split it when you have more records involved than just one (as I used in my example).

Oracle 11g Express Edition bug?

Of course you know that Oracle has released 11g Express Edition, still in Beta though. That is probably why I ran into something weird -must be a bug- while playing with it. Here is what I did:

SQL> set echo on

SQL> col "Current_Edition" format a20

SQL> col object_name format a20

SQL> 

SQL> select sys_context('userenv'

  2                    ,'current_edition_name'

  3                    ) "Current_Edition"

  4    from dual

  5  /



Current_Edition                                                                                                         

--------------------                                                                                                    

ORA$BASE                                                                                                                



1 row selected.



SQL> 

SQL> create or replace

  2  procedure hello

  3  is

  4  begin

  5     dbms_output.put_line ('Hello World');

  6  end hello;

  7  /



Procedure created.



SQL> 

SQL> begin

  2     hello;

  3  end;

  4  /

Hello World                                                                                                             



PL/SQL procedure successfully completed.



SQL> 

SQL> select object_name

  2       , object_type

  3       , edition_name

  4    from user_objects_ae

  5   where object_name = 'HELLO'

  6  /



OBJECT_NAME          OBJECT_TYPE         EDITION_NAME                                                                   

-------------------- ------------------- ------------------------------                                                 

HELLO                PROCEDURE                                                                                          



1 row selected.



SQL>