Re: Get Left characters from a field

hpuxrac wrote:
> Tony B wrote:
> > Hi All
> >
> > I am a newbie to oracle so please be kind!
> >
> > I have a table with a field "Name" VarChar(20).
> >
> > How do I create a view that contains a field "ShortName" (10) that
> > contains the first 10 characters from the "Name" field.
> >
> > Thanks for your help
> >
> > Tony
>
> There's a lot of knowledgeable people here but not so many kind ones.
> We appreciate people that research things themselves before bringing
> questions here.
>
> Oracle documentation is available at http://tahiti.oracle.com ... take
> the time to get familiar with it.
>
> Tom Kyte has a good site at http://asktom.oracle.com with a good search
> facility.
>
> create myshortview as select substr(name,1,10) "Shortname" from
> mybigtable;

Thanks for the reply.

I have taken your points on board and added both links to favouries.

Regards

Tony Received on Wed Nov 08 2006 - 17:12:10 CST