Archives: 07/29/2010

ORACLE COMMAND LIST [XLS]

– https://spreadsheets.google.com/ccc?key=0AppCp7ElHaS9dDZheUE4VlFqMGlaRzZyWlZmUjFqQUE&hl=en#gid=0 –

– ARRAY –

$messages = array(); $messages[‘post’] = array ( 0 => ”, // Unused. Messages start at index 1. 1 => sprintf( __(‘Post updated. <a href=”%s”>View post</a>’), esc_url( get_permalink($post_ID) ) ), 2 => __(‘Custom field updated.’), 3 => __(‘Custom field deleted.’), 4 => __(‘Post updated.’), ); echo $messages[‘post’][2]; echo print_r($messages);

Command List [XLS]

– https://spreadsheets.google.com/ccc?key=0AppCp7ElHaS9dDZheUE4VlFqMGlaRzZyWlZmUjFqQUE&hl=en#gid=0 –

– CREARE UN NUOVO GRAFICO –

Creare nuovo grafico: nelle celle del foglio inserire i dati che si voglio visualizzare graficamente, tutti in celle adiacenti. Poi selezionare le celle (o la prima in alto a sinistra) –> men├╣ Inserisci –> gruppo Grafici –> selezionare il tipo voluto (posizionandosi con il puntatore si visualizza il tooltip con una breve descrizione). Spostare il…

– DBMS_SESSION.SET_NLS –

┬áThis procedure sets up your Globalization Support (NLS). It is equivalent to the following SQL statement: BEGIN DBMS_SESSION.SET_NLS(‘NLS_DATE_FORMAT’,”’YYYYMMDD”’); DBMS_SESSION.SET_NLS(‘NLS_TERRITORY’,’FRANCE’); FOR c IN (SELECT parameter || ‘ ‘ || value data FROM nls_session_parameters) LOOP dbms_output.put_line(c.data); END LOOP; END; BEGIN DBMS_SESSION.SET_NLS(‘NLS_DATE_LANGUAGE’,’ITALIAN’); FOR c IN (SELECT TO_CHAR(sysdate, ‘DAY’) data FROM DUAL) LOOP dbms_output.put_line(c.data); END LOOP; END; OR SELECT…

– STORED PROCEDURE EXAMPLES –

CREATE OR REPLACE PROCEDURE MyProcedureName(v_param1 in VARCHAR2, v_param2 in NUMBER, v_param3 in DATE) as — declarations v_var1 number; v_var2 varchar2(20); v_var3 date; — alternative statement without declarations [CREATE OR REPLACE PROCEDURE MyProcedureName(v_param1 in VARCHAR2, v_param2 in NUMBER, v_param3 in DATE) is] BEGIN v_var1 := 12; v_var2 := “value”; — 1) chiamo stored procedure MyStored(p_paramname1,p_paramname2); –…

– STORED PROCEDURE –

How to create a new procedure Sql Data Access: CONTAINS SQL (indicates that the routine does not contain statements that read or write data. This is the default if none of these characteristics is given explicitly); NO SQL (indicates that the routine contains no SQL statement); READS SQL DATA (the procedure has only reading SQL…

– INSTALLING ORACLE SQL DEVELOPER ON WINDOWS –

You can use Oracle Sql Devloper to access MySql,SqlServer databases via third party database driver for your Non-Oracle database: Download right version of Oracle SQL Developer here; Ensure you have a JDK and JRE installed, if not, download here; Download right version of JDBC (Java DataBase Connectivity) for MYSQL here (For MYSQL 4.0 use mysql-connector-java-5.1.13…

– SCN_TO_TIMESTAMP [Row creation built-in timestamp] –

SCN_TO_TIMESTAMP takes as an argument a number that evaluates to a system change number (SCN), and returns the approximate timestamp associated with that SCN. The returned value is of TIMESTAMP datatype. This function is useful any time you want to know the timestamp associated with an SCN. For example, it can be used in conjunction…

– WEB.CONFIG –

<system.web> <authentication mode=”Forms”> <forms loginUrl=”~/logon.aspx”> <credentials passwordFormat=”Clear”> <user name=”baz” password=”mcecm”/> <user name=”luca” password=”test”/> </credentials> </forms> </authentication> <authorization> <deny users=”?”/> </authorization> </system.web> <location path=”Images”> <system.web> <authorization> <allow users=”*”/> </authorization> </system.web> </location>

Go Top