Tune in and discover how Oracle9i Database’s extensive integration with Microsoft’s COM and .NET infrastructures allows Windows developers to build more robust programs in less time.Tune-in live: Tuesday February 19th at 1:00 pm PST/21:00 GMT
Tag: Oracle
Oracle Beats IBM in Java Development
According to an independent study conducted by market research firm Strategic Focus, not only does Oracle9i JDeveloper include intuitive wizards that eliminate the need for hand-coding–but it also supports all development approaches, from modeling and declarative development to programming, so it’s
How to create an autonumber (ADO/Oracle)
This article explains how to create an autonumber for an oracle table. Autonumbers use a before insert trigger to retrieve an sequence value and assign the value to a primary key field. Autonumbers insure the uniqueness of the primary key.Directed to article by OraclePower.
Oracle9i PL/SQL Transforms and Performs
By Steven Feuerstein – PL/SQL has received significant upgrades in Oracle9i Database. This article reviews some of the most important of these new features and enhancements.
Listen Software Solutions’ “How To” Series: Normalization
By David Nishimoto – Following the normalization guidelines usually means splitting tables into two or more tables with fewer columns. Primary and foreign key relationships are designed into the new smaller tables, so they can be reconnected with a join operation. The advantage of splitting the tabl
Stepping Up to Java 2, Enterprise Edition
By Joe McKee – Client-side Java (Java Standard Edition) never became the software that rendered operat-ing systems obsolete, but Java 2 Platform, Enterprise Edition (J2EE) 1.3has delivered an improved devel-opment solution for structuring large and complex server-based application development.
Top 10 database security headaches
By Jan Stafford – To say that database security managers have to be masters of multitasking is a huge understatement. While their daily to-do lists are large and varied enough to give anyone a headache, some parts of the job cause more headaches than others.
A stored procedure to send email
(Eli Leiba) Here is a stored procedure to send an email message using Oracle’s utl_smtp package. I tested this on Oracle 8.1.7 running on HP UX 10.20 system, with the Exchange server is installed on an NT 4 SP6 machine. (R)
Dynamic Database Access from Client-Side JavaScri
by Donald Bales – Imagine the advantages of being able to dynamically access a database from client-side JavaScript. You could dynamically query a database from JavaScript for client-side field validation, or dynamically populate a drop-down select list, to name just a few possibilities. In fact, yo
Total record count per schema
By Rohit Sinha – This script counts the number of records in all tables in a particular schema in a particular instance: