(Scott Stephens) An Oracle database server running on a Windows machine can manipulate COM Automation server objects from PL/SQL or Java stored in a database. To access a COM Automation server, a client application requests an instance of an object from the server that implements the IDispatch stand
Tag: Oracle
On Turning Two
(Jeff Spicer) Two years ago, Oracle announced Oracle Database 10g, the first database to be “grid-enabled”—meaning the database could run across a clustered group of servers that could be managed as a single entity. By implementing computing grids with Oracle Database 10g, companies would gain impro
Graph Data Representation in Oracle Database 10g: Case Studies in Life Sciences
(Susie M. Stephens, Johan Rung and Xavier Lopez) New technologies have been developed in the life sciences that allow researchers to study biological systems in rich detail. These advances have resulted in an abundance of data that describes the relations between the fundamental components of biol
Filling in the LAST Leading Value
(Robert Ware) This script finds objects in a schema based on a text string/name.
Database Interaction with PL/SQL, Named Notations, Storing Procedures and Functions
(Jagadish Chatarji) This is part 16 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we worked with PL/SQL TABLE types in between sub-programs. In this article, we will look into Named Notation, default values of parameters, stored procedures, sto
Exporting a DB using Oracle Console
(Maria Anderson) I’d like to ask how I can export my DB using Oracle Console. It asked me to log in in management server mode but I cannot log in. I gave the server as my DB name and it told me that there is no such server. When I log in as SYS, it tells me that you have […]
SAP Chips Away at Oracle Fusion Strategy
(John Pallatto) Opinion: Oracle competitor SAP is buying a third-party PeopleSoft support provider to build its own potential captive market.
Customizing Oracle 10g Installation Options (Sample Chapter)
(John Kanagaraj, Arun Kumar and Richard Stroupe) Oracle Database 10g includes several options and features that will need to be configured before you can get started. This chapter covers the configuration options you’ll need to select and what they do in detail.
Oracle likely to fully acquire i-flex
Oracle has said that it is not averse to gaining full control of i-flex Solutions. Oracle, which recently gained control of i-flex by picking up 44 per cent stake in the company, will be shortly making an open offer to buy a further 20 per cent in this banking software product firm in a total deal e
Optimizing Oracle 10g on Linux: Non-RAC ASM vs. LVM
(Bert Scalzo) It’s been over a year since my first and enthusiastic automatic storage management (ASM) article, titled “Optimizing Oracle 10g on Linux Using Automated Storage Management”, was published. It still is available here, here and here. Since then, quite a lot has changed in terms of the so
