By Prashant Gijare – Problem: In a product table, the answer for each product inquiry is stored in a separate column. Solution: I created a temporary table with one column (prodname) where all product names are individual rows. The product name fetched from this table is fed to dynamic SQL. T

By Larry Dignan – The company warned earlier this month that its fiscal third-quarter results would fall short of Wall Street expectations and broke out a novel reason: Business in Asia wasn’t up to par.

Tip by Simon Clifford – This script is a quick way of determining which tables are involved in PK/FK constraints. It saves you the trouble of querying the user_cons_columns table.

By Robert Jones – Everyone has some way to inititalize variables in SQL*PLUS. My favorite is to use the “col” directive with “new_val” option. This approach does not require a spoolfile making it somewhat easier to use in SQL*PLUS coding choirs.

This tip comes from Robert Ware – This script generates DDL to modify the default tablespace name for partitioned indexes. However, it could be easily modified to alter other segment types as well.

By Richard Perron – Here are answers to several Oracle questions leftover from our Ask the Experts feature. Rick is an Oracle DBA here at TechTarget.

Check out Hervé Deschamps’ Did You Know? — March 2002 – Designer 6i, SQL, Oracle Installer Pentium 4.

By Tom Sullivan and Paul Krill – DATABASE ARCHENEMIES IBM and Oracle are at it again, and the battle over how to store and manage XML data rages on. Both companies are set to issue new versions of their relational databases in the near future, with Oracle planning a May release and IBM slatin

By Dan McDonough, Jr. – Oracle and DoCoMo plan to provide the software and services needed to convince corporations that wireless apps can deliver tangible benefits. ‘The biggest obstacle is that enterprises need to justify the investment,’ Yankee Group analyst Gene Signorini told Wireless NewsFacto

Oracle Corp risks slipping further behind leading application server rivals and failing to broaden its product appeal to customers, after losing a self-imposed race for Java 2 Enterprise Edition (J2EE) 1.3 certification against BEA Systems Inc.