(Christian Shay) You’re working on some C# or VB.NET routines that manipulate data you’re retrieving from Oracle Database. You need to access the database to edit and test some stored procedures, modify some data in a table, change the structure of a table or view, or perform one of countless other
Tag: Oracle
Find the Hard Parse Rate
(Vishwamithran S) The following script is designed to find the hard parse rate of programs.
Microsoft’s strong midmarket channel thwarts Oracle, SAP
(Robert Westervelt) As SAP and Oracle Corp. move into the midmarket to build a larger customer base, they are struggling to untangle Microsoft’s web of channel partners and build a strong network of their own. (R)
Making a field disabled depending on the value in another field
(Grant Ronald) I’ve been having a bit of a test drive of the latest build of JDeveloper and one of things that I wanted to try out was the ability to make a field disabled depending on the value of another field.
Oracle’s Entry-Level App Server: Power in a Low-Cost Package
(Nelson King) Application servers are inherently complicated. As the hub of modern Web applications, they connect and manage databases, business rules, user interaction, operating systems, networks, browsers, applications…and more. They make n-tier Web applications possible, but the term “n-ti
Seven rules for well-behaved primary keys
(David Hunt) Here are seven quick rules for designing robust and error-free primary keys for Oracle databases. (R)
Oracle Database Integrity and the Human Experience
(James F. Koopmann) Database integrity is the thread that holds database objects together to satisfy business objectives and rules. It is unfortunate that data integrity doesn’t always cascade into the real world and hold us all together when times get tough.
Migrating to Oracle HTML DB
(Scott Spendolini) Oracle HTML DB is a Web application development tool based on Oracle Database. Using nothing more than a Web browser, it lets you quickly and securely create and deploy Web applications. Oracle HTML DB is supported in the standard and enterprise editions of Oracle Database 10g Rel
RACing ahead with Oracle on VMware – Part IV: Installing RAC Database with ASM Option
(Tarry Singh) In our last article, we talked about installing clusterware on two Windows 2003 nodes. Installing the database and setting up ASM was actually no problem but I did encounter some issues when trying to attach shared disks on disks that were, well, slower. Here we will install a fully wo
An Introduction to Linux Shell Scripting for DBAs
(Casimir Saternos) About seven years ago, Oracle released the first commercial database on Linux. Since then, Oracle, Red Hat, and Novell/SUSE have been steadily collaborating on changes to Linux kernel as they relate to database and application performance. For that reason, Oracle Database 10g for
