Category: select

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

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

This is an extension for my previous post, how to not only submit via the next and previous links, but also via select. This might not be the best solutions, and improvements are possible, but it’s a good startpoint. We will replace the #TEXT#-variable of Apex with our own generated html-code. You need to add […]