| [ ApEx | AQ | Architecture | DBD::Oracle | Forms | SQL, SQL*Plus, and PL/SQL | Whitepapers and articles ] |
| -- -- -- |
|
|
 |
|
|
 |
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
[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
[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)
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
- ...
|
| |
Links
|
| |
| |
Books
- Bulusus Lakshman: Oracle Developer Forms Techniques
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)
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)
April 2004
Buy it at Amazon.co.uk
CeDeT Rating: 
Usefulness:
- Steven Feuerstein, Bill Pribyl: Oracle PL/SQL Programming
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 |
| |
|
![CeDeT [se'de']](../CeDeTsmall.gif){kind=small}
