Month: July 2010

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

In ApEx 4.0, when working with a map region (World without Greenland) (Map world/world_wo_gr.amap) you might experience that not all data points are correct. For example: when you work with the map “World without Greenland” and you choose a query with Series Type of Bubble, Switzerland is positioned in America while Spain is in the […]

I remembered an old post of Roel Hartman where he integrated a form into apex. He used a part of OraFormsFaces by Wilfred van der Deijl: the CommunicatorBean. Using this CommunicatorBean forms could react on “external messages”. Now with Forms 11g reacting on external events, this CommunicatorBean isn’t necessary any more(sorry Wilfred). This is how […]

People attending Open World to have a closer look at fusion technologies and how to integrate them in your existing applications, need to check out the following session: ID#: S315945 Title: Oracle Forms in the Middle of Middleware with Oracle Product Management Track: Application Servers, Application Grid, and Development Date: 22-SEP-10 Time: 13:00 – 14:00 […]

Since we’re talking about Forms 11g, the first question we get from customers is “Until when is Forms supported?”. I saw the blog post of Gerd Volberg and thought is was interesting to share this with our readers. Extended support for Forms 11g(and reports): June 2017. Complete information on Fusion Middleware support: Lifetime support Middelware […]

Team development is one of the new features of APEX 4.0, one option to use with this feature is Feedback. In short, Feedback allows users to easily report “bugs” for an application. (Like we APEX developers can program bugs… NOT!). There are already 2 blog posts that cover the way you can add a feedback […]

Introduction: Oracle Business Intelligence Enterprise Edition 11g, the new, industry-leading technology platform for business intelligence, which offers: – A powerful end-user experience with rich visualisation, search, and actionable collaboration – Advancements in analytics, OLAP, and enterprise reporting, with unmatched performance and scalability – Simplified system configuration, life-cycle management, and performance optimisation A first impression of […]