Home » SQL & PL/SQL » SQL & PL/SQL » Data_Validation_In_Pl/SQL (Oracle 10g)
Data_Validation_In_Pl/SQL [message #577634] Tue, 19 February 2013 04:41 Go to next message
tabj
Messages: 14
Registered: June 2012
Junior Member
Hi All,

I have a requirement like to validate the data in PL/SQL script dynamically.

I have 4 tables

TEST_TBL: Data available in this table
TEST_VALID_TBL: Contains field names of TEST_TBL and condition
VALID: Need to insert valid records
INVALID: Need to insert invalid records

I have to insert data into valid table when validation are full filled otherwise it should be insert invalid table .

Validation are based on TEST_VALID_TBL

While checking the data validations FIELD_NAME should be passed dynamically,because i have four columns in TEST_TBL
but at present I am validating only 3 columns in feature it may be add more columns to validate.

Please do the needful asap.



Regards,
Dileep




  • Attachment: Test_1.sql
    (Size: 0.96KB, Downloaded 22 times)

Report message to a moderator

Re: Data_Validation_In_Pl/SQL [message #577639 is a reply to message #577634] Tue, 19 February 2013 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 54192
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Better create your fields with appropriate data types and check constraints.

Regards
Michel

Report message to a moderator

Re: Data_Validation_In_Pl/SQL [message #577644 is a reply to message #577639] Tue, 19 February 2013 06:06 Go to previous messageGo to next message
tabj
Messages: 14
Registered: June 2012
Junior Member
Hi Michel,

thanks for reply.

In my case constrains is not possible because condition also can change randomly.

Please help me on this.


regards,
dileep.

Report message to a moderator

Re: Data_Validation_In_Pl/SQL [message #577648 is a reply to message #577644] Tue, 19 February 2013 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 54192
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Conditions change ramdomly! Gee, you live in a strange world, a price becomes a date then a size then a weight then an age then a number of shower then the color of eyes then a distance...

Regards
Michel

Report message to a moderator

Re: Data_Validation_In_Pl/SQL [message #577815 is a reply to message #577648] Wed, 20 February 2013 21:26 Go to previous message
xpact83
Messages: 203
Registered: October 2008
Location: philippines
Senior Member
Your columns in test_tbl match the datatype in test_valid_tbl. So what is the need of checking datatypes if for example column logti of test_tbl is float and the record for logti in test table is also float.

Report message to a moderator

Previous Topic: job runs every 2 minutes, procedure works about 1,5 minutes
Next Topic: how to get col info from ref cursor
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 22 10:35:19 CDT 2013

Total time taken to generate the page: 0.25932 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.