Book By Steve Muench – This rich and detailed look at the many Oracle tools that support XML development shows Java and PL/SQL developers how to combine the power of XML and XSLT with the speed, functionality, and reliability of the Oracle database.
Tag: Oracle
Using UTL_FILE to find files on the OS
By Steve Montgomerie – Here is how to use UTL_FILE to detect a file on the OS insead of writing a UNIX or DOS script. The procedure can be scheduled through DBA_JOBS to check for the existence of a file that has been FTP’ed, for example. Once the file has been detected, it calls another procedure to
OLAP and Data Warehousing – Data Warehousing Solution Architecture (Part 2)
By Alexzander Nepomnjashiy – Analysis is usually accomplished with tools that are built on the base of attendant technologies. Let’s briefly describe two of the most popular technologies – Online Analysis Processing (OLAP – the online operating analysis) and Data Mining (mining for hidden informatio
The Platform for the Connected Enterprise
By Philip J. GIll – Application developers need more than just an application server; they need an application platform. Oracle9iAS and J2EE combine to form just such a platform.
Guaranteeing a single row SELECT
By Kanan Mamedli – Here is how to guarantee that a SELECT is a single row SELECT. This is done in two steps: 1) find out if there is a record satisfied by this condition, and 2) select from the appropriate table or make a cursor variable and then fetch it.
Did You Know? — By Hervé Deschamps
Check out what Hervé Deschamps wrote about this month. Apps: yellow bar, logs. Reports: anchoring, shortcuts, symbols ref. NT stuff. HP printers as web servers.
Ellison: Linux/9i a Dream Team
Oracle Corp. Chairman and CEO Larry Ellison tried to woo the LinuxWorld crowd Wednesday by extolling the benefits of running mission-critical enterprise applications on Linux and Oracle’s 9i database.Ellison, in a keynote that concentrated on Oracle’s “unbreakable Linux” push launched in Jun
Oracle’s Groupware Challenge
By Lori MacVittie – In early July, Oracle purchased Steltor, a small and relatively unknown groupware developer. Just a week later Oracle announced its intention to offer the suite as its own entry into the low-growth groupware arena.IBM’s Lotus unit and Microsoft have owned the groupware sp
Review and Upgrade your Database Security
By Rich Niemiec and Kimberly Floss – The Oracle focus on database security goes back 25 years, to the first Oracle client, the CIA, on a project code-named “oracle.” With each version of Oracle, security continued to be a focus as more government and security-conscious companies selected Oracle as t
Oracle to Unveil Open-Source Cluster
By Matt Hicks – Oracle Corp. at LinuxWorld will introduce an open-source cluster file system for its Oracle 9i database. The Redwood Shores, Calif., software maker is planning to announce the open-source move on Wednesday, the same day its chairman and CEO, Larry Ellison, is scheduled to addr