title: Oracle View based on "Offsets" of a Table Column
body: <p>So I have this Table that I need to create a view from, We'll call it TABLEABC. The thing about this table is that it has 2 Columns. Column 1 we'll call C1 and it's a CHAR(25) column.
  Easy enough.</p>
  
  <p>The tricky part is the next column....and what I need to do with it.
  We'll call it C2 and it is 600 Bytes!</p>
  
  <p>Why you may ask? Well it's 600 characters because I am storing data in it based on offsets.</p>
  
  <p>For instance:
  NAME1 is size:15 Beginning Offset:1 Ending Offset:12
  NAME2 is size:45 Beginning offset:13 Ending Offset: 49</p>
  
  <p>So basically I need to store this Column based on the offsets, AND the "Offset Named" need to be specific, IE NAME1/NAME2 (Actually called different things, but Name1/Name2 for now)
  There are also like 15 of these offsets.</p>
  
  <p>Now i've done a bit of Oracle admin stuff, but just your basic stuff. I know SQL Server better but this is way beyond what Im used to doing, but im always looking for a challenge. Views are also sorta new to me. So that makes it even more difficult.</p>
  
  <p>I figure maybe this would be a SUBSTR function, like:</p>
  
  <pre><code>SELECT SUBSTR(C2, 1, 12) As NAME1 from TABLE
  </code></pre>
  
  <p>Would that work? I've not done anything with Stored Procedures, so maybe theirs a better way?</p>
  
  <p>edit:</p>
  
  <p>So for a sample wise, (I would need to add the different offsets) would something like this work. (im not sure how to arrange the select statements, can I just add them on top of each other? Like does this work (assuming I add the rest of the selects?) and would anything need to be added at the end?</p>
  
  <blockquote>
    <p>CREATE VIEW VIEW1 AS<br>
     SELECT C1 FROM TABLE<br>
     SELECT SUBSTR(C2, 1,12) As 'NAME1' from TABLE<br>
     SELECT SUBSTR(C2, 13, 45) As 'NAME2' from TABLE</p>
  </blockquote>