APPS-ORACLE.RU

Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008 [...]

Представителей Microsoft, Sun и Oracle спросили, как они относятся к пиратам:
- Да они, да мы, да мы их !!! - сказали в Майкрософт
- Отлично относимся - сказали Oracle - Они все равно потом наши лицензионные продукты купят.
- Да нормальные они, пираты - сказали в Sun - у [...]

Недавно нашел в сети отличные электронные библиотеки. Есть там и много хороших книг по Ораклу. Здорово, что в наше время можно изучить любую интересующую технологию, было бы желание. Ссылочки вот такие:
http://ihtik.lib.ru/dreamhost_complit_22janv2007.html
http://c-books.info/books/load.php?ty=or&lng=RUhttp://proklondike.com/index.php?part=20&mainpart=5 [...]

Если Вы уже работали с базами данных, то наверняка уже знаете что такое реляционные БД. В этом случае смело можете пропускать эту статью, ибо ничего нового Вы в ней не узнаете.

Если же с реляционными СУБД Вы еще не сталкивались, то вкратце рассмотрим основные понятия реляционных баз данных.
Итак, [...]

Oracle 10g's compiler optimisation for faster PL/SQL, with a new section on optimisation bugs. November 2004 (updated March 2008) [...]

Various techniques for unloading data to flat-file faster. February 2008 [...]

Oracle extends the scope of its PL/SQL compiler optimisation. November 2007 [...]

Oracle relaxes the long-standing FORALL implementation restriction in 11g. November 2007 [...]

New plan features in 10g make SQL performance investigations much more simple. December 2004 (updated November 2007) [...]

Turning delimited strings into multiple records without PL/SQL. July 2005 (updated August 2007) [...]

Using ANYDATASET and pipelined functions to achieve native Method 4 Dynamic SQL. August 2007 [...]

Combining pipelined functions, polymorphism and multi-table inserts. August 2007 [...]

An introduction to generic types in Oracle 9i. October 2002 (updated July 2007) [...]

Using object features to encapsulate FORALL .. SAVE EXCEPTIONS error-handling. July 2007 [...]

Techniques to avoid superfluous updates with SET ROW. June 2007 [...]

Select directly from flat-files as though they are tables. August 2002 (updated June 2007) [...]

A new way of expressing subqueries in 9i. December 2005 (updated June 2007) [...]

Oracle adds ANSI-compliant joins to SQL in 9i. January 2003 (updated June 2007) [...]

Constructor functions, type evolution and substitution in 9i. December 2005 (updated June 2007) [...]

Functions can now stream data as virtual tables. May 2002 (updated May 2007) [...]

A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007 [...]

A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007 [...]

Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006 [...]

Simple SQL*Plus utilities to output the real execution plans used by running or cached SQL statements. Available for 9i Release 2 and 10g. October 2006 [...]

Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006 [...]

A tutorial on loading XML files into relational tables. March 2006 [...]

Performance characteristics of DML error logging. August 2005 [...]

Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005 [...]

A new error logging mechanism for bulk DML statements. August 2005 [...]

We can now view the evolution of our data with flashback version query. August 2005 [...]