|
|
 walter  walter.paludet@synaptica.info  31 March 2010Una domanda che salta fuori spesso è “Quanta memoria puo’ usare mysql sul mio sistema ?” Come saprete mysqld-nt.exe viene eseguito in un singolo processo con vari thread; dunque il limite d’uso della memoria è fissato dai limiti imposti dallo stesso sistema operativo per il singolo processo. Sistemi operativi differenti, hanno limiti differenti; dipendenti anche dall’architettura della [...] ivan ivan.revelli@synaptica.info 10 March 2010to raise an Exception from a Trigger, Stored Procedure or Function without needing anything you can use the function : raise_application_error. Syntax : raise_application_error(<your exception integer code>, <your string description>); ivan ivan.revelli@synaptica.info 8 March 2010Oracle 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“.
CREATE OR REPLACE TRIGGER UNAME.ACTIVITY_FK_MENU_INTEGRITY AFTER INSERT OR UPDATE ON UNAME.ACTIVITY REFERENCING NEW AS New OLD AS Old FOR EACH ROW DECLARE
tmpVar NUMBER; e_Menu_Already_Exists EXCEPTION;
BEGIN [...] ivan ivan.revelli@synaptica.info 8 February 2010I just starting on using Oracle 10g ….
how to 1 : how retrive a guid from Oracle SELECT sys_guid() FROM dual; how to 2 : how retrive next value from a Sequence SELECT [your sequence name].NEXTVAL INTO FROM dual ; how to 3 : Oracle db Link , how to manage sql between multiple schema … With [...] ivan ivan.revelli@synaptica.info 29 July 2009Anche quest’anno si son chiuse le votazioni per i migliori software OpenSource sul più prestigioso dei repository : SourceForge. ivan ivan.revelli@synaptica.info 17 May 2009sometime happen that you need to create a table from a query… This operation is not a standard sql but a lot DataBases can do this : in Oracle you can do this like :
CREATE TABLE new_table [...] |
|
|
Copyright © 2010 Synaptica srl - All Rights Reserved
|
