Oracle and SQL

EXPERT TECHNICAL ADVICE: 1 - 3 of 429

ORACLE AND SQL EXPERTS
			Rudy Limeback SQL Consultant ASK A QUESTION

	How to use an SQL CASE expression 09 Apr 2009 EXPERT ANSWER - Read an example of an SQL case expression from our SQL expert Rudy Limeback.

	Using the SQL GROUP BY clause for counting combinations 09 Apr 2009 EXPERT ANSWER - Read SQL expert Rudy Limeback's advice for counting combinations in a table with SQL's GROUP BY clause

	How to use string functions to make an SQL join 19 Feb 2009 EXPERT ANSWER - SQL expert Rudy Limeback explains how to use string functions to make an SQL join using only a portion of a column value.

	VIEW ALL EXPERT TECHNICAL ADVICE ON ORACLE AND SQL

REFERENCE & LEARNING: 1 - 3 of 16

	How to use the Oracle Database SQL Reference Manual Written by: Joel Murach | 20 Mar 2009 CHAPTER DOWNLOAD - In this chapter, learn how to use the Oracle Database SQL Reference Manual, a collection of technical information on the SQL statements that work with the Oracle Database.

	How to use SQL Developer to run SQL statements Written by: Joel Murach | 13 Mar 2009 CHAPTER DOWNLOAD - In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more.

	How to view and edit table column definitions Written by: Joel Murach | 12 Mar 2009 CHAPTER DOWNLOAD - In this chapter, learn how to edit and view column names and column definitions for a table, and when to use SQL Developer to do so.

	VIEW ALL REFERENCE & LEARNING ON ORACLE AND 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 AND SQL

WHITE PAPERS

	Databases and ERP Selection: Oracle vs SQL Server Published by: IFS | 19 Jun 2009 WHITE PAPER - How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.

	Docmosis V2.0 Published by: Docmosis | 17 Jun 2009 TRIAL SOFTWARE - Generating reports from Java applications has traditionally been a difficult task with heavy coding effort in development and maintenance. Even where graphical tools are provided, users must learn how to use a new and sometimes cumbersome tool.

Solution Sheet: Xenos DSR™ - Document Storage Reduction Solution for ECM Published by: Xenos Group Inc. | 09 Jun 2009 DATA SHEET - The amount of high-volume content such as statements, bills, policies, and correspondence, often referred to as High-Volume Transactional Output (HVTO), being produced by today's large organizations is rising dramatically. This solution sheet presents the Xenos DSR, document storage reduction solution for enterprise content management (ECM).

	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 AND 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 AND SQL

	SEE ALSO - Topics Related to Oracle and SQL:  Oracle Java and J2EE, Using Oracle PL/SQL, Oracle stored procedures, BPEL in Oracle, Oracle XML