Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy




Oracle Tips by Burleson 

Publish and Subscribe

The publish and subscribe feature of HTML DB allows components from one application to be shared with other applications.  What this provides is a single point of maintenance for the LOV.  Any changes made to the LOV would be updated in the master LOV and published to the applications that have subscribed to it.  A common use for this is to have a Global application where shared components such as Lists of Values are maintained so other applications can subscribe to them. 

The example below will create a List of Values with the As a Copy of an Existing List of Values option.  The steps outlined are going to use the PRODUCTS list of values in the Sample Application installed with the creation of a new workspace in HTML DB.

1.       On the Shared Components page, click the Lists of Values link.

2.       Click the Create button.

3.       On the Source page, choose the As a Copy of an Existing List of Values option and then click Next.

4.       On the Copy From page, for Copy From Application, choose the Sample Application item and then click Next.

5.       On the New Lists of Values page:

  • For the PRODUCTS item, the To Name can be left set to Copy of PRODUCTS.

  • In the Copy column, select the Copy and Subscribe option next to the Copy of PRODUCTS item.

  • Click the Copy List of Values button.

At this point, the program returns to the Lists of Values page.  From there, click on the link for Copy of PRODUCTS.  On the Edit List of Values page, the Subscription region will be visible as shown in Figure 10.21.  This shows the LOV is subscribed to the PRODUCTS LOV in application 100.  Anytime the LOV changes, the Refresh LOVbutton can be used to refresh the data from the master LOV.

The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty


Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks