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.


Lascia un commento

Scoprite cosa possiamo fare per il vostro business
Tecnologie e Partner