DB DEVELOPER

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...