Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: instr question
That worked great, thanks - I was using sqldeveloper, and my artisan is
tied up in another report, so I didn't know it was so picky with the
formatting. I'm new! But thank you. This was a very simple example
that I can sit down and wrap my brain around and I totally appreciate
you writing me back.
Try and keep cool!
me
chris.hulan_at_gmail.com wrote:
> kimberly.shaffer_at_gmail.com wrote:
> > Thank you Brian,
> >
> > When I sort of plug in my current field and current table just to see
> > what results I get, I get the following error
> >
> > SELECT SUBSTR(so_act_arg,INSTR(so_act_arg),' ')+1,
> > INSTR(so_act_arg,' ',1,2) - NSTR(so_act_arg),' ')-1)
> > FROM appworx.so_object_cond
> > WHERE so_act_arg LIKE '-m%';
> >
> > FROM keyword not found where expected. What am I doing wrong?
>
> a tool that does SQL auto-formating (like TOAD) is usefull for this
> type of stuff.
>
> Try:
> SELECT SUBSTR (so_act_arg
> , INSTR (so_act_arg, ' ') + 1
> , INSTR (so_act_arg, ' ', 1, 2) - INSTR (so_act_arg, ' ')
> - 1
> )
> FROM appworx.so_object_cond
> WHERE so_act_arg LIKE '-m%';
Received on Thu Jul 20 2006 - 14:52:27 CDT