Archives: 11/26/2010

WEB CONTROL CUSTOMIZZATO

1. Creare un nuovo progetto di tipo CLASS LIBRARY; 2. Aggiungere la referenza a system.web.dll; 3. Aggiungere la referenza a system.drawing.dll; 4. Referenziare il namespace System.Web.UI.WebControls; 5. Referenziare il namespace System.ComponentModel; 6 Referenziare il namespace System.Drawing; 7. Creare una classe che erediti da WebControl e circondare la classe con le opportune direttive; 8. Implementare un…

SEQUENCE

Syntax for MySQL The following SQL statement defines the “P_Id” column to be an auto-increment primary key field in the “Persons” table: CREATE TABLE Persons ( P_Id int NOT NULL AUTO_INCREMENT, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), PRIMARY KEY (P_Id) ) MySQL uses the AUTO_INCREMENT keyword to perform an auto-increment feature….

HANDLING EXCEPTIONS

It’s possible to categorize exception handling into the following types: – Named System Exceptions – Named Programmer-Defined Exceptions – WHEN OTHERS Clause Example: CREATE OR REPLACE PROCEDURE MY_STORED AS v_param varchar2(1); exc1 EXCEPTION; exc2 EXCEPTION; exc3 EXCEPTION; BEGIN v_param := 3; IF v_param = 1 THEN raise exc1; ELSIF v_param = 2 THEN raise exc2;…

SHOW COLUMNS

SHOW COLUMNS displays information about the columns in a given table (It also works for views as of MySQL 5.0.1). The LIKE clause, if present, indicates which column names to match. The WHERE clause can be given to select rows using more general conditions. SHOW COLUMNS FROM <tablename>

ALL_TAB_COLUMNS

ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user. Example 1: SELECT column_name, data_type FROM all_tab_columns Example 2: CREATE OR REPLACE VIEW V_LOG_SCHEMA AS SELECT object_name, column_name, column_type, object_text, created, lastupdate, comments FROM — [T]able, [V]iew (SELECT CASE WHEN object_name IS NULL THEN ” ELSE ‘[‘ || SUBSTR(object_type, 0,…

VERSION & V$ VIEWS

COMMAND VALUE SYS_CONTEXT(‘USERENV’,’AUTHENTICATION_TYPE’) DATABASE SYS_CONTEXT(‘USERENV’,’CURRENT_SCHEMA’) SIGO SYS_CONTEXT(‘USERENV’,’CURRENT_SCHEMAID’) 85 SYS_CONTEXT(‘USERENV’,’CURRENT_USER’) SIGO SYS_CONTEXT(‘USERENV’,’CURRENT_USERID’) 85 SYS_CONTEXT(‘USERENV’,’DB_DOMAIN’) finiper.it SYS_CONTEXT(‘USERENV’,’DB_NAME’) fnsigo SYS_CONTEXT(‘USERENV’,’HOST’) WORKGROUP\RICHLAB SYS_CONTEXT(‘USERENV’,’INSTANCE’) 1 SYS_CONTEXT(‘USERENV’,’INSTANCE NAME’) fnsigo SYS_CONTEXT(‘USERENV’,’IP_ADDRESS’) 192.168.244.110 SYS_CONTEXT(‘USERENV’,’ISDBA’) FALSE SYS_CONTEXT(‘USERENV’,’LANG’) I SYS_CONTEXT(‘USERENV’,’LANGUAGE’) ITALIAN_ITALY.WE8MSWIN1252 SYS_CONTEXT(‘USERENV’,’NETWORK_PROTOCOL’) tcp SYS_CONTEXT(‘USERENV’,’NLS_CALENDAR’) GREGORIAN SYS_CONTEXT(‘USERENV’,’NLS_CURRENCY’) € SYS_CONTEXT(‘USERENV’,’NLS_DATE_FORMAT’) YYYYMMDD SYS_CONTEXT(‘USERENV’,’NLS_DATE_LANGUAGE’) ITALIAN SYS_CONTEXT(‘USERENV’,’NLS_TERRITORY’) ITALY SYS_CONTEXT(‘USERENV’,’OS_USER’) Richlab SYS_CONTEXT(‘USERENV’,’SESSION_USER’) SIGO SYS_CONTEXT(‘USERENV’,’SESSION_USERID’) 85 SYS_CONTEXT(‘USERENV’,’SESSIONID’) 77575 SYS_CONTEXT(‘USERENV’,’TERMINAL’) RICHLAB Most valuable…

INTERNET EXPLORER 8 “NEW SESSION”

With Internet Explorer 8 users are able to run multiple instances of the browser, completely separate, each in its own session. With the latest release of the Internet Explorer, the Redmond company aimed to simplify browser session handling, simplification which allows IER8 to move away from the traditional model of “session merging.” In this context,…

CONFIGURING ORACLE DATABASE GATEWAY FOR ODBC (DG4ODBC)

Step by step instructions for installing and configuring Oracle’s Heterogeneous Services (HSODBC) to connect from an Oracle instance to MySQL (source database) running on a remote Linux machine. A) INSTALLING THE GATEWAY AND THE ODBC DRIVER FOR THE NON-ORACLE SYSTEM ON ORACLE SERVER 1- Verify installed packages. 2- Install ODBC driver for MySQL. 3- Configure…

Go Top