Oracle and SQL

EXPERT TECHNICAL ADVICE: 1 - 3 of 431

ORACLE AND SQL EXPERTS
			Rudy Limeback SQL Consultant ASK A QUESTION

	Can I specify Oracle column order in my database table? 22 Oct 2009 EXPERT ANSWER - Oracle expert Brian Peasland explains whether you can specify Oracle column order in your Oracle database and gives example column order SQL statements in this expert tip.

	Do I need a license for SQL Developer Data Modeler in Oracle? 15 Jul 2009 EXPERT ANSWER - Do you use SQL Developer Data Modeler? Learn whether you need a Data Modeler license in this tip from an Oracle expert.

	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.

	VIEW ALL EXPERT TECHNICAL ADVICE ON ORACLE AND SQL

REFERENCE & LEARNING: 1 - 3 of 20

	SELECT statement syntax and examples Written by: Joel Murach | 19 Aug 2009 CHAPTER DOWNLOAD - In this chapter, learn how to use the SELECT statement with SELECT statement examples, including the basics of the SELECT statement syntax.

	Stored procedures in PL/SQL SearchOracle.com | 17 Aug 2009 LEARNING GUIDE - Learn about Oracle PL/SQL stored procedures, such as the stored procedure definition and stored procedure examples in this PL/SQL tutorial for beginners and experts.

	PL/SQL functions and triggers in Oracle SearchOracle.com | 17 Aug 2009 LEARNING GUIDE - Learn about using Oracle PL/SQL functions and triggers, such as how to import a trigger and how and when to use a PL/SQL function in this PL/SQL tutorial.

	VIEW ALL REFERENCE & LEARNING ON ORACLE AND SQL

NEWS: 1 - 3 of 17

	Oracle tutorial library: SearchOracle.com's learning guides SearchOracle.com | 12 Nov 2009 ARTICLE - We've gathered all our learning guides here in one invaluable list that you can return to again and again whenever you need a helping hand.

	Review: Oracle's 11g R2 database has some good and bad SearchOracle.com | 23 Sep 2009 ARTICLE - Oracle made no major architectural enhancements to the 11g R2 database, but it made some useful changes and added some clunkers, too.

	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.

	VIEW ALL NEWS ON ORACLE AND SQL

WHITE PAPERS

The Value of Good Database Development Software: Expert Evaluation of SQL Developer and Toad Development Suite Published by: Quest Software | 16 Nov 2009 WHITE PAPER - In this technical brief, John Weathington, President and CEO of Excellent Management Systems, Inc.,explores Toad® Development Suite and Oracle's SQL Developer. He provides an honest look at both solutions, and helps you see how a simple side-by-side comparison isn't enough when choosing the right tool.

Protecting and Enhancing SQL Server With Double-Take Availability Published by: Double-Take Software | 16 Nov 2009 WHITE PAPER - Double-Take Software provides organizations with a solution that offers distinct recovery and protection advantages over manual Microsoft SQL built-in replication capabilities: Double-Take Availability saves more data real-time and restores that data in a much faster manner.

	Backup and Recovery Challenges with SharePoint Published by: Mimosa Systems UK | 10 Nov 2009 WHITE PAPER - This whitepaper will discuss the challenges you can have to backup and protect using native tools and how you can successfully protect your SharePoint environment using Mimosa NearPoint™ for SharePoint.

	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