Archive for the PL/SQL Tips Category

Make the First Letter Capital Letter.

Posted in PL/SQL Tips with tags , , , on September 19, 2008 by nemosong

When you print out names, first characters must be always upper case.

There is a method in Oracle DB.

INITCAP(”)

PL/SQL: Cursor for Loop

Posted in Development, PL/SQL Tips with tags , , , , on September 17, 2008 by nemosong

FOR REC IN (SELECT COLUMN FROM TABLE)

LOOP

— Do Whatever you want using REC.COLUMN

END LOOP;

Reference: http://www.adp-gmbh.ch/ora/plsql/loops.html