Oracle SQL Developer: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<source lang= | <source lang="ini"> | ||
#Tools>Preferences>Environment | #Tools>Preferences>Environment | ||
Encoding : UTF-8 | Encoding : UTF-8 | ||
#Tools>Preferences>Database>NLS | #Tools>Preferences>Database>NLS | ||
Date Format : RRRR-MM-DD"T"HH24:MI: | Date Format : RRRR-MM-DD"T"HH24:MI:SS".000" | ||
Timestamp Format : RRRR-MM-DD"T"HH24:MI:SSXFF3 | Timestamp Format : RRRR-MM-DD"T"HH24:MI:SSXFF3 | ||
Timestamp TZ Format : RRRR-MM-DD"T"HH24:MI:SSXFF3TZR | Timestamp TZ Format : RRRR-MM-DD"T"HH24:MI:SSXFF3TZR | ||
| Line 16: | Line 16: | ||
#Tools>Preferences>Database>Utilities>Import | #Tools>Preferences>Database>Utilities>Import | ||
File Encoding : UTF-8 | File Encoding : UTF-8 | ||
</source> | |||
<source lang="sql"> | |||
SELECT | |||
SYSDATE, | |||
systimestamp, | |||
current_date, | |||
current_timestamp | |||
FROM | |||
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