Pro in Oracle Forum

Now my status level is Pro in Oracle Forum.

Save Before Exit plugin from SkillBuilder

It is possible that you fill data in form and some case you left the page without saving your work?
 
So that entered data will lost.

There is a plug-in Save Before Exit from SkillBuilder to prevent this issue.

Download the plug-in from: http://www.apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/skillbuilders-save-before-exit_43.html

Installation steps:

1. Unzip the downloaded file.
2. In your APEX screen go to shared document and then Plug-ins and  click on Import.
3. It will ask for selecting file. Choose dynamic_action_plugin_com_skillbuilders_sbdp_save_before_exit.sql and follow the steps.
4. This will install plug-in into your application

Configuration in page:

1. Go to page where you want to add save before exit feature.
2. Create a dynamic action.
3. Select advanced and give the name of dynamic action.
4. Choose page load on Event and next.
5. select "SkillBuilders Save Before Exit (2.0.0) [Plug-in]" in action and click on next.
6. Click on create button to create dynamic action.

If you want to add this feature in multiple page then you can create this dynamic action on Page 0 and give the condition that execute on list of pages.

Demo: http://apex.oracle.com/pls/apex/f?p=KP:SBE

Journeyman in Oracle Forum

I am a Journeyman : 200 - 499 pt.
http://forums.oracle.com/forums/profile.jspa?userID=777059

Oracle Application Express New Patch 4.0.2.00.06 Release

A new Oracle APEX patchset release with lots of bugfixes.

The following table lists bugs fixed in the Oracle Application Express 4.0.2.00.06 patch set.

