(Aradhana Puri) Oracle Application Server Certificate Authority (OCA) and Oracle Wallet Manager (OWM) are important components of Oracle Application Server Public Key Infrastructure (PKI). You can use OCA to administer and manage the entire PKI certificate lifecycle. This lifecycle includes recordin
Tag: Oracle
Oracle bids for your unstructured data
(Peter Judge) Oracle has made a bid to manage the unstructured data in which companies are drowning — and one of the leading specialists in the field has jumped on board.
New Features in Oracle 10g for SQL*Plus and iSQL*Plus
(James F. Koopmann) Don’t wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features that will make a few of your everyday tasks a bit more bearable.
SQL Script Support in Oracle 10G Express Edition
(Jayaram Krishnaswamy) In an earlier tutorial we saw how to use SQL commands in the Oracle 10g Express Edition, or simply Oracle XE. We also saw how to use the PL/SQL commands as well. In another tutorial we saw how to use the Query Builder, the graphical interface for fashioning and running SQL in
HR Schema on Rails
(Casimir Saternos) Oracle Database is a product with a distinguished past and a bright future. It boasts innovative, state-of-the-art features as well as a history that predates many modern technologies. Applications have come and gone, but the data of organizations has lived on in Oracle databases
Types of Tables in Oracle
(Steve Callan) If a co-worker were to ask you to name as many Oracle table types as you can, what would be in your list? More than likely you would start off with relational, object, “normal,” cluster, index-organized, nested, partitioned, and so on. “No, not those table types,” your friend says, “I
Creating an MS Access 2003 Front End for an Oracle 10g Express Edition Database
(Jayaram Krishnaswamy) Enterprises have data stored in different kinds of databases from flat-files to relational databases. It is often necessary to generate reports from disparate databases. The rapid application development that is possible with MS Access allows one to rapidly deploy the report
Archiving Data Using XML
(Arup Nanda) Acme Insurance Company is ready to archive data more than three years old to tape and to delete it from the production database. The company’s IT architects have suggested an archive strategy that also uses transportable tablespaces, and the production tables have been carefully partiti
Capture changes using Oracle 10g’s new row timestamps
(Bob Watkins) Data warehouses are often populated by multiple source systems, each running their own applications. It can be tricky to determine which rows were recently updated, so that feeds to the data warehouse only include the new data. This is especially a problem with legacy applications that
On creating workspaces and merging/refreshing data with Oracle’s Workspace Manager
(René Nyffenegger) With Oracle’s Workspace Manager it’s possible to have several versions of data. That is, data can be changed, thus giving it a new version, without users looking at data of another version seeing the modified data. In this article, I try to explain this feature.
