Oracle 10g: Set NLS_LANG
SELECT * FROM NLS_SESSION_PARAMETERSALTER SESSION SET NLS_LANGUAGE=Greek;alter session set nls_lang=GREEK_GREECE.EL8MSWIN1253
Oracle PL/SQL: Find Null Columns
With the procedure below you can find which columns are totally null, without data. It is useful, when you need an empty column e.g. for a new field: BEGIN DECLARE…
Oracle PL/SQL: Insert into Table using Cursor
The following insert statement is used to fill an interface table from a remote database, using a dblink (tblCalls_v1@sqlserverdb). It commits every 500: BEGIN DECLARE CURSOR C1 IS SELECT "ContactID"…
Java: Primitive Data Types
Primitive Type Size Range of Values (inclusive) byte 8 bits –128 to 127 short 16 bits –32768 to 32767 int 32 bits –2147483648 to 2147483647 long 64 bits –9223372036854775808…