insidedev.blogspot.com
Inside dev: November 2008
http://insidedev.blogspot.com/2008_11_01_archive.html
Wednesday, November 12, 2008. Validacija po modulu 11. Jeste li znali da svaki matični broj fizičkih i pravnih lica mora zadovoljiti ispravnost "po modulu 11"? Na net - u sam uspjela pronaći opis pravila za validaciju, koje se koristi u našoj zemlji, ali i zemljama u okruženju ( http:/ hr.wikipedia.org/wiki/Matični broj građana. Slijedi rješenje u PL SQL - u:. 1 Funkcija za ispitivanje validnosti:. Function validacijaPoModulu11(MB varchar2) return boolean is. If length(MB) = 13 then. If ostatak = 1 then.
insidedev.blogspot.com
Inside dev: September 2008
http://insidedev.blogspot.com/2008_09_01_archive.html
Wednesday, September 3, 2008. How to list all columns, primary keys, foreign keys, unique keys and check constraints for Oracle database. Few months ago I needed to list all constraints for all tables of Oracle database . Unfortunatelly, I couldn't find right scripts on the net, so I decided to wright them on my own. 1 First of those is script for listing all primary keys of some database. Beside name of primary key, it also shows name of column it refers to :. Where a.constraint type = 'P'. And ctable n...
baze-podataka.net
» Oracle Tipps & Tricks: Kako rasparčati niz znakova [How to split a string]
http://www.baze-podataka.net/2009/09/15/oracle-split-string-tokenizer
Baze podataka – MySQL, Oracle, PostgreSQL, MS SQL Server, Access, modelovanje podataka …. FROM baze podataka;. Oracle Tipps & Tricks: Kako rasparčati niz znakova [How to split a string]. Tuesday, 15.09.2009 –. Ukoliko imate zadatak da rasparčate neki string. Koristiću ovaj uvriježeni naziv umjesto prijevoda “niz znakova”), možete to obaviti na ovaj način. Za tu svrhu moramo kreirati jednu funkciju, kojoj kao ulazni parametar predajemo string. A koja nam vraća array sa parčadima. A rezultat izgleda ovako:.
insidedev.blogspot.com
Inside dev: How to list all columns, primary keys, foreign keys, unique keys and check constraints for Oracle database
http://insidedev.blogspot.com/2008/09/how-to-list-all-primary-keys-foreign.html
Wednesday, September 3, 2008. How to list all columns, primary keys, foreign keys, unique keys and check constraints for Oracle database. Few months ago I needed to list all constraints for all tables of Oracle database . Unfortunatelly, I couldn't find right scripts on the net, so I decided to wright them on my own. 1 First of those is script for listing all primary keys of some database. Beside name of primary key, it also shows name of column it refers to :. Where a.constraint type = 'P'. And ctable n...
insidedev.blogspot.com
Inside dev: Validacija po modulu 11
http://insidedev.blogspot.com/2008/11/validacija-po-modulu-11_12.html
Wednesday, November 12, 2008. Validacija po modulu 11. Jeste li znali da svaki matični broj fizičkih i pravnih lica mora zadovoljiti ispravnost "po modulu 11"? Na net - u sam uspjela pronaći opis pravila za validaciju, koje se koristi u našoj zemlji, ali i zemljama u okruženju ( http:/ hr.wikipedia.org/wiki/Matični broj građana. Slijedi rješenje u PL SQL - u:. 1 Funkcija za ispitivanje validnosti:. Function validacijaPoModulu11(MB varchar2) return boolean is. If length(MB) = 13 then. If ostatak = 1 then.