To set in a single session the decimal separator, for example when you need to cast some string in numbers you can use the next istruction :
|
1 |
ALTER SESSION SET NLS_NUMERIC_CHARACTERS ='. '; |
in this case the “decimal separator” is the point “.”. if you want the parameter is set inside a procedure or a function you can write like…
Leggi tutto
|
1 |
'********************************************************************** |
|
1 |
' Visual Basic ActiveX Script |
|
1 |
'************************************************************************ |
|
1 |
|
1 |
Function Main() |
|
1 |
Dim oPkg, oStep |
|
1 |
|
1 |
<strong>'ACCEDI AL MAIN OBJ DEL PACKAGE IN CUI è COMPRESO LO SCRIPT</strong> |
|
1 |
Set oPkg = <strong>DTSGlobalVariables.Parent </strong> |
|
1 |
<strong> </strong> |
|
1 |
<strong> 'ACCEDI ALL'ELENCO DEGLI STEPS DTS</strong> |
|
1 |
set oStep = <strong>oPkg.Steps("DTSStep_DTSActiveScriptTask_3") </strong> |
|
1 |
' oStep.ExecutionResult = DTSTaskExecResult_Success |
|
1 |
msgbox(oStep.ExecutionResult) |
|
1 |
oStep.ExecutionResult = 0 |
|
1 |
Main = DTSTaskExecResult_Success |
|
1 |
End Function |
Una 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…
Leggi tutto
[lang_en] To 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>); Per scatenare un eccezione da un Trigger o una Stored Procedure o una Funzione Oracle si può semplicemente utilizzare la funzione di sistema :…
Leggi tutto
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“.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
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 Select count(*) into tmpVar from Activity aa where (aa.fk_menu = :new.fk_menu)and(aa.pk_id <> :new.pk_id); -- if (tmpVar > 0) then --:New.FK_MENU := null; -- raise e_Menu_Already_Exists; -- end if; END ACTIVITY_FK_MENU_INTEGRITY; |
when you try to use the table making an update happen this : To avoid this error and obviusly assuming the…
Leggi tutto
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 /…
Leggi tutto
