Via Lattanzio,23 Milano
+39 02 36592025

Categoria: oracle

Oracle Tips #1 [Common Functions]

I just starting on using Oracle 10g …. how to 1 : how retrive a guid from Oracle

how to 2 : how retrive next value from a Sequence

how to 3 : Oracle db Link , how to manage sql between multiple schema … With DB Link you can produce sql /…
Leggi tutto

Oracle 10g and XML

PLSQL is a world …. and Oracle an incredible RDBMS, so if you want to produce XML from query or manage XML inside your PLSQL Trigger or Procedure you can in different ways …. One of the most simple way is using the Oracle function to do that, like :

only with this piece…
Leggi tutto