Via Lattanzio,23 Milano
+39 02 36592025

Oracle Tips #1 [Common Functions]

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 / plsql cross database and cross schema , first you need to define a db link like :

more well explained on Standfor site at this link

when you have created the DB Link you can produce queries and stored proc. using the synatax like this :

how to 4 : An empty string is treated as a null value in Oracle. Let’s demonstrate.


Tags: , , ,

Lascia un commento