|Subject:||Get Left characters from a field|
|Posted by:||Tony B (anthonybrou…@googlemail.com)|
|Date:||8 Nov 2006|
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