Make the First Letter Capital Letter.

19Sep08

When you print out names, first characters must be always upper case.
There is a method in Oracle DB.
INITCAP(”)

Filed under: PL/SQL Tips   |  1 Comment
Tags: capital letter, INITCAP, name, upper case

PL/SQL: Cursor for Loop

17Sep08

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

Filed under: Development, PL/SQL Tips   |  Leave a Comment
Tags: Cursor, Loop, Oracle, PL/SQL, SQL