Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
GDK stands for Globalization Developer's Kit. GDK is a set of services that can help monolingual application developer to create similar multilingual applications with minimual knowledge about internationalization issues.
GDK includes two major components, internet globalization services and Oracle globalization services. GDK includes two major components, internet globalization services and Oracle globalization services.
Internet global services can hide the complexity of globalization to support multi-user with different locale. Oracle globalization services provide developer a set of consistent, high performance and easy to use tools in middle-tier as database client.
utl_gdk.language_map(language IN VARCHAR2, flag IN BINARY_INTEGER) RETURN VARCHAR2;
SELECT utl_gdk.language_map('English', 3) FROM dual;
SELECT utl_gdk.language_map('en', 4) FROM dual;
SELECT utl_gdk.language_map('French', 3) FROM dual;
SELECT utl_gdk.language_map('fr', 4) FROM dual;
SELECT utl_gdk.language_map('German', 3) FROM dual;
SELECT utl_gdk.language_map('de', 4) FROM dual;
SELECT utl_gdk.language_map('Japanese', 3) FROM dual;
SELECT utl_gdk.language_map('ja', 4) FROM dual;
SELECT utl_gdk.language_map('Arabic') FROM dual;
SELECT utl_gdk.language_map('Finnish') FROM dual;
SELECT utl_gdk.language_map('Korean') FROM dual;
SELECT utl_gdk.language_map('Russian') FROM dual;
SELECT utl_gdk.language_map('Slovak') FROM dual;
SELECT utl_gdk.language_map('Spanish') FROM dual;
SELECT utl_gdk.language_map('Thai') FROM dual;
utl_gdk.territory_map(territory IN VARCHAR2, flag IN BINARY_INTEGER) RETURN VARCHAR2;
utl_gdk.territory_map('AMERICA', 3) FROM dual;
SELECT utl_gdk.territory_map('US', 4) FROM dual;
SELECT utl_gdk.territory_map('AMERICA', 5) FROM dual;
SELECT utl_gdk.territory_map('USA', 6) FROM dual;
SELECT utl_gdk.territory_map('SPAIN', 3) FROM dual;
SELECT utl_gdk.territory_map('ES', 4) FROM dual;
SELECT utl_gdk.territory_map('SPAIN', 5) FROM dual;
SELECT utl_gdk.territory_map('ESP', 6) FROM dual;
SELECT utl_gdk.territory_map('GERMANY', 3) FROM dual;
SELECT utl_gdk.territory_map('DE', 4) FROM dual;
Character Set Related Queries
Character Sets
set serveroutput on
BEGIN
FOR i IN 1..401
LOOP
IF nls_charset_name(i) IS NOT NULL THEN
dbms_output.put_line(TO_CHAR(i) || ' ' || nls_charset_name(i));
END IF;
END LOOP;
END;
/
SQL> SELECT name, value
FROM gv$parameter
WHERE name LIKE '%nls%'; 2 3
NAME ALUE
------------------------ ------------------------------
nls_language AMERICAN
nls_territory AMERICA
nls_sort
nls_date_language
nls_date_format DD-MON-YYYY HH24:MI:SS
nls_currency
nls_numeric_characters
nls_iso_currency
nls_calendar
nls_time_format
nls_timestamp_format
nls_time_tz_format
nls_timestamp_tz_format
nls_dual_currency
nls_comp BINARY
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
SQL>
col parameter format a25
SQL>
col value format a30
SQL>
set linesize 120
SQL>
SELECT *
2
FROM gv_$nls_parameters;
INST_ID PARAMETER VALUE CON_ID
-------- ------------------------- --------------------------- ------
1 NLS_LANGUAGE AMERICAN 1
1 NLS_TERRITORY AMERICA 1
1 NLS_CURRENCY $ 1
1 NLS_ISO_CURRENCY AMERICA 1
1 NLS_NUMERIC_CHARACTERS ., 1
1 NLS_CALENDAR GREGORIAN 1
1 NLS_DATE_FORMAT DD-MON-YYYY HH24:MI:SS 1
1 NLS_DATE_LANGUAGE AMERICAN 1
1 NLS_CHARACTERSET AL32UTF8 1
1 NLS_SORT BINARY 1
1 NLS_TIME_FORMAT HH.MI.SSXFF AM 1
1 NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM 1
1 NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR 1
1 NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR 1
1 NLS_DUAL_CURRENCY $ 1
1 NLS_NCHAR_CHARACTERSET AL16UTF16 1
1 NLS_COMP BINARY 1
1 NLS_LENGTH_SEMANTICS BYTE 1
1 NLS_NCHAR_CONV_EXCP FALSE 1
SQL> SELECT *
2 FROM nls_database_parameters
3 WHERE parameter = 'NLS_CHARACTERSET';
PARAMETER VALUE
----------------- ------------------------------
NLS_CHARACTERSET AL32UTF8
Valid NLS Parameters
col parameter format a20
col value format a25
col map format a30
SELECT parameter, value, DECODE(parameter, 'CHARACTERSET',
utl_gdk.charset_map(VALUE), 'LANGUAGE',
utl_gdk.language_map(VALUE), 'TERRITORY',
utl_gdk.territory_map(VALUE), 'no function UTL_GDK.'||parameter||'_MAP') AS map
FROM v$nls_valid_values
ORDER BY 1,2;