Oracle SQL Developer: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 22: | Line 22: | ||
SYSDATE, | SYSDATE, | ||
systimestamp, | systimestamp, | ||
current_date, | |||
current_timestamp | current_timestamp | ||
FROM | FROM | ||
dual | dual | ||
</source> | </source> | ||
Latest revision as of 02:18, 15 July 2019
#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