Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Categoria: databases

Oracle Tips #3 [Extract Metadata Info ]

by using some simple view in Oracle you can extract a lot of information about your DB schema, some explicit samples : (assuming that MyDBOwner is the owner of the DB and ACTIVITY is a table of a schema, this sample is succesfully tested on Oracle 10g)

a great article about this is :…
Leggi tutto

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

Firebird’s a Winner

Anche quest’anno si son chiuse le votazioni per i migliori software OpenSource sul più prestigioso dei repository : SourceForge. A questo indirizzo http://sourceforge.net/community/cca09/ si può consultare l’elenco dei vincitori per categoria, il mio superaffezzionato Firebird porta a casa una altro bel titolo, dopo essere già  stato vincitore nel 2007 quest’anno si attesta il titoto di…
Leggi tutto