| 47,13 → 47,17 |
|---|
| # ALTER SESSION SET NLS_DATE_FORMAT = 'yyyy-mm-dd hh24:mi:ss'; |
| mv ../setup/sql/example_oracle.sql ../setup/sql/example_oracle.tmp |
| echo "ALTER SESSION SET NLS_DATE_FORMAT = 'yyyy-mm-dd hh24:mi:ss';" > ../setup/sql/example_oracle.sql |
| # "set define off" is important, otherwise we cannot use "&" in a SQL statement |
| echo "set define off" >> ../setup/sql/example_oracle.sql |
| echo "" >> ../setup/sql/example_oracle.sql |
| cat ../setup/sql/example_oracle.tmp >> ../setup/sql/example_oracle.sql |
| rm ../setup/sql/example_oracle.tmp |
| |
| # Dates need "TIMESTAMP" prefix |
| sed -i "s/'2018/TIMESTAMP '2018/g" ../setup/sql/example_oracle.sql |
| sed -i "s/'2019/TIMESTAMP '2019/g" ../setup/sql/example_oracle.sql |
| for year in {2010..2099} |
| do |
| sed -i "s/'$year/TIMESTAMP '$year/g" ../setup/sql/example_oracle.sql |
| done |
| |
| # Change "\n" to "' || chr(10) || '" |
| sed -i "s/\\\n/' \|\| chr\(10\) \|\| '/g" ../setup/sql/example_oracle.sql |