Category: SQL Developer

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 […]

I have recently been playing with SQLdeveloper and came around an interesting feature: you can group connections in folder. This will prevent you from having a very big list of connections. To group your connections you must do the next thing:1. Select two or more connections2. Press your right mouse button3. Choose “Add To Folder” […]

In December you have probably read on this blog about our “Oracle for Newbies” seminar. As posted there we wanted to convince newbies that Oracle is not expensive, nor difficult. With free Oracle products (Oracle XE database, Application Express and SQL Developer) we showed how fast you can set up flexible database structures and professional […]

On Wednesday iAdvise gave an Oracle seminar at the headquarters of Oracle Belgium in Brussels. That’s not THE big news of course, but for this seminar our audience was different. This time we focused the “newbies”, people who‘ve never or hardly heard about Oracle. With this seminar we wanted to debunk the myths that: Oracle […]

Recently I switched from Windows XP to Windows Vista, ignoring all pro’s and contra’s for upgrading my OS, I had a problem when I used SQLdeveloper. When you edit a package and try to scroll between the code then it became unreadable: After some research I came across an excellent tip on the java2go blogspot. […]

SQL Developer and BLOBs SQL Developer is a very complementary tool to Apex.Although, you can do all basic SQL stuff via the SQL Workshop in Application Express, sometimes you need a more powerful tool like SQL Developer, especially when you really need to ‘develop’ in SQL and PL/SQL. One of the SQL features I like […]