Search Results

Thanks a lot for the excellent hint and feedback. Spooling sql results to a file and then reading it in was an option, however, I was leaving that to plan "B". In any case, I ended up going to that...

sql_rows=`sqlplus -s / <<EOF
set heading off
set pagesize 1000
set tab off
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name,...

Hi Methyl,

Sorry, I did not see your post...here is the code as it stands now. I played around with the ` and {} surrounding the variables. But no luck.
As you can see, I have removed the ` and...

Any ideas/suggestions where I can look to resolve this last remaining puzzle?

I have no clue what could be causing this. I checked the env variables, there is nothing there defined that is being...

Thanks a lot...for your prompt responses..

Wow..such obvious mistakes...well most of my problems have been resolved. One issue remains...for some reason, one of the variables remains defined...

I have developed the following shell script. The idea was to create an alias to execute it and return the tablespaces and their sizes from an oracle database. When I execute is via the alias, I have...