SQL - mosinn/DOCS-n-Snippets-n-Steps GitHub Wiki

SQL Developer local VARIABLES for bind variable replacement

define value1 = 'sysdate';
SELECT &&value1 from dual;

Session change

ALTER SESSION SET CURRENT_SCHEMA = abcUserNoQuotes

Avoid Date/Time mess while reading fake sql developer formatted date column showing only date and skipping time

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

DB column TS and want to query by date string ?

---- and TS_COL > TO_TIMESTAMP('2020-04-22 00:01:00','YYYY-MM-DD HH24:MI:SS') and TS_COL < TO_TIMESTAMP('2020-04-22 23:59:00','YYYY-MM-DD HH24:MI:SS') and ---