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!

how do I split a numeric column into two separate columns in Oracle SQL

wins-OracleMay 18 2017 — edited May 22 2017

Gurus,

Pls let me know if and how do I split a numeric column into two separate columns in Oracle SQL.For example I have a 16 digit card number and I would like to split this into two columns with first 6 digits in one column and next 10 digits in next column.

Existing :- 4356233478562314 Column CC

Desired :- 435623 coloumn A 3478562314 column B.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2017

Added on May 18 2017

34 comments

3,773 views