Monday, April 1, 2019

SQL Developer Cheat Sheet

To copy result with header:
Select all - Ctrl + A
Copy with header - Ctrl + Shift + C

To set the date time on date field:
alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';