In this post I will put 5 other new 12c features in the spotlight (in addition to the features of a previous post), that really makes the 12c an improvement against the previous versions of the Oracle database. To get this result I listed up all the major new features and wanted to know my […]

This battle for all the Oracle Partners in Belgium and the Netherlands is organized by Oracle (Yves Van Looy(BE) and Charles Billar(NL)). All employees of these Oracle Partner companies can compete to be the Oracle smartest of their company for that year. Just like last year, the contest was also aiming to provide an in-depth […]

I already managed to remove the Dbms Output pane a couple of times from my SQL Developer, probably by doing a keyboard combination by accident.I am not sure how I did this and I can’t really reproduce this but sometimes I was bugged with this problem. Problem is that I can’t get this pane back […]

What should you do if you have an anydata column in a queue table and you don’t have any tool to read from it(sqldeveloper doesn’t support it natively)? I have written some code to extract all the information from such a column and print it, whatever the content would be. You can find out more

Something I really often use is this select: SELECT distinct type,line,name,text FROM user_source WHERE lower(Text) LIKE(‘%’||lower(:search_source)||’%’) UNION SELECT distinct ‘column’ type,null line,table_name||’.’|| COLUMN_NAME name,null FROM user_tab_columns WHERE lower(COLUMN_NAME) LIKE(‘%’||lower(:search_source)||’%’) UNION SELECT  DISTINCT ‘table’ type,null line,object_name name,null from user_objects WHERE object_type IN  (‘TABLE’,’VIEW’) AND lower(object_name) LIKE(‘%’||lower(:search_source)||’%’) ORDER BY type,name,line This select will show you most of […]

When you try to convert an xml file, which has a tag that contains for example one or more pdf files, into an XMLTYPE object, you will get the following error: ORA-19011: CHARACTER string BUFFER too small This error will be thrown because the content of a tag of an XMLTYPE is limited to 4000 […]

For a project with Oracle Portal, I had to do some lookups in packages and procedures on the database to get some information about the project.   Since I wasn’t working full-time for this project I had no access to the DB, except via the portal itself. Several times I had the problem that the client wanted a quick […]