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

Tag: table

Oracle Tips #4 [Trigger : Mutating Tables & Autonomos Transactions]

Oracle Version : 10g As you know inside a Oracle row trigger you cannot access to the base table, for example when you make a trigger like this, on a table named “activity“.

when you try to use the table making an update happen this : To avoid this error and obviusly assuming the…
Leggi tutto

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

Hand made XML – HTML

Sometime,appen is required to produce an Xml Document where you can’t have a good Xml parser or for perfomance you can’t use that , so you need to encode and decode it manually to produce or read a standard document. Assuming thay you need create a simple Xml file like : Worng Xml file :…
Leggi tutto