How does one write a trigger in PL/SQL to :
get source data such as "turner,vincent", "224 Argonne blvd", "New Orleans,
LA 70150", "504-532-2285 " to be transformed to:
LastName: Vincent FirstName: Turner Street: 224 Argonne blvd
City: New Orleans State: LA Zip: 70150 Phone: 504-532-2285
The trigger is to be written on the insert of Table A(with fields Name, Street,
Address, Phone) to load data into table B(with fields First Name,Last Name,Street,
City, State, Zip,Phone,Date, User).The date is the sysdate and user is the
current username in Oracle. How does one get both the user, date in the trigger?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL