... these.
I would recommend using the DataTumble script over this one as this leaves data very difficult to work with:
Before:
StudentID StudentName DateOfBirth
...
... the default values which we found we could do with the built-in SOUNDEX function.
How?
Lets assume the following, we have a table containing:
StudentID StudentDetail Soundex
----------------- ...
... with
Our Stored Procedure would check if the unique identifying number (in our case StudentID) matches a record in the database table and that the request number was alphanumeric. In addition, this ...
... Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID ...
... to include the Username check as well (…WHERE StudentID=@StudentReference OR StudentName=@StudentADAccount). And according to other web articles on this matter, I have to change the order of my parameters ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.