Re: Get Left characters from a field

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 8 Nov 2006 15:01:33 -0800
Message-ID: <1163026893.149135.174740@i42g2000cwa.googlegroups.com>

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; Received on Wed Nov 08 2006 - 17:01:33 CST