Archive for February, 2010

ISIN validation code in PL/SQL

Monday, February 22nd, 2010

ISIN = International Securities Identification Number http://en.wikipedia.org/wiki/International_Securities_Identification_Number CREATE OR REPLACE FUNCTION sfCheckISIN(pISIN IN VARCHAR2) RETURN NUMBER IS s number := 0; a number; c number; begin a := case length(pISIN) when 12 then 1 else 2 end; for i in reverse 1..length(pISIN) loop ...

Oblikujte novi Oracle Forms builder

Thursday, February 4th, 2010

Nedavno je na Oracle-ovom forumu pokrenuta tema na kojoj mo┼żete predlo┼żiti ┼íta bi bilo dobro da se doda u Oracle Forms. http://forums.oracle.com/forums/thread.jspa?threadID=1021732&start=0&tstart=0 Na ovaj na─Źin je ljudima koji koriste ovaj alat je data sjajna prilika da oblikuju narednu verziji Forms-a. Naravno, ne─çe se svaki predlog prihvatiti, ali vrijedi poku┼íati... Li─Źno, prve stvari ...