[thelist] Oracle query

Nick Lester nick at flowbike.com
Tue Jun 8 10:35:34 CDT 2004


Hi

Is the following any better? You had a concatenation operator at the end
of the column list in the SELECT clause.

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_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;




evolt at mccullough-net.com said:
> 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/
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
>
>



More information about the thelist mailing list