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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
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: 1971
Registered: December 2004
Senior Member
This entry is answered in

http://www.orafaq.com/forum/index.php/t/187935/

Report message to a moderator

Previous Topic: Validation of PAN Number in sql query
Next Topic: WITH Clause VS INLINE View Execution
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Oct 16 10:26:14 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.