Oracle 10g New Features

Read Online or Download Oracle 10g New Features PDF

Similar oracle books

Oracle Database 11g PL / SQL Programming

Layout Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL purposes with professional tips from an Oracle programming specialist. With complete insurance of the most recent gains and instruments, Oracle Database 11g PL/SQL Programming lays out every one subject along distinctive motives, cut-and-paste syntax examples, and real-world case reviews.

Oracle Weblogic Server 11gR1 PS2: Administration Essentials

This booklet is written in an easy-to-read type, with a robust emphasis on real-world, functional examples. step by step motives are supplied for acting very important management projects. when you are an internet server administrator searching for a brief advisor for acting regimen and significant WebLogic server management capabilities, together with configuring WebLogic server and deploying Java EE functions, then it is a excellent booklet for you.

Oracle database 11g : the complete reference

The Definitive consultant to Oracle Database 11gGet complete info at the strong positive aspects of Oracle Database 11g from this completely up-to-date Oracle Press advisor. Oracle Database 11g: the total Reference explains easy methods to use all of the new positive factors and instruments, execute strong SQL queries, build PL/SQL and SQL*Plus statements, and paintings with huge items and object-relational databases.

Extra resources for Oracle 10g New Features

Example text

Enabling parallel processing also implies that logic is in place in the ODCIAGGREGATEMERGE member function to deal with merged subsets of results. The AGGREGATE USING T LIST OF STRINGS clause is where all the magic happens. This line instructs the function that it is aggregate in nature, and an object of type T LIST OF STRINGS should be instantiated with the input parameter, kicking off the actual aggregation work. ■ Note Oracle only supports the creation of custom aggregate functions that take exactly one input parameter, and return exactly one output parameter.

This affects all kinds of comparisons, operators, and logic as you've already seen. But a nuance of this kind of logic is occasionally forgotten, so we'll repeat it explicitly. NULL has no equivalents. No other value is the same as NULL, not even other NULL values. If you run the following query, can you guess your results? employees where commission pct = NULL; The answer is no rows will be selected. Even though you saw from the above SELECT statement in this recipe that 72 employees have a NULL COMMISSION PCT, no NULL value equals another, so the COMMISSION PCT = NULL criterion will never find a match, and you will never see results from this query.

Solution Oracle's inline view feature allows a query to be included in the FROM clause of a statement, with the results referred to using a table alias. = 1700) d; The results will look like this. DEPARTMENT NAME ---------------Marketing Human Resources Shipping IT Public Relations Sales 6 rows selected. DEPARTMENTS table as an inline view, giving it the name “d”. Though providing an alias in this case is optional, it makes for more readable, testable, and standards-compliant SQL. You can then refer to the results of that statement as if it were a normal statement in almost all ways.

Download PDF sample

Rated 4.91 of 5 – based on 9 votes