You did WHAT? You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to skip over unnecessary lines of code? If slip-ups like these sound familiar (or if you don't know why these are mistakes), join Quest for a one-hour Webcast featuring guest speaker, Steven Feuerstein, as he examines common mistakes in Oracle PL/SQL programming. Learn how to correct mistakes to improve the maintainability and performance of your application. This Webcast will also demonstrate CodeXpert — a powerful feature available within Toad® that will help you avoid common mistakes and ensure you implement PL/SQL best practices in your daily activities. About the Guest Speaker: Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written nine published books on PL/SQL (all from O'Reilly & Associates). Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as a Senior Technology Advisor to Quest Software.  

Oracle Real Application Clusters (RAC) offer businesses the ability to create an environment where more than one database server, or node, can be setup to manage an Oracle database. Organizations often face multiple challenges when implementing RAC and maintaining RAC configurations, including: Determining how many database servers are needed for sustained optimal performance in a cluster Defining the proper testing methodology of a cluster configuration for load testing, scalability and availability This Webcast will provide you with: A proven methodology for determining the most optimal configuration for your Oracle RAC environment. A real-world scenario in which Quest's solutions were leveraged for Oracle RAC to conduct diagnostic and benchmark tests on Oracle Real Application Clusters.

Demonstration of a Google Gears prototype replacing SQLite with Sybase iAnywhere's UltraLite database, allowing automatic synchronization to an Oracle database.

1) CHAR -> Char contain alphanumeric data. -> Length of Char datatype is between 1 and 255 characters. -> If you don't specify a length, a char column stores a single character by default.

Normalization is a process or a database design method to achieve the goal of efficiently organizing data in a database.

Using the UNION statement: By default a UNION statement performs the equivalent of a SELECT DISTINCT on the final result set. UNION takes the results of two like recordsets, combines them, and then performs a SELECT DISTINCT in order to eliminate any duplicate rows. This will occurs even if there are no duplicate records in the final recordset. Sometimes you might want to merge two or more sets of data resulting from two or more queries using UNION.

Redo log buffers An Oracle database contains a redo log buffer and online redo log files. The redo log buffer is in the Shared Global Area (SGA) of an Oracle database and is used to store redo entries which are generated when a user requests to modify data.

One of the more interesting projects I participated in this year involved the comparison of a 64-gigabyte solid-state drive (SSD) from Texas Memory Systems to a serial ATA (SATA) array.

Learn how to mash-up any Oracle Spatial-administered data and give your end users the same enhanced mapping GUIs offered by Yahoo and Google.

One of the more important concepts in the domain of Service-Oriented Architecture (SOA) is that of Event-Driven Architecture (EDA). Similar to the event mechanism in, for example, JavaScript or 4GL environments where triggers—pieces of executable program code—can be hooked into events such as button-pressed, field-value-changed, or query-submitted, EDA specifies how "services" are hooked into "business events."