GitHub

ash_sql_wait_tree_hist_temp.sql

with ash as (select /*+ materialize*/ CAST(sample_time AS DATE) as stime, s.* from &1) --SYSTEM.ASH_201901151747 s)--dba_hist_active_sess_history s where '&&2' is ...
The Earth Institute Columbia University

SQL Reference

The SUBSTR function returns a substring of a string. If string is a character string, the result of the function is a character string represented in the code page of its first argument. If it is a ...
GitHub

Postgres: substring generates numeric arguments instead of integer

library(dbplyr) translate_sql(substring('abcdefghijklmno', 6,7)) #> Expected: <SQL> substring('abcdefghijklmno', 6, 7) #> Actual: <SQL> substring('abcdefghijklmno', 6 ...