SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing Part of a Column of Data

bostonmacosxJan 24 2013 — edited Jan 25 2013

Hello there. Oracle 11g PLSQL question

I'm wondering how I can import a partial amount of data from a CSV column.

Let's say that the Data is:

XXX.YY.ZZZZ what I want to insert though is just XXX.
So I need to I believe take the piece of data and read it up to the first period in the name.

I'm just stumped as how to do that.

I think I will have a result of

INSERT INTO TABLE (col001,col002) VALUES (some_function(XXX.YY.ZZZZ),'hello');

So I'm just not sure what thefunction would be to do this though.

Any help appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2013

Added on Jan 24 2013

#11g, #apex, #database, #pl-sql, #plsql

8 comments

409 views