In Oracle 11g you can enable the built-in Password Complexity Checker function.
Background info can be found in the Database Security Guide.
The Oracle Database provides a sample password verification function in the PL/SQL script UTLPWDMG.SQL
(located in ORACLE_BASE/ORACLE_HOME/RDBMS/ADMIN) that, when enabled, checks whether users are correctly creating or modifying their passwords. The UTLPWDMG.SQL script provides two password [...]

Popularity: 381 points

DBA’s can finally use the Automatic Interval Partitioning option.
Test steps following the Oracle By Example (OBE) scripts available at
http://otnbeta.us.oracle.com/db11gr1/trng/obes/index.htm:
– create interval partitioned table
create table newsales
( prod_id number(6) not null
, cust_id number not null
, time_id date not null
, channel_id char(1) not null
, promo_id number(6) not null
, quantity_sold number(3) not null
, amount_sold number(10,2) not null
)
partition by range [...]

Popularity: 233 points

From the 11g New Features Guide:
“New in 11.1 is the ability to mark a PL/SQL function to indicate that its result should be cached to allow lookup, rather than recalculation, on the next access when the same parameter values are called. This function result cache saves significant space and time. Oracle does this transparently using [...]

Popularity: 237 points

Oracle 11g is shipped with a number of great new PL/SQL features. One of them - although a very small one - is that access to sequences is allowed in PL/SQL, so no need to “SELECT seq.nextval INTO n FROM dual” anymore!
DECLARE
  n NUMBER;
BEGIN
  SELECT seq.nextval
  INTO n
  FROM dual;
END;

can now be coded as
DECLARE
  n NUMBER;
BEGIN
  n := seq.nextval;
END;

For “currval” the [...]

Popularity: 301 points

The new 11g SQL plan management feature enables the optimizer to maintain a history of
execution plans for a SQL statement. Using the execution plan history the optimizer is
able to detect a new plan representing a plan change for a SQL statement. When the
optimizer detects a new plan, it stores the new plan and marks it [...]

Popularity: 211 points

While building a web-application using ADF Faces and ADF Business Components I came across the following problem. I had a read-only ViewObject set up and on my jspx. page, I came across the following problem when using setCurrentRowWithKey:

It resulted in a nice JBO-25020 error.
I googled around and luckily I wasn’t the only one who came [...]

Popularity: 474 points