Bug Number	Description
6360643	Missing RESTRICT_TO_USER_LIST in application export
9752881	Read only quick picks on 4000:4311 and 4000:371 should show "Always"
9855165	Incorrect results when viewing session state from Developer toolbar
10024385	Ignore case and blanks in attributes which are referencing page items
10024437	Flash 5 dial chart incorrect value displayed when value should be zero
10024919	Map attribute labels does not control visibility of labels on map
10030517	Popup LOV uses HTML Form Element attributes for anchor link
10030798	Interactive report CSV download includes extra pair of DIV tags
10037373	Unable to create forms conversion project using Internet Explorer 7 and Application Express Listener
10041505	Popup LOV search should use LIKE operator
10041816	Multi Row Delete process fails in some cases when display sequence was altered
10049423	Named report template page not displayed when called from Page Edit tree
10050404	String from other pages included in XLIFF page export
10051384	Flash 5 Gantt chart does not support 'DS' application date format
10055032	Children do not show up or are wrong in Query Builder
10055407	Theme 1 - Hide/Show region template missing float left
10057703	Cannot make 'Simple Checkbox' columns conditional
10058590	APEX_DEBUG_MESSAGE.LOG_LONG_MESSAGE incorrectly splits the message
10058669	ORA-01785 raised in sort-enabled classic reports when columns change
10062523	APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API parameter typo
10066270	Session State Protection report shows wrong value for Item Session State Protection
10066324	Multiple tree regions on same page may result in incorrect tree data
10069374	Pressing ESCAPE key sets value to jQuery based datepicker with time
10070849	Interactive report filter with next day gives ORA-00936: Missing expression
10079075	Incorrect item layout on Create Calendar Region attributes page 4000:2006
10090373	APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API parameters should not have NULL defaults
10090518	APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API removes incorrect messages
10090652	APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_APP API parameters should not have NULL default
10090699	APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_VIEW API parameters should not have NULL defaults
10091086	Flash 5 chart multiple Y axes only applied to first series of chart
10092894	View APEX_DEBUG_MESSAGES sometimes returns incorrect EXECUTION_TIME
10092991	Debugging flag shows and saves wrong value in Edit Application Properties
10093329	APEX_DEBUG_MESSAGE.LOG_PAGE_SESSION_STATE API does not show item values
10093980	Navigation bar logout entry created with condition type CURRENT_LOOK_IS_1
10095760	ORA-20001: Error In MRU in LOV in migrated tabular, form empty
10100985	Enabling debug using ENABLE_DEBUG_MESSAGES API results in missing debug information
10103359	Interactive report hangs search string exceeds allowed character limit
10104409	Runtime installation becomes invalid when using APXDEVRM.SQL
10104883	ORA-29279 SMTP permanent error when using reporting period
10107478	Region Display Selector attribute is ignored on import for certain region types
10107616	Syntax error in SQL report results in HTTP 404
10107767	Condition type "NONE" for validation might raise error
10108363	Flash 5 Map Animation option missing from Map Attributes page
10108919	Flash 5 charts checksum only applied to Action link for last record of series
10118507	Recently created dates can show in the future when using SINCE format mask
10119451	Application export with authentication scheme using 'NOT', 'NOT' is lost on import
10121357	Interactive report: when SELECT updated, existing columns of type timestamp are refreshed
10124254	Create Application on Spreadsheet Wizard: Theme selector region too narrow
10124263	Create Application on Spreadsheet Wizard: Final page icons not properly displayed
10124268	Install application final page 'Update App' icon not proper
10126550	Region display point preview popup does not work in German
10149191	Dynamic actions: should show 'never' in Page Definition component view
10149623	Page items of type select list, check box, and radio group should allow refresh
10149957	Update text field item to number field item
10150718	APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS should not remove primary default report
10150816	Error on application search
10154666	Interactive report chart displays incorrect decimal separator in non-english application
10158459	Application Express Autocomplete is replacing ampersand with '&'
10158747	Unexpected behavior with interactive report filtering with multi column LOV
10162569	Search on 4000:1 includes SESSION_ID when it should not
10162590	Search on 4000:1500 includes SESSION_ID when it should not
10165864	Reader access not granted to user that logs in when running a PUBLIC Websheet
10169594	Error message does not show up when editing process and shortcuts are used
10174506	Bad region template selected on page 4000:48, ugly button wrapping issue
10177937	Interactive report row text contains filter includes filter disabled column. To learn more, see "Row Searches on Interactive Reports No Longer Search for Filter Disabled Columns"
10185693	Interactive report row filter type displays filter disabled column
10185939	Add an API in APEX_UTIL to delete interactive report subscription
10185978	Flash 5 scatter chart displaying incorrect marker in legend
10188925	Import of application with access control supporting objects throws error
10189958	Interactive report after refresh event sometimes causes processing GIF to not be hidden
10190015	NV function raises ORA-01722 if value contains group separator
10195512	User granted create any table does not show up in spreadsheet data load
10198879	Allow more than one email address in interactive report subscription
10198889	Interactive report: subscription, format masks using substitutions are not supported
10201943	Editing of page item fails if too many plug-ins are installed
10202158	Page fails to load when many dynamic actions are defined on a page
10202608	Team Development feedback, 4800:8000 does not search feedback column
10202722	Editing Master Detail page in Create Application Wizard throws ORA-20001: NO DATA FOUND
10203473	In a Oracle Database upgrade release 11.2.0.2, APXDBMIG.SQL may show errors
10203596	Change Theme Number - Wizard templates too narrow for buttons
10205497	Flash 5 line chart 'Series type' defaults to bar instead of line
10206259	Flash 5 Map Wizard displays incorrect images for North America and South America, Asia, and Oceania
10206411	Flash 5 combined chart not displaying label and tooltip information for all chart series
10206510	Classic report row highlighting function not working for all themes
10207277	List of values report, 4000:421, does not search Query column
10210711	Add new placeholder #INTERNAL_MESSAGE# to error page template
10210802	DHTML list (IMAGE) with sublist does not work
10215164	Restful Web service support does not escape values when posting
10215440	Interactive report displays LOV in filter and highlight when it is disabled
10218361	Editing filter on pseudo column in Websheet data grid displays 2 operator lists
10219253	List of values report,4000:4110, does not search Query column
10221310	Data Grid validation dialog has misleading title
10222168	Websheet data grid filtering on Tag column has inconsistencies
10223154	Data Grid Pseudo column filter and highlight information display in red when it should not
10226951	ORA-04030 encountered when displaying Flash chart in Oracle Database 11.2.0.2
10228576	Interactive report email download and subscription send attachment in database character set
10231413	APEX_ITEM.SELECT_LIST_* APIs behave incorrectly if P_SHOW_NULL = YES
10232386	Multi-series chart does not display first chart
10238450	Interactive report filter dialog raises a 404 "NO DATA FOUND" error if page is submitted
10240360	Flash 3 charts throw ORA-01403 error if color schemes looks 6 or 7 used
10244462	Confirmation page of Create Form on Web Service has buttons out of place
10247924	Dynamic action When conditions does not work with shuttle, check boxes, or select list (with enabled Multi Select)
10248011	Theme toolbar stretches after upgrading to Oracle Application Express 4.0.1 in Internet Explorer
10252335	ORA-20001: GET_BLOCK when importing page which uses a not public user authentication scheme
10254296	Access Migrations navigation region missing icons in generated applications
10254433	Default theme should be set to theme 21 in Create Application Wizard
10254660	Automatic Time Zone application with time zone at 0:00 loops forever
10262671	Flash 5 chart series type item not displayed when page loaded using tree view
10264946	ORA-44003 occurs when Set Autocommit off in SQL Commands page
10270216	ERROR ERR-1016 / ITEM_PREFERENCE (Use item containing preference)
10078661	Advisor fails with ORA-20999 Unknown Type if process type plug-in is used

