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

	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.

	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.

	VIEW ALL NEWS ON ORACLE AND SQL

WHITE PAPERS

	Try Rational AppScan Published by: IBM | 03 Nov 2009 ASSESSMENT TOOL - Download Rational® AppScan® Standard Edition V7.9, previously known as Watchfire AppScan, a leading Web application security testing tool that automates vulnerability assessments and scans and tests for all common Web application vulnerabilities including SQL-injection, cross-site scripting, and buffer overflow.

	The IT Manager’s Guide to SQL Server 2008 Migration Published by: SHI | 03 Nov 2009 EGUIDE - While SQL Server 2008 is now considered stable and beneficial, many businesses are still hesitant to migrate. In this expert E-Guide, brought to you by SearchSQLServer.com and SHI, you will discover the unique advantages offered by a SQL Server 2008 migration.

	Adobe ColdFusion 9 Published by: Adobe Systems, Inc. | 05 Oct 2009 SOFTWARE DEMO - Adobe ColdFusion 9 software enables developers to rapidly build robust Internet applications by condensing complex business logic into fewer lines of code.

	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