Search Results

yup i did... seriously no idea where went wrong =(

hi,

thanks for your help but the tmpfile is still undefined variable...

hi,

i tried but its still not running...not too sure if i am doing the correct way

$DCITS_SQL << EOF
SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON VERIFY OFF TIMING OFF TERMOUT...

hi,

i tried...its doesn't work as well...

==========================================================
{$DCITS_SQL << EOF
set head off
select a.FIN,a.STAFF_NAME_X,b.FIN,b.DEPT_C from...

mine is without the -s

========================================================
SQL*Plus: Release 9.2.0.5.0 - Production on Mon Apr 30 10:10:42 2007

Copyright (c) 1982, 2002, Oracle...

hi,

pardon me...because I have no idea what is sqlplus and -s...

$DCITS_SQL is set to a path that points to another script that runs the db

hi!
the sql is finally returning something but the while loop is still not working...

error message:


SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -...

hi,

so glad to see ur reply

here's my error

Missing }
}: Command not found
while: Expression syntax


thanks!

hi,

i tried piping the whole thing to while read but there are still some errors:

#construct SQL statement

{$DCITS_SQL << EOF
set head off
select a.FIN,a.STAFF_NAME_X,b.FIN,b.DEPT_C from...

hi,

i am trying to do a unix script and this is my first time getting in touch with unix.

i am trying to query and execute the following:
====================================================
...