Oracle SQL

EXPERT TECHNICAL ADVICE: 1 - 3 of 406

ORACLE SQL EXPERTS
			Rudy Limeback SQL Consultant ASK A QUESTION

	Counting NULL columns 21 Dec 2007 EXPERT ANSWER - Our SQL expert explains how to count null columns in a row.

	SQL to count values of a status code 21 Dec 2007 EXPERT ANSWER - Our SQL expert answers a question about counting values of a status code.

	Detail rows for accounts that occur three times 06 Dec 2007 EXPERT ANSWER - Our SQL expert answers a tough query using both the IN subquery and derived tables.

	VIEW ALL EXPERT TECHNICAL ADVICE ON ORACLE SQL

REFERENCE & LEARNING: 1 - 3 of 4

	Learning Guide: Performance tuning SearchOracle.com | 03 Nov 2004 LEARNING GUIDE - Learn the tricks of industry experts for identifying and eliminating perfomance problems in this guide.

	SQL Tuning with SQL Access Advisor Rampant TechPress | 13 Jun 2005 CHAPTER DOWNLOAD - This excerpt, taken from "Easy Oracle Automation: Oracle10g Automatic Storage, Memory and Diagnostic Features" by Dr. Arun Kumar R, describes the process of using SQL Access Advisor for tuning SQL.

	SQL 08 Apr 2005 FEATURED TOPIC - The data is there, but you need to figure out how to retrieve it. Stumped? Our learning guide and expert panel can help you solve even your trickiest SQL problems.

	VIEW ALL REFERENCE & LEARNING ON ORACLE SQL

NEWS: 1 - 3 of 16

	Oracle's free SQL Developer adds database migration tool SearchOracle.com | 21 Sep 2007 ARTICLE - Oracle SQL Developer is offering a new tool that lets users migrate data from Microsoft and MySQL databases to Oracle.

	Oracle updates Microsoft developer tools SearchOracle.com | 14 Jun 2007 ARTICLE - Oracle is offering free tools for Microsoft .NET and ASP.NET applications developers running the Oracle Database 10g.

	Oracle updates free Web development tool SearchOracle.com | 26 Mar 2007 ARTICLE - Oracle Application Express now offers Microsoft Access migration and .pdf printing support.

	VIEW ALL NEWS ON ORACLE SQL

WHITE PAPERS

	PRO Financial Solutions for Insurance Companies Published by: Fiserv Insurance Solutions | 25 Apr 2008 SOFTWARE LISTING - PRO Financial solutions deliver the sophisticated reporting and processing speed required by mid-size and larger insurers though the fully integrated General Ledger, Accounts Payable, Accounts Receivable and Fixed Assets solutions.

	PRO The Artius Suite Published by: Fiserv Insurance Solutions | 25 Apr 2008 SOFTWARE LISTING - The Artius Suite offers flexible component integration to build complete back-office solutions for your property and casualty processing needs by harnessing the power of the latest technologies by providing a set of tools that enables you to quickl...

	Real World SQL Implementations Published by: Hewlett-Packard Company | 10 Apr 2008 WHITE PAPER - Homeplans, part of Move, is a leading provider of pre-drawn home designs. This case study explains how Homeplans used HP PolyServe Software for Microsoft SQL Server to improve availability, decrease risk, and simplify administration.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

WEBCASTS: 1 - 2 of 2

	Overview of Microsoft Business Intelligence Solution on the HP Windows Integrity Platform - Vendor Webcast VIEW WEBCAST PREMIERED:   08 NOV 2006, 02:00 EST (07:00, GMT) SUMMARY:   View this Webcast to learn how to combine and optimize SQL technology and BI initiatives to meet the needs and increasing complexity of your crucial data.

Oracle SQL tuning secrets - Expert Webcast VIEW WEBCAST PREMIERED:   17 JUN 2004, 09:00 EDT (13:00, GMT) SUMMARY:   In this webcast, Don Burleson will teach attendees how to focus on real-world techniques for improving the speed of SQL queries in Oracle9i, including how to use advanced techniques such as materialized views and how to show actual performance difference. Attendees will also get a peek at Oracle10g SQL enhancements.

	VIEW ALL WEBCASTS ON ORACLE SQL

BEST WEB LINKS: 1 - 3 of 10

	Reviewed software tools for developers and DBAs Oracle FAQ's | 15 Aug 2006 BEST WEB LINK - A collection of reviews of developer tools, DBA tools and utilities, including Toad, dbSaint, Web DBA, SQL Insight and RapidSQL.

	SQL Server 2000 vs. Oracle 9i MS SQL City | 15 Aug 2006 BEST WEB LINK - This article compares SQL Server 2000 with Oracle 9i Database regarding price, performance, platforms supported, SQL dialects and product limits.

	Oracle unveils free SQL Developer: Has Toad met its match? SearchOracle.com | 14 Mar 2006 BEST WEB LINK - Oracle's newly released free SQL Developer could spell trouble for Quest Software Inc.'s popular Toad for Oracle software.

	VIEW ALL BEST WEB LINKS ON ORACLE SQL

DEFINITIONS: 1 - 3 of 9

	dynamic SQL 17 Sep 2003 WORD - Dynamic SQL is an enhanced form of Structured Query Language (SQL) that, unlike standard (or static) SQL, facilitates the automatic generation and execution of program statements. This can be helpful when it is necessary to ...

	autonomous transaction 31 Jul 2003 WORD - In Oracle's database products, an autonomous transaction is an independent transaction that is initiated by another transaction. It must contain at least one Structured Query Language (SQL) statement. Autonomous ...

	foreign key 27 May 2003 WORD - A foreign key, also called a foreign keyword, in a database table is a key from another table that refers to (or targets) a specific key, usually the primary key , in the table being used. A primary key can be targeted by ...

	VIEW ALL DEFINITIONS ON ORACLE SQL

	SEE ALSO - Topics Related to Oracle SQL:  Oracle Java / J2EE, Oracle PL/SQL, Oracle stored procedures, Oracle XML, SOA, Web services