Dynamic Native SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dynamic Native SQL

  1. #1
    Join Date
    Jan 2001
    Posts
    3

    Question

    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.

  2. #2
    Join Date
    Aug 2000
    Location
    Toronto, Ontario Canada
    Posts
    52
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width