Home » SQL & PL/SQL » SQL & PL/SQL » Pan card insert time validation (3 merged) (Oracle 11g)
Pan card insert time validation (3 merged) [message #678669] Thu, 26 December 2019 08:40 Go to next message
Sivasai506
Messages: 4
Registered: December 2019
Junior Member
Hi experts,

My requirement is pancard insert time verification.only accept this format"BFCGS1576V" If give any wrong format not accepting.

Insert into pan_card ('BFCGS1576V); Only insert this format.
If insert another format example.
Insert into pan_card ('BFCG1576VG') this format not allowed.
This my requirement.
Pan card insert time validation [message #678670 is a reply to message #678669] Thu, 26 December 2019 08:45 Go to previous messageGo to next message
Sivasai506
Messages: 4
Registered: December 2019
Junior Member
experts,

My requirement is pancard insert time verification.only accept this format"BFCGS1576V" If give any wrong format not accepting.

Insert into pan_card ('BFCGS1576V); Only insert this format.
If insert another format example.
Insert into pan_card ('BFCG1576VG') this format not allowed.
This my requirement. ('BFCG1576VG') this format not allowed.
This my requirement
Pan card insert time validation [message #678671 is a reply to message #678669] Thu, 26 December 2019 08:47 Go to previous messageGo to next message
Sivasai506
Messages: 4
Registered: December 2019
Junior Member
experts,

My requirement is pancard insert time verification.only accept this format"BFCGS1576V" If give any wrong format not accepting.

Insert into pan_card ('BFCGS1576V); Only insert this format.
If insert another format example.
Insert into pan_card ('BFCG1576VG') this format not allowed.
This my requirement
Re: Pan card insert time validation (3 merged) [message #678672 is a reply to message #678669] Thu, 26 December 2019 09:10 Go to previous messageGo to next message
Michel Cadot
Messages: 66851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
only accept this format"BFCGS1576V"

Define "this format" (by the way "BFCGS1576V" is not a format but a value).

For instance, why this value "BFCG1576VG" is not allowed?

[Updated on: Thu, 26 December 2019 09:16]

Report message to a moderator

Re: Pan card insert time validation (3 merged) [message #678707 is a reply to message #678672] Mon, 30 December 2019 06:52 Go to previous message
Bill B
Messages: 1932
Registered: December 2004
Senior Member
This entry is answered in

http://www.orafaq.com/forum/index.php/t/187935/
Previous Topic: Validation of PAN Number in sql query
Next Topic: WITH Clause VS INLINE View Execution
Goto Forum:
  


Current Time: Wed Feb 19 12:59:43 CST 2020