Oracle SQL Developer

From Chorke Wiki
Jump to navigation Jump to search
#Tools>Preferences>Environment
Encoding            : UTF-8

#Tools>Preferences>Database>NLS
Date Format         : RRRR-MM-DD"T"HH24:MI:SS".000"
Timestamp Format    : RRRR-MM-DD"T"HH24:MI:SSXFF3
Timestamp TZ Format : RRRR-MM-DD"T"HH24:MI:SSXFF3TZR

#Tools>Preferences>Database>Utilities>Export
Pretty Print        : Checked
Terminator          : Checked
Add Force to Views  : Checked
Encoding            : UTF-8

#Tools>Preferences>Database>Utilities>Import
File Encoding       : UTF-8
SELECT
    SYSDATE,
    systimestamp,
    current_date,
    current_timestamp
FROM
    dual