[thelist] Oracle query

evolt at mccullough-net.com evolt at mccullough-net.com
Tue Jun 8 10:51:04 CDT 2004


Here is the issue.  ||'|'||, is incorrectly formatted, I had a sneaking 
feeling it was that.

Quoting Nick Lester <nick at flowbike.com>:

> 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 !
> >
> >
> >
> 
> -- 
> * * 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 ! 
> 




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


More information about the thelist mailing list