Blog

Oracle Tips #1 [Common Functions]

I just starting on using Oracle 10g ….

bmw-oracle-1

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 http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_5005.htm

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.

bye

Lascia un commento

Scoprite cosa possiamo fare per il vostro business
Tecnologie e Partner