[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