[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