Hello -

I am trying to create some reports from an Oracle Database. Unfortunately the database is not normalized (not even 1st normal form) which makes what I am trying to do very difficult.

One of the fields in this database is actually its own fixed length record that holds approx. 30 additional elements for that record. I need to include a few of these elements in my report but I can't figure out a way to retrieve them easily.

I am used to working with SQL Server which has string functions that allow you to only pull back a specific range of characters out of a field, but I can't find any of those types of functions in Oracle.

Basically I need a way to select field 1, field 2, and characters 30-42 of field 3 out of this table. Eventually I might want to do something like select field 1 and 2 where the 30th-42nd character of field 3 = xxxxxxx. Any help would be greatly appreciated.

Thanks,
Mike

We have rich set of string library functions in oracle too. Check oracle documentation for this. Use substr,instr etc.