Dynamic Native SQL

[mcioffi]

I need to update a table that I will supply at runtime, via a stored procedure. I'm looking at email addresses and I need to find addresses that fit certain rules, IE @ aol.com and other specific information. I was hoping to setup a cursor that would grab each row and run the record through various checks, if it fits any set a variable equal to 1 for the rule it satisfies, than update the table setting a series a columns based on the values of the variables. I'm very new to Oracle and really need some guidance for this stuff. If anyone has any ideas please pass them along. Thanks.

[steviep9]

Check out the substr function and then parse out the
string your looking for an insert into a variable.
Take the variable an insert into some table.