This is Bavaria, Germany!
Svrmgrl is dead and superseeded by sqlplus /nolog. You can shutdown Oracle with a batchfile like this:
rem down.bat sqlplus.exe /nolog @down.sql >down.logThe file down.sql looks like this:
connect sys/XXXXXXXXX@your_db_sid as sysdba shutdown immediate exitTo startup replace shutdown immediate with startup
Output in SQLPlus looks terrible and is nearly unreadable. This depends on the width of the columns. You can format you columns like this
set recsep off set linesize 100 set newpage 0 set pagesize 999 column famname format a15 column rufname format a10 column gebdat format a10 select famname, rufname, gebdat, om from e01e001 where... FAMNAME RUFNAME GEBDAT OM -------------- ---------- ---------- ---------- Lippmann Richard 09.07.1966 12 Meier Luise 01.01.1834 13 ...
SQL> select count(*) from e01e903 where p_datum > (sysdate - 7);
COUNT(*)
--------
3610
Select records older than a week.
SQL> select count(*) from e01e903 where p_datum < (sysdate - 7); COUNT(*) -------- 496810