Does SQL*Plus natively allow queries to run from the shell itself?

Question

For example, is there equivalent of these in SQL*Plus

sqlplus 'SELECT * FROM emp' | less 
sqlplus 'SELECT * FROM emp' | grep Primx

One way has been suggested by paxdiablo here. Is that the only way?

Answer 1

you can do it with here documents:

sqlplus  -S user/password << EOF | grep Primx
select * from emp;
EOF

-S is for silent mode, followed by username and password combination.