Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Get Left characters from a field
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 Received on Wed Nov 08 2006 - 16:28:28 CST