(Brian Barbash) The 10g version of the application server from Oracle provides a highly flexible and scalable Java-based Web services capability. The tools provided by the system allow for almost any Java object or PL/SQL function to be exposed as a Web service.
Tag: Oracle
Creating an Oracle 10g database from the command line only
(René Nyffenegger) There are basically three ways to create an Oracle database: Using the Database Configuration Assistant (DBCA) With the SQL create database statement Through upgrading an existing database.
Analyzing Query Rewrites of Materialized Views
Prior to Oracle Database 10g, external tables were read-only. In Oracle Database 10g, external tables can also be written to. Although neither data manipulation language (DML) operations nor index creation is allowed on an external table, you can use the CREATE TABLE AS SELECT command to populate an
INFO: Understanding Microsoft’s Oracle ODBC Driver Versions
Microsoft has released several different versions of the Microsoft Oracle ODBC driver. This article describes the versions up through 2.573.4202, and indicates where to find ongoing versioning information for newer drivers as they are released.
Scheduling Jobs – Part 1
(Howard J. Rogers) We’ve had the ability to schedule work in the database for a long time… think DBMS_JOB, for example (which, I hasten to add, is still there in 10g, so old code doesn’t break). New in Oracle 10g, however, is DBMS_SCHEDULER, a more powerful, robust and flexible work scheduling eng
Oracle kicks off Retek integration
Oracle has rolled out an earlier than expected release of a new portal offering that represents a first stab at product integration following the company’s recent acquisition of retail software specialist Retek.
A View of Creating an Oracle User – Part I
(James Koopmann) How much thought do you put into creating an Oracle user? Have you ever looked within your database after you have installed a database tool or software solution? Many times, we are given these requirements at face value and do not feel we can or should question the procedures a
XML in the Database: A Brief Overview
(Lewis R Cunningham) Oracle provides a lot of XML functionality in the database. This entry will cover the different tools Oracle provides and future entries will get into the details of each.
Oracle technology platform drives Egypt’s comprehensive e-government initiative
As part of a comprehensive e-government initiative, Egypt’s Ministry of Communications and Information Technology (MCIT)/ MSAD/MOF has licensed a comprehensive range of Oracle technology to ultimately power and link up to 5000 financial units throughout the country.
Use Heterogeneous Services to access non-Oracle data
(Scott Stephens) Oracle’s Heterogeneous Services (HS) allows users to access data stored outside Oracle as if the data were in a local Oracle table. It can be intimidating setting up HS in Oracle SQL*Net, so check out these simple examples.
