DB DEVELOPER

3.1. Prije nego što se podnese zahtjev za pristup informacijama treba pokušati tražene informacije dobiti na neformalni način. Centralna izborna komisija BiH - Vodič za pristup informacijama . UVOD Prije nekoliko godina, čitao sam blog legendarnog Tom Kyte o dizajnu relacionih baza, najbolje i najgore prakse.  Jedna od tih priča govori o tome da se čitav sistem može dizajnirati pomoću jedene tabele. Ta tabela sadrži ID, PARENT_ID i XML kolonu. ID i PARENT_ID opisuju relacije između objekata koji su opisani u XML koloni. Ideja je opisana kao jedna od najgorih... U mom slučaju ne radi se o sistemu, ali se radi o varijaciji ovog modela koji se pokazao vrlo upješnim prilikom prikupljanja podataka sa web servisa Centralne izborne komsije Bosne i Hercegovine. Ovo je mali projekat koji pokazuje na koji način organizacije i pojedinci, koje to žele, mogu da formiraju bazu podataka opštih izbora Bosne i Hercegovine održanih 2018 godine. Tekst je edukativne i tehničke prirode. ...

Oracle Internal Messages in One Place  Ones for all time i decide to create table with all oracle internal messages so i don't need to translate them from application to application. So, now i am sharing this mini database with you guys so you don't need to do this work all the time. (for us who need to modify existing messages) Step One Copy Paste Execute I am using PL/SQL Developer so you can copy this in plsql developer worksheet or you can create script, whatever. Here link for script . Step Two..... Now you have options. What is most important is that you have all messages in one table. Find a best way for you to translate them, for me its creating new Table/Forma on table and creating page with px_app_id item an px_lang item and button who execute code like Step Three  Use Oracle APEX Developer Workspace and Application Shared Components for maintenance of this messages.

How to create user define help (Oracle APEX). Idea of this blog is to show how can we create user define help for our pages in applications. Application will be develop under Oracle Cloud Template you can copy it from all Oracle Applications in Package Applications. Step One Create Tables First of all we need to create two table where we will store our help text and user settings for help Table for storing help text and user setting for help will have next structure: Step Two Create Package To extract and print help we will use package with two procedures Package spec: Dodaj naslov Package body Step Three Create Global Page Now in our application we need to add 0 Page or Global page with two Dynamic Actions and one check box and one PL/SQL region. In PL/SQL region (don't have name) we...