Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to select first 6 and last 4

unknown-1052419Feb 24 2014 — edited Feb 26 2014

Hi All,

11.2.0.1

Hi all,

I have a table with column CARDNO which contains variable digits credit card numbers ranging from 16 to 20 digits.

I want to display the first 6 and last 4 digits only.

For the first 6, I can do> substr(cardno,1,6)

Can you help me with the last 4 please....

Thanks,

pK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2014
Added on Feb 24 2014
44 comments
11,753 views