Oracle Tips #1 [Common Functions]
I just starting on using Oracle 10g ….
how to 1 : how retrive a guid from Oracle
|
1 |
select sys_guid() from dual; |
how to 2 : how retrive next value from a Sequence
|
1 |
select [your sequence name].nextval into from dual ; |
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 :
|
1 |
CREATE PUBLIC DATABASE LINK remote USING 'remote'; |
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 :
|
1 |
select * from <table_name>@<db_link_name>; |
how to 4 : An empty string is treated as a null value in Oracle. Let’s demonstrate.
bye