APEX 4.0 plugins

Here are the list of site in which you can find the APEX 4.0 plugins:

1. http://www.apex-plugin.com/
2. http://www.oracle.com/technetwork/developer-tools/apex/plugins-155231.html
3. Oracle APEX 4.0 Plugin Application: http://apex.oracle.com/pls/apex/f?p=654321

Thanks............

Happy Diwali and Prosperous New Year

Have a prosperous Diwali. Hope this festival of lights, brings you every joy and happiness. May the lamps of joy, illuminate your life and fill your days with the bright sparkles of peace, mirth and goodwill, because you are someone who deserves life's best and so much more. Have a joyous Diwali and new year.

Oracle FIXED_DATE Parameter

FIXED_DATE enables you to set a constant date that SYSDATE will always return instead of the current date. 

To undo a fixed date setting, specify FIXED_DATE=NONE. 

This parameter is useful primarily for testing. 

The value can be in the format shown above or in the default Oracle date format, without a time.

Testing against a fixed date in Oracle?

Testing against a fixed date is easy in Oracle. Here is one example demonstrating use of FIXED_DATE parameter.

Assuming you wanted to set a date Jan 1, 2010 in your database.

SQL> Select sysdate from dual ;

This will display the current system date

SQL> Alter System Set Fixed_Date='01-Jan-2010' ;

SQL> Select sysdate from dual ;

This will display the system date as '01-Jan-2010'

The above Alter command can change the current sysdate to the date given.

To change the sysdate to the original date.

SQL> Alter System set fixed_date='none' ;

SQL> Select sysdate from dual ;

This will display the current system date

Password strength meter in APEX

Step-1:
On page HTML Header write the following code

<style>
#passwordStrength
{
        height:10px;
        display:block;
        float:left;
}
.strength0
{
        width:250px;
        background:#cccccc;
}
.strength1
{
        width:50px;
        background:#ff0000;
}
.strength2
{
        width:100px;   
        background:#ff5f5f;
}
.strength3
{
        width:150px;
        background:#56e500;
}
.strength4
{
        background:#4dcd00;
        width:200px;
}
.strength5
{
        background:#399800;
        width:250px;
}
</style>

Step-2:
On password item P10_PASSWORD

 HTML Form element attribute: onkeyup="return passwordChanged();"

Step-3:
Create an item  P10_PASSWORD_STRENGTH on right side of password item.

Display As: Display as text(escape special characters, does not save state)
Pre Element Text: 

<script language="javascript">
function passwordChanged(){
var pwd = document.getElementById('P10_PASSWORD_STRENGTH');
var password = document.getElementById("P10_PASSWORD").value;
var desc = new Array();
        desc[0] = "Very Weak";
        desc[1] = "Weak";
        desc[2] = "Better";
        desc[3] = "Medium";
        desc[4] = "Strong";
        desc[5] = "Strongest";
        var score   = 0;
        if (password.length > 6) score++;
        if ( ( password.match(/[a-z]/) ) && ( password.match(/[A-Z]/) ) ) score++;
        if (password.match(/\d+/)) score++;
        if ( password.match(/.[!,@,#,$,%,^,&,*,?,_,~,-,(,)]/) ) score++;
        if (password.length > 12) score++;
        document.getElementById("passwordDescription").innerHTML = desc[score];
        if (password.length==0) {
             document.getElementById("passwordDescription").innerHTML  = 'Password not entered';
       }

      document.getElementById("passwordStrength").className = "strength" + score;

}
</script>

Post Element Text:

<div id="passwordDescription">Password not entered</div>

<div id="passwordStrength" class="strength0">

</div>

Demo Example:  http://apex.oracle.com/pls/apex/f?p=KP:PSM

Refer http://www.codeassembly.com/How-to-make-a-password-strength-meter-for-your-register-form for more info.

Final output:

Thanks

Some usefull plugins For Oracle APEX 4.0

Some usefull plugins from http://www.apex-plugin.com/ For Oracle APEX 4.0


Text Field with Masked Input
This is an APEX integration of the jQuery Masked Input Plugin created by Josh Bush (www.digitalbush.com). It allows you to force data input in a fixed format.

SkillBuilders IR Header Float
Interactive Reports are powerful reports in APEX that allow end users to customize reports to meet their needs. However, as with most other reports, viewing many rows at once requires users to scroll down the web page. As users scroll down, the report headers scroll out of site which can cause users to lose the context of the data being viewed – especially if the data involves lots of data and/or numbers.

Google Directions
This plugin provides the Google driving directions, route map, estimated distance and travel time based on two provided locations. This is an adaptation of Botoka's Google Map.

Form Validator
This dynamic action plug-in provides client-side form validation. The validation rules are based on the Apex Dictionary, like required items, number items (min/max values) and date items.

MBNDATA Tabs
Region plugin using jquery tabs.

SkillBuilders Save Before Exit
Have you ever filled out a form and accidentally left the page without saving your work? It is actually quite easy to do. Thankfully, browsers have features to help prevent this from happening. The problem, however, is that taking advantage of those features can be quite difficult - until now.

Sumneva Drag & Drop Report
This plug-in creates an AJAX enabled Drag & Drop Report from a SQL Query (and a few other bits and bobs) supplied by the user.

SkillBuilders Schedule
Event scheduling is a common task that developers repeatedly face when creating applications. The types of events can vary greatly as can their configuration options. Some events are simple, occurring only once while others are more complex and can repeat indefinitely.

Tokenizing-Autocomplete
A facebook style autocomplete text field.

Set OR Get apex item value

Procedure to set the apex item value

create or replace PROCEDURE PROC AS
BEGIN
    APEX_UTIL.set_session_state
    (
      p_name => 'P1_X',
      p_value => 'KARTIK');
END PROC1;

Here P1_X is the item name which is unique in APEX.

And call this procedure or also function in apex process.

Same way you can get the apex item value using get_session_state function:
 

APEX_UTIL.GET_SESSION_STATE (
    p_item    IN   VARCHAR2) 
    RETURN VARCHAR2;