Posts

Showing posts from October, 2012

Oracle APEX : Input Field with ALL Capital Letters

This is a mini-tip on changing characters entered in a text/input field to all Capital letters. A little use of Javascript is required. Navigate to the page where the changes is required. Click on the field/Item for which all capital characters is required. Scroll till you reach Element section and in "HTML Form Element Attributes" mention the following (including quotes): onKeyUp="this.value=this.value.toUpperCase();" Now Click on Apply Changes button and run the page. For the field this attribute is applied, whenever a key is typed the case is changed. But if you dont want this type of animation and just want all characters to be in upper case no matter what, add the following to the text field: style="text-transform: uppercase;" onKeyUp="this.value=this.value.toUpperCase();" To learn more about text-transform click here . The style attribute is a CSS property and applies an all UPPER CASE property to the text field. Even though the...

Oracle APEX - Navigation bar current item

Image
Apex Version 4.0.2 I am using a template where my contents are appearing in one side (left) and navigation in another side (right) of the webpage. I created a "Vertical Sidebar List" template wherein all my navigation items will be embedded inside an un-ordered List. I created this very much easily. First created a List (Application Builder > My Application > Shared Components > Lists (Below Navigation)). The List template as I mentioned earlier is "Vertial Sidebar List". I entered a few pages in the navigation items and created the list. Later on I manually added a List Region to all my pages. I chose the Display Point of "Page Template Region Position 2" for my page contents, and for Menu I chose "Page Template Region Position 3". Thus I was able to list both regions side by side. But the problem I landed on was that when I click on a page the list was not displaying current attribute (or a highlighting). Even after lot of go...

Leave Management System for APEX (LeaveLite)

If you are new to Oracle APEX , well you are opening up a new world. Otherwise you know what APEX can do for you. With the latest version of 4.2 released at least I have lot of dreams with it. I began developing in the age where Client-server applications were dominant. Oracle Forms provided features where it is easy to develop an application within days. With the advent of Web applications Oracle provided various frameworks including ADF, APEX among others. I do not know Java, so I left behind from ADF. APEX seems to be perfect fit for me because it is pure PL/SQL that I have to know. (Though Java script/jQuery skills will be hugely beneficial). To add to this list for a year or so I have been developing website for our client with pure PL/SQL Web Toolkit. With this skill with me it was easy to delve deeper into APEX. With APEX 4.2 I have got more than what I have dreamed of, Mobile Applications. I am sharing with all my readers an application which I have designed and develop...

Oracle APEX 4.2 released

Image
Oracle Application Express 4.2 is released for production. The first and foremost features that got my attention was Application Builder for Mobile. Oracle has understood the importance of mobile web and has scaled to the need very quickly. I was able to create a mobile application without learning much. With only seeing this 2 minute video from Oracle Learning you will also understand how easy it is to create Business standard applications within minutes. The next feature (if you can call it) was the long list of packaged applications within Apex 4.2. I was able to just install a Bug Tracking software and run within 5 minutes. It also includes a Mobile interface. For more information on other features refer Oracle Website .