How to use a pipe (|) operator in Windows like Unix for sqlplus

Use of pipe operator in windows like UNIX, basically we use this command to take the output of one command as input for another command, Mostly we're using it in Oracle "sqlplus.exe".

In other words, we can say a Oneliner command for SQL plus statements.

Example:

UNIX:
echo "select sysdate from dual;"|sqlplus scott/tiger@orcl









WINDOWS:
echo select sysdate from dual;|sqlplus -s scott/tiger@orcl 








Just a single/double quote Difference all look remain same.

Comments