@{ Home >> Teknik >> Oracle << }

→[ Indhold | Links | Nyheder | Oracle | Programmering | Referencer | Teknik ]
CeDeT [se'de']
BEGIN

    ORACLE();
END;
/
[ ApEx | AQ | Architecture | DBD::Oracle | Forms | SQL, SQL*Plus, and PL/SQL | Whitepapers and articles ]
--   --   --
#1 Oracle and Enterprise Data Warehousing
  -- Oracle Warehouse Builder (OWB)
#2 Oracle is funny (that way)
#3 Oracle Reporting (Reports and XML Publisher)
Oracle Application Express (ApEx)
- formerly known as HTML DB
  Architecture

Oracle Application Express (ApEx) is comprised of data in tables and PL/SQL code. The Applications build with ApEx are web applications: Your browser sends a URL request that is translated into the appropiate ApEx PL/SQL procedure call. The database processes the PL/SQL, and the results are returned to your browser (normally as regular HTML pages with some CSS and JavaScript).

The URL request is translated into an appropiate PL/SQL procedure call by utilizing either Oracle HTTP Server (aka Apache) with mod_plsql (three-tier) or the embedded PL/SQL gateway in XML DB HTTP server (back to client-server :o).

So basically all you need is a server running Oracle Database 10g XE or Oracle Database 11g R1 and a client with a browser such as Microsoft Internet Explorer 6.0+ or Mozilla Firefox 1.0+ — i.e. a "modern" one understanding as a minimum:
  • HTTP 1.1
  • HTML 4.0
  • JavaScript
  • CSS 1.0
  • Cookies
  Links
 
Advanced Queuing (AQ)
- now also known as Streams Advanced Queuing
  Links
 
  Whitepapers, articles and presentations
 
  Examples and how-to documents
 
  Books
  • Steven Feuerstein, Charles Dye, John Beresniewicz: Oracle Built-in Packages
    Oracle Built-in Packages (book cover)
     [Chapter 5: Oracle Advanced Queuing]

     April 1998
     Buy it at Amazon.co.uk


     CeDeT Rating: [not rated]
     Usefulness: [not evaluated]


  • Steven Feuerstein: Guide to Oracle8i Features
    Guide to Oracle8i Features (book cover)
     [Chapter 7.6: New DBMS_AQ(ADM) Features]

     November 1999
     Buy it at Amazon.co.uk


     CeDeT Rating: [not rated]
     Usefulness: [not evaluated]


  • Madhu Tumma: Oracle Streams (High Speed Replication and Data Sharing)
    Oracle Streams (book cover)
     January 2005
     Buy it at Amazon.co.uk


     CeDeT Rating: [not rated]
     Usefulness: [not evaluated]

 
Oracle Architecture
 
 
DBD::Oracle for ActiveState Perl
  The DBD::Oracle for ActiveState Perl 5.8.x is available at http://www.CeDeT.dk/perl.
 
Oracle Forms
  Product Roadmap (July 1, 2008)
  •    Strategic Products   
    • ...
    • Development Tools
      • Oracle JDeveloper
      • Oracle ADF
      • Oracle Eclipse Pack
    • ...
  •    Continue & Converge   
    • ...
    • Development Tools
      •    Oracle Forms & Reports   
      • BEA Workshop
    • ...
  •    Maintenance   
    • ...
    • Development Tools
      • BEA Beehive
    • ...
  Links
 
  Books
  • Bulusus Lakshman: Oracle Developer Forms Techniques
    Oracle Developer Forms Techniques (book cover)

     December 1999
     Buy it at Amazon.co.uk


     CeDeT Rating: [not rated]
     Usefulness: [not evaluated]


  • John Palinski: Oracle9i Developer (Developing Web Applications with Forms Builder)
    Oracle9i Developer (book cover)

     March 2003
     Buy it at Amazon.co.uk


     CeDeT Rating: [not rated]
     Usefulness: [not evaluated]


  • See also Oracle Reporting: Reports Books
 
  Example triggers
  • Avoid unintentional query execution (i.e. executing without entering query)
    KEY-EXEQRY
    IF :SYSTEM.MODE<>'ENTER-QUERY' THEN
      MESSAGE('Query must be entered before executing!');
      RAISE FORM_TRIGGER_FAILURE;
    ELSE
      EXECUTE_QUERY;
    END IF;
  • Highlight queryable items (in enter query mode)
    WHEN-NEW-RECORD-INSTANCE
    IF :SYSTEM.MODE='ENTER-QUERY' THEN
      DECLARE
        l_cur_block VARCHAR2(30):=NAME_IN('SYSTEM.TRIGGER_BLOCK')||'.';
        l_cur_item  VARCHAR2(50):=l_cur_block||
                            GET_BLOCK_PROPERTY(l_cur_block,FIRST_ITEM);
      BEGIN
        WHILE l_cur_item<>l_cur_block LOOP
          IF  GET_ITEM_PROPERTY(l_cur_item,DISPLAYED)='TRUE'
          AND GET_ITEM_PROPERTY(l_cur_item,ITEM_TYPE) IN 
                          ('CHECKBOX','LIST','RADIO GROUP','TEXT ITEM')
          THEN
            IF GET_ITEM_PROPERTY(l_cur_item,QUERYABLE)='TRUE' THEN
              -- change Visual Attribute
              DISPLAY_ITEM(l_cur_item,'QUERY_MODE_VA');
            END IF;
          END IF;
          l_cur_item:=l_cur_block||
                        GET_ITEM_PROPERTY(l_cur_item,NEXTITEM);
        END LOOP;
      END;
    END IF;
  • See also Oracle Reporting: Reports Examples
 
  Default menu with and without smartbar for Oracle Forms
(Implementation of the default menu with and without smartbar for Oracle Forms (from version 6.0.5.1.3))
 
SQL, SQL*Plus, and PL/SQL
  Scripts
Links
Books
  • Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox: Mastering Oracle PL/SQL (Practical Solutions)
    Mastering Oracle PL/SQL (book cover)

     April 2004
     Buy it at Amazon.co.uk


     CeDeT Rating: 5 out of 6 possible stars5 out of 6 possible stars5 out of 6 possible stars5 out of 6 possible stars5 out of 6 possible stars
     Usefulness: 4 out of 6 possible stars4 out of 6 possible stars4 out of 6 possible stars4 out of 6 possible stars


  • Steven Feuerstein, Bill Pribyl: Oracle PL/SQL Programming
    Oracle PL/SQL Programming (book cover)

     4th Edition
     August 2005
     Buy it at Amazon.co.uk


     CeDeT Rating: [not rated]
     Usefulness: [not evaluated]



Tips and Howto links
Documentation links
  • Ending a Session - ALTER SYSTEM end_session_clauses:
    ALTER SYSTEM { DISCONNECT | KILL } SESSION '<sid>,<serial#>' [POST_TRANSACTION] [IMMEDIATE];
    Text description of end_session_clauses
  • Comments on Schema Objects - COMMENT:
    COMMENT ON { TABLE <table> | COLUMN <table>.<column> } IS <string>;
    Text description of COMMENT
  • Comments on Default Values = add remark after default value:
    SQL> CREATE TABLE tdcomm(
      2    id NUMBER      NOT NULL,
      3    td VARCHAR2(1) NOT NULL
      4  );
    
    Tabel er oprettet.
    
    SQL> ALTER TABLE tdcomm ADD
      2    CONSTRAINT tdcomm_pk PRIMARY KEY(id);
    
    Tabel er ændret.
    
    SQL> ALTER TABLE tdcomm MODIFY(
      2    td DEFAULT 'N' -- N or Y
      3  );
    
    Tabel er ændret.
    
    SQL> ALTER TABLE tdcomm ADD
      2    CONSTRAINT tdcomm_ck_td CHECK(td IN ('N','Y'));
    
    Tabel er ændret.
    
    SQL> SELECT column_name,nullable,data_default,default_length
      2   FROM  user_tab_columns
      3   WHERE table_name='TDCOMM';
    
    COLUMN_NAME            N DATA_DEFAULT         DEFAULT_LENGTH
    ---------------------- - -------------------- --------------
    ID                     N
    TD                     N 'N' -- N or Y                    14
  • Managing User Privileges and Roles - Specifying Default Roles:
    ALTER USER <user> DEFAULT ROLE <role>[, <role>]...;
    Text description of ALTER USER
  • UTL_HTTP Session Settings - SET_TRANSFER_TIMEOUT Procedure:
    UTL_HTTP.SET_TRANSFER_TIMEOUT(timeout=><seconds>);

Correct character set in non-GUI version of SQL*Plus on Windows
Spooling in SQL*Plus
Whitepapers and articles
 
© 2003-2014 CeDeT - Sidst opdateret: 16. marts 2014.
Valid XHTML 1.0!