SQLPLUS BANG AND HOST DIFFERENT

Using sqlplus 3, I found that the ! and host commands are different.

!ls

does the same as

        host ls

However

! Does not translate Oracle defined variables
        host Does translate Oracle defined variables

Thus :

! test -d $HOME && echo "You have a home"
    will work

	define fred="hello"
	host echo "&&fred"

But : host test -d $HOME && echo "You have a home"

      WILL NOT WORK. Received on Fri Feb 21 1992 - 03:53:28 CET