Search Results

There are lot of books available in the market, I used the below book when i started learning Shell script.
Amazon.com: Unix Shell Programming (3rd Edition) (9780672324901): Stephen G. Kochan,...

Try with single quote
echo '
set lines 2000
set pagesize 100
select a.tablespace_name as "tablespace",allocated as "size in gb",
(a.allocated - nvl(b.freespace,0)) as "used space in...

How about this ?
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl
echo "
spool /home/oracle/tablespace_analysis.log...