In the last article, we covered some database terminology and looked at the four basic data query types. We also explained the WHERE clause and conditional statements and provided examples of the various query types.In this article, we’ll pick up where we left off with some additional functi

By Joris Evers – Oracle plans to release a pricing guide later this year to clear up confusion among users about its licensing policies, an executive of the Redwood Shores, Calif., software maker said Tuesday.

This script will copy archived redo logs to a secondary standby destination for an NT database.

By Robert R. Blizard – This SQL*Plus script lets you list the KEPT status for PL/SQL objects (Packages, Procedures, Functions, and Triggers) in your database. You can show objects with a KEPT status of YES, NO, or both, and select the schema to show using standard Oracle wildcards. The script also l

Oracle opened its OpenWorld European user conference in Copenhagen by announcing that it was joining forces with Sun Microsystems to provide customers with a system build-to-order scheme.

By Sara Cushman – Oracle this week revamped their certification requirements, adding a $2,000 “hands-on” class that must be completed even by those who pass the company’s four exams. The company has added the class to its Oracle9i DBA Oracle Certified Professional (OCP) path, saying the new m

by Ilya Petrenko – Description: Here is a UNIX script (ksh) that will populate a report about current processes per Instance ( Local ( LOCAL=NO ) and remote (LOCAL=YES) ). This is useful for monitoring activities especially when application server site is “bombing” back-end site.

By Alorie Gilbert – Known for its aggressive, high-pressure sales practices, Oracle decided last year to discontinue certain incentives, including steep end-of-quarter discounts and higher fourth-quarter commissions, that encouraged customers and salespeople to cram deal-making into the final days o

by AMIT PRASHANT – Here is how to query an Oracle database with special characters. First, create this test table:

According to Doug McMahon, the creator of the current version of MOD_OWA, “mod_owa is an open-source implementation of the PL/SQL gateway available in Oracle’s OAS/OWS product. The gateway is able to call PL/SQL procedures in a manner similar to the way Java servlets are supported, with the Oracle d