distintas ordenes LENGH en oracle

Syntax

length::=

Purpose

The LENGTH functions return the length of char.  

LENGTH calculates length using characters as defined by the input character set.  
LENGTHB uses bytes instead of characters.  
LENGTHC uses Unicode complete characters.  
LENGTH2 uses UCS2 code points.  
LENGTH4 uses UCS4 code points.

Formato de la orden INSERT- SELECT

Sintaxis general de INSERT ... SELECT

INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name [(col_name,...)]
    SELECT ...
    [ ON DUPLICATE KEY UPDATE col_name=expr, ... ]

Co esta orden se puede insertar rapidamente  varias columnas en una tabla con datos de otra tabla o de otras tablas.
Un ejemplo:

INSERT INTO tbl_temp2 (fld_id)
  SELECT tbl_temp1.fld_order_id
  FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

Versiones y tutoriales de JAVA.

Pagina de oracle, que contiene tutoriales de java.
Estos son los tutoriales de la pagina oficial.

Tutoriales de JAVA:
http://docs.oracle.com/javase/tutorial/


Versiones de JAVA.
En la siguiente pagina estan accesos a las distintas versiones de JAVA.

http://www.techonthenet.com/java/index.php

Oracle/PLSQL: NVL2 Function

Learn how to use the Oracle/PLSQL NVL2 function with syntax and examples.

Description

The Oracle/PLSQL NVL2 function extends the functionality found in the NVL function. It lets you substitutes a value when a null value is encountered as well as when a non-null value is encountered.

Syntax

The syntax for the Oracle/PLSQL NVL2 function is:

NVL2( string1, value_if_NOT_null, value_if_null )