Freeman

count() over (partition by date rows between date and date - 14)

rem NLS_LANG=RUSSIAN_RUSSIA.AL32UTF8
chcp 65001
sqlplus

set NLS_LANG=RUSSIAN_RUSSIA.CL8MSWIN1251
chcp 1251
sqlplus

set NLS_LANG=AMERICAN_RUSSIA.CL8PC866
sqlplus

If the TNS_ADMIN environment variable is not set, and TNSNAMES entries such as inst1, and so on, are used, then the ORACLE_HOME variable must be set, and the configuration files are expected to be in the $ORACLE_HOME/network/admin directory.