How do you SELECT a value from a table into a Unix variable?

[dba_admin]

Could you please tell me why the first one works but the second fails?


tt=`sqlplus -silent dba_mydb/dba_mydb@mydb < set pagesize 0 feedback off verify off heading off echo off
select count(*) from user_tables;
--select count(*) from v\$log;
exit;
END`
echo $tt

tt=`sqlplus -silent dba_mydb/dba_mydb@mydb < set pagesize 0 feedback off verify off heading off echo off
--select count(*) from user_tables;
select count(*) from v\$log;
exit;
END`
echo $tt