(Alan Joch) Knowing their business’s key metrics was vital for Texas Industries (TXI), the growing Dallas, Texas, building materials supplier. With 100 locations and 2,800 employees across Texas, California, and Louisiana, TXI needed to keep a tight rein on business processes for sales, scheduling,
Tag: Oracle
Oracle releases out-of-cycle fix
(Robert McMillan) Oracle has released a critical security patch to the company’s E-Business Suite software.
Delete duplicate rows from a table
(Natalka Roshak) There’s an Oracle-specific trick to delete the duplicates from a table.
Querying, Constructing, and Transforming XML with Oracle XQuery
(Yuli Vasiliev) With the release of Oracle Database 10g Release 2, Oracle introduced a full-featured, native XQuery engine integrated with the database that can be used to accomplish various tasks involved in developing an XML-enabled application. A query language designed to work with the XML data
Oracle identifiers
(René Nyffenegger) In order not to make using Oracle confusing, there are some identifiers whose meaning must be totally clear if one want to work on Oracle.
Oracle Database Connection Strings in PHP
(Alison Holloway) It’s easy to get confused as to how to specificy your Oracle database connection string, and there’s a handy new feature in Oracle 10g that makes this a whole lot easier. So here’s a little rundown of the three ways to connect to Oracle databases.
Oracle 10g Scheduler Enhancements, Part 1
(Jim Czuprynski) As my responsibilities as an Oracle DBA have increased over the years, I have noticed a commensurate increase in ever-more complex requirements for scheduling tasks to occur at frequent – and sometimes less-than frequent! – intervals.
Put Some Muscle in Your Business
(David A. Kelly) For scientific and technical publishing giant Elsevier, building the second-largest UNIX-based online transaction processing (OLTP) database wasn’t about the technology achievement or awards it might win. It was all about serving the customer better.
Surveying Your Application Needs
(Raj Mattamal) As a product manager for Oracle Application Express (formerly Oracle HTML DB), I often want to gather feedback on workshops or training sessions I deliver. Using Oracle Application Express to quickly create surveys has proven to be so useful that I figured I’d write about it. Even tho
Developing and Implementing Applications, concluded
(Kevin Loney and Bob Bryla) The examples in the previous sections assumed that the same user owned the ADDRESS_TY datatype and the CUSTOMER table. What if the owner of the datatype is not the table owner? What if another user wants to create a datatype based on a datatype you have created? In the de
