Oracle SQL Developer: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<source lang='ini'> #Tools>Preferences>Database>NLS Date Format : RRRR-MM-DD"T"HH24:MI:SSXFF3 Timestamp Format : RRRR-MM-DD"T"HH24:MI:SSXFF3 Timestamp TZ Format : R...") |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<source lang= | <source lang="ini"> | ||
#Tools>Preferences>Environment | |||
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 | ||
#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 | |||
</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