HOW TO CHANGE COLORS OF ORACLE FORMS IN 11i AND R12

There are two system profile options that can be used to change colors of Oracle forms in E-Business Suite.

  1. Java Look and Feel: This profile have two values: GENERIC or ORACLE.
    • GENERIC: The native interface and color scheme of the current operating system.
    • ORACLE(or if the value is left blank): The profile option ‘Java Color Scheme’ can be used to personalize the colors of your screen.

    JavaLookAndFeel

  2. Java Color Scheme: If ‘Java Look and Feel’ is set to ORACLE (or if the value is left blank), then ‘Java Color Scheme’ can be set to the following values:
    • Blaf (in R12: Swan)
    • Khaki
    • Blue
    • Olive
    • Purple
    • Titanium
    • Teal
    • Red

    JavaColorScheme

Attention: Sign off and back on for your new color scheme to take effect.

HOW TO REMOVE DUPLICATE ROWS FROM A TABLE IN ORACLE (PLSQL)

We can easily remove duplicate rows from a table in Oracle.
There are a lot of ways with SQL.
I use the following method:

1
2
3
4
 DELETE FROM table_name
      WHERE ROWID NOT IN (  SELECT MIN (ROWID)
                              FROM table_name
                          GROUP BY col1, col2, col3, col4...);

Let’s make an example of a scenario.

Sample Table (Before Delete):

beforeRemoveDuplicateRows

Sample Query:

1
2
3
4
 DELETE FROM xx_employee
      WHERE ROWID NOT IN (  SELECT MIN (ROWID)
                              FROM xx_employee
                          GROUP BY employee_number, first_name, last_name, sex, job);

Sample Table (After Delete):

afterRemoveDublicateRows