oracle11g - Oracle View based on "Offsets" of a Table Column -

so have table need create view from, we'll call tableabc. thing table has 2 columns. column 1 we'll call c1 , it's char(25) column. easy enough.

the tricky part next column....and need it. we'll call c2 , 600 bytes!

why may ask? it's 600 characters because storing data in based on offsets.

for instance: name1 size:15 beginning offset:1 ending offset:12 name2 size:45 beginning offset:13 ending offset: 49

so need store column based on offsets, , "offset named" need specific, ie name1/name2 (actually called different things, name1/name2 now) there 15 of these offsets.

now i've done bit of oracle admin stuff, basic stuff. know sql server better way beyond im used doing, im looking challenge. views sorta new me. makes more difficult.

i figure maybe substr function, like:

select substr(c2, 1, 12) name1 table 

would work? i've not done stored procedures, maybe theirs better way?

edit:

so sample wise, (i need add different offsets) work. (im not sure how arrange select statements, can add them on top of each other? work (assuming add rest of selects?) , need added @ end?

create view view1 as
select c1 table
select substr(c2, 1,12) 'name1' table
select substr(c2, 13, 45) 'name2' table

something like

create view view1   select     c1,     substr(c2, 1,12) name1,     select substr(c2, 13, 45) name2       table1; 

would work fine.