In first example, i can show these:
[oracle@localhost~] echo “select count(*) from tab;” | sqlplus -s username/pass
With another method, you can run from one Linux command a SQL file
[oracle@localhost~] sqlplus -s username/pass <filename.sql
COUNT(*)
————-
20
- alias sysdba='select status, instance_name from v\$instance; | sqlplus / as sysdba'
- alias sysoper='sqlplus / as sysoper'
- alias rman='rman target / '
Comentários