[thelist] Oracle query

evolt at mccullough-net.com evolt at mccullough-net.com
Tue Jun 8 08:54:14 CDT 2004


Writting a sql script and I seem to be having an issue, I'm usually doing this 
server side but this need to be called from a shell script and so I'm creating 
a sql file.  I seem to be running into issues, now please DBA's dont laugh 
because I know you will be, but I'm a programmer and dont live in this world 
often.

Here is what I am trying to do.  Need to create a froogle feed, but I have to 
get the information out which means checking several tables.  So here is my 
SQL.

set colsep ','
set pagesize 0
set feedback off
set linesize 2000
set trimspool on
set recsep off
set termout off

spool froogle.txt

SELECT (i.ITEM_ID)
i.ITEM_NAME||'|'||,
i.STATUS||'|'||,
i.LONG_DESC||'|'||,
i.LARGE_IMAGE||'|'||,
i.ITEM_ID||'|'||,
a.ITEM_ID||'|'||,
a.QUANTITY||'|'||, 
s.ITEM_ID||'|'||,
s.SKU_PRICE||'|'||
FROM ITEM i, ITEM_AVAILABILITY a, SKU_LINK s
WHERE i.STATUS = '1'
AND i.ITEM_ID = s.ITEM_ID
AND i.ITEM_ID = a.ITEM_ID
AND a.QUANTITY > 0;

spool off
/
EXIT;

any help I'm getting different errors before anything starts.

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


More information about the thelist mailing list