APEX 5 Login Screen

July 23, 2015 at 11:48 am | Posted in Oracle Developement | 4 Comments
Tags: , , , ,

The login screens of some of the APEX 5 sample applications have a nice look and include a check mark when you enter text into the username/password fields. This article will demonstrate how to create your own login page to look like that of some of the sample applications.

Edit your Login page (101):

  • Change login region template to Login.
  • Changes to Username and Password fields:
    • Change Template to Hidden.
    • Change Value Placehoder to Username / Password respectively.
    • Change Value Required to Yes.
    • Change CSS classes:
      • Username: icon-login-username
      • Password: icon-login-password
    • Change Post Text for username and password to
      <span class=”t-Login-iconValidation a-Icon icon-check”></span>.
  • Change the Login button Button Position to Next.

Save the changes and run the page. The result should look like this:

login1

To can add one of the application icons from the the packaged applications select on of the icons my previous blog post and make the following changes:

Navigate to Edit Application Definition -> User Interface, and edit the interface for your application.

Edit User Interface

Under Cascading Style Sheets add the this CSS file: #IMAGE_PREFIX#pkgapp_ui/css/5.0#MIN#.css

Add CSS file

On the Login page (101) click the Log In region and add the name of the icon class to Icon CSS Classes:

css

Save and run the log in page. It should look something like this:

login2

Quick Look: How to loop through an associative array indexed by varchar2.

April 16, 2012 at 10:29 am | Posted in Oracle Application Express (Apex), Oracle Developement, PL/SQL | 5 Comments
Tags: , , , , , , , , , , , , ,

Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2:


DECLARE
 TYPE t_tbl IS TABLE OF VARCHAR(1) INDEX BY VARCHAR2(1);
 l_tbl t_tbl;
 l_key VARCHAR2(1);
BEGIN
 l_tbl('a') := 1;
 l_tbl('b') := 2;
 l_tbl('c') := 3;

 l_tbl.delete('b');

 l_tbl('e') := 4;

 l_key := l_tbl.first;

 LOOP
   EXIT WHEN l_key IS NULL;
   dbms_output.put_line(l_tbl(l_key));
   l_key := l_tbl.next(l_key);
 END LOOP;

END;


Entries and comments feeds.