Moving Elements in a Cascading Shuttle

Since APEX 4.0 cascading feature is a part of the standard. Not only a "normal" select list can be cascading but also a shuttle element. In this example I am showing how to filter a shuttle box and move the filtered values to the right side using just one (more...)

CLOB Plugin

There is a new plugin available which makes it possible to save and render contents larger than 32k. This limitation was one of the most critical in APEX. I remember several projects where we had to create workarrounds to solve that issue. Now, there is no need to write your (more...)

APEX Deep Linking, Authentication and Special Characters

It seem that there is a bug in APEX regarding deep linking, authentication and parsing special characters. See this thread. In this example I am showing a simple workarround which could be also applied in other similar situations where you need to transfer information using URL.




Mark your calendars: May 14 ODTUG’s Expert Panel on APEX !

On May 14, the second online ODTUG's Expert Panel will take place. 
This time it's all about Oracle Application Express!!

So tune in on May 14, at 12:00 EDT (that's 5PM in the UK, 6PM CET).

The panelists are: Dietmar Aust, Dan McGhan and myself. 
Patrick Cimolini will (more...)

Join me at ODTUG’s Expert Panel – Oracle Application Express

In May, I will take part in one of ODTUG's webinars:

Tuesday, May 14, 2013 12:00 PM - 1:00 PM EDT

ODTUG's Expert Panel - Oracle Application Express
 

Panelists: Dietmar Aust (Opal Consulting), Roel Hartman (APEX Evangelists ), Dan McGhan (Enkitec)
Moderator: Patrick Cimolini (Patrick International APEX Consulting) 


(more...)

jQuery – my first functions

I still remember how hard it was to make something like this working before the APEX version 4.0. You needed to create a function and then attach it to each column in your tabular form. Debugging and making changes is the next issue you had to think about. Now, (more...)

Controlling Hide/Show Apex Regions Using Javascript

Hide/Show regions are very useful in that they allow users to hide certain on-screen content when it’s not relevant for them (and show it again just as easily) simply by clicking the small arrow icon in the top left of the region.

Image

 

But how can you programmatically do the (more...)

Advanced Javascript Tutorial

Today I came across a great interactive tutorial which covers a series of advanced Javascript topics. It’s very well put together and lets you try out your own variations of the code being shown which can be very handy in making sure your understanding is correct.

It’s from John Resig, (more...)

How to make your browser save your password

Typically and for good security reasons the password manager from either Firefox or any other browser will not prompt you to save the password for the login screen of the APEX workspace or any of your own APEX applications.



Why? The APEX team implemented the login page with the HTML (more...)

Oracle Cloud World – London May 14th & Munich May 15th


I’ll be presenting Oracle Application Express as part of the Oracle Database Cloud Service at the Cloud World events in London and Munich next month.

At Oracle Cloud World you’ll hear from Oracle executives, thought leaders, customers, and partners as they share ideas on how to transform business and stay (more...)

New book: Oracle Application Express for Mobile Web Applications


Very recently a new book came out: "Oracle Application Express for Mobile Web Applications". This book is aimed at developers with some knowledge of APEX and want to know more about building web applications with APEX (of course) especially aimed at mobile devices (iPhone, iPad, and other brands of smartphones (more...)

Restoring a dropped table

ImageCatastrophe! You’ve just accidentally dropped a table which contained really rather important data. What to do?

One thing you can do to recover the situation quickly (if you’re running 10g or later, that is) is to run the following command:

FLASHBACK TABLE MY_SCHEMA.MY_SUPER_IMPORTANT_TABLE TO BEFORE DROP;

If the table (more...)

Great Lakes Oracle Conference – May 14/15, 2013

The Great Lakes Oracle Conference will be held on May 14/15, 2013 at the Cleveland State University campus.  Registration includes two full days of training with more than 30 sessions to choose from, vendor exhibits to peruse, lunches, and a networking reception.  And if that weren't enough, there will be (more...)

A beautiful weather app for Brazil and Portugal

Share

Last post I wrote about evolution. Professional evolution… from legacy technology  to new IT paradigms, cloud and mobile. This week, as a result of that evolution, the weather app I  developed with a friend, was deployed and it’s available at App Store.

I hope users from Portugal and Brazil find (more...)

Generate DDL Source Code with SQL

I just found this little piece of code to create DDL source code.

SELECT dbms_metadata.get_ddl(replace(OBJECT_TYPE, ' ', '_'), OBJECT_NAME,OWNER) as DDL_SOURCE_CODE
FROM ALL_OBJECTS
WHERE OBJECT_TYPE IN
('SEQUENCE', 'TABLE', 'INDEX',
'VIEW', 'DATABASE LINK', 'MATERIALIZED VIEW',
'FUNCTION', 'PROCEDURE', 'PACKAGE',
'PACKAGE BODY'
)
AND OWNER = '#SCHMEA_NAME#';

Migrate Sequences

During one of my projects I had an issue when I copied the DDL from my test environment into my productive system. Unfortunately I needed some of the test data in the prod system as well. For that I had to migrate most of the sequences starting with their last (more...)

Is public Session zero active?

Yesterday i needed to find out if the current page of an application is rendered using the public Session 0 (zero).

Seems to be a trivial task, simply look up :APP_SESSION and there you find ……a very big number. Even if the URL clearly shows that session 0 is (more...)

Select List with Dynamic LOV and ORA-06502: PL/SQL: numeric or value error: character string buffer too small

If you need to create a dynamic SQL for a select list or any other type of a LOV, your query should not exceed 4000 characters. In case it does, you will get the "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" error. That is the internal (more...)

APEX Tabular Form auf Basis einer View

Eine der häufigen Anforderungen in der APEX Entwicklung ist es, einen änderbaren Report (Tabular Form) anzulegen bei dem einzelne Spaltenwerte verändert werden dürfen. Dies funktioniert in 90% der Fälle sehr gut. In manchen Fällen ist der Standardmechanismus leider nicht die 100% Lösung. Wenn Sie besonders viele LOV Spalten in Ihrem (more...)

Formating and Exporting a Report Column

Sometimes you need to format a report column and if you need to do that in the report SQL, you will be faced with a problem while exporting the report - the formatted values will be exported 1:1 and you will see those ugly html tags among the exported data. (more...)