<div>
Hi mawingho,<br />
<br />
not exactly how I would have written it ... but appears to follow the right rules and do the right job.<br />
<br />
lwadwell
</div>


Hi mawingho,

not exactly how I would have written it ... but appears to follow the right rules and do the right job.

lwadwell

<div>
So the logic is right, :) I am going to use it
</div>


So the logic is right, :) I am going to use it

<div>
i would say the below bit is not exactly correct. VISA card also has 16 digits right ?<br />
<br />
.....<br />
IF creditcardlength = 13<br />
&nbsp; &nbsp;THEN<br />
&nbsp; &nbsp; &nbsp; IF c1 IN (4)<br />
&nbsp; &nbsp; &nbsp; THEN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cardtype := ‘VISA’;<br />
......<br />
<br />
Also if at all there is some special &quot;,&quot; character in the card number, then we might have to put in the below extra line as well...<br />
<br />
....<br />
&nbsp;creditcardnumber := REPLACE(creditcardnumber, '_', '');<br />
....<br />
<br />
I would say you test that code what all kinds of credit cards data you have in your uat /test database/environment and then take a decision accordingly after validating the test results.<br />
<br />
Thanks<br />

</div>


i would say the below bit is not exactly correct. VISA card also has 16 digits right ?

.....
IF creditcardlength = 13
   THEN
      IF c1 IN (4)
      THEN
         cardtype := ‘VISA’;
......

Also if at all there is some special "," character in the card number, then we might have to put in the below extra line as well...

....
 creditcardnumber := REPLACE(creditcardnumber, '_', '');
....

I would say you test that code what all kinds of credit cards data you have in your uat /test database/environment and then take a decision accordingly after validating the test results.

Thanks


<div>
hi nav_kum_v,<br />
We did handle 16 digit visa card.<br />
thanks<br />

</div>


hi nav_kum_v,
We did handle 16 digit visa card.
thanks


<div>
<div class="content wysiwyg-content">
I want to write a function to validation credit card number, <br />
I found a code there<br />
<a href="http://www.notesbit.com/index.php/scripts-oracle/validate-the-credit-card-plsql-code/" rel="ugc">http://www.notesbit.com/index.php/scripts-oracle/validate-the-credit-card-plsql-code/</a><br />
but I am not sure whether it is good or not.<br />
Anyone can tell?
</div>
</div>


I want to write a function to validation credit card number, 
I found a code there
http://www.notesbit.com/index.php/scripts-oracle/validate-the-credit-card-plsql-code/
but I am not sure whether it is good or not.
Anyone can tell?

Credit Card Number Validation in PL/SQL

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.