ng subsequent updates and deletes. An example follows DECLARE CURSOR c1 IS SELECT ename, job, rowid FROM emp my ename emp.ename TYPE my job emp.job TYPE my rowid UROWID BEGIN OPEN c1 LOOP FETCH c1 INTO my ename, my job, my rowid EXIT WHEN c1 NOTFOUND UPDATE emp SET sal sal 1.05 WHERE rowid my rowid this mimics WHERE CURRENT OF c1 COMMIT END LOOP CLOSE c1 END Be careful. In the last example, the fetched rows are not locked because no FOR UPDATE clause is used. So, other users might unintentionally overwrite your changes. Also, the cursor must have a read consistent view of the data, so rollback segments used in the update are not released until the cursor is closed. This can slow down processing when many rows are updated. The next example shows that you MCSA it exam can use the Microsoft Certification ROWTYPE attribute with cursors that reference the ROWID pseudocolumn DECLARE CURSOR c1 IS SELECT ename, sal, rowid FROM emp emp rec c1 ROWTYPE BEGIN OPEN c1 LOOP FETCH c1 INTO emp rec EXIT WHEN c1 NOTFOUND IF THEN DELETE FROM emp WHERE rowid emp rec.rowid END IF Doing Independent Units of Work with Autonomous Transactions Interaction Between MCSA PL SQL and Oracle 6 53 END LOOP CLOSE c1 END.

Exam CodeExam NameVendorCertifications
070-410 Installing and Configuring Windows Server 2012 Microsoft MCSA
070-411 Administering Windows Server 2012 Microsoft MCSA
070-412 Configuring Advanced Windows Server 2012 Services Microsoft MCSA
070-417 Upgrading Your Skills to MCSA Windows Server 2012 Microsoft MCSA
070-457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 Microsoft MCSA
070-458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Microsoft MCSA
070-461 Querying Microsoft SQL Server 2012 Microsoft MCSA
070-462 Administering Microsoft SQL Server 2012 Databases Microsoft MCSA
070-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 Microsoft MCSA
070-646 Windows Server 2008, Server Administrator Microsoft MCSA
070-680 TS:Windows 7,Configuring Microsoft MCSA
070-685 Pro: Windows 7, Enterprise Desktop Support Technician Microsoft MCSA
070-687 Configuring Windows 8 Microsoft MCSA
070-688 Managing and Maintaining Windows 8 Microsoft MCSA
70-214 Implementing and Administering Security in a Microsoft Windows 2000 Network Microsoft MCSA
70-215 Installing, Configuring and Administering Microsoft Windows 2000 Server Microsoft MCSA
70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure Microsoft MCSA
70-218 Managing a Microsoft Windows 2000 Network Environment Microsoft MCSA
70-224 Installing, Configuring and Administering Microsoft Exchange 2000 Microsoft MCSA
70-244 Supporting and Maintaining a Microsoft Windows NT Server 4.0 Network Microsoft MCSA
70-410 Installing and Configuring Windows Server 2012 Microsoft MCSA
70-411 Administering Windows Server 2012 Microsoft MCSA
70-412 Configuring Advanced Windows Server 2012 Services Microsoft MCSA
70-417 Upgrading Your Skills to MCSA Windows Server 2012 Microsoft MCSA
70-457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 Microsoft MCSA
70-458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Microsoft MCSA
70-461 Querying Microsoft SQL Server 2012 Microsoft MCSA
70-462 Administering Microsoft SQL Server 2012 Databases Microsoft MCSA
70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 Microsoft MCSA
70-646 Windows Server 2008, Server Administrator Microsoft MCSA
70-680 TS:Windows 7,Configuring Microsoft MCSA
70-685 Pro: Windows 7, Enterprise Desktop Support Technician Microsoft MCSA
70-687 Configuring Windows 8 Microsoft MCSA
70-688 Managing and Maintaining Windows 8 Microsoft MCSA

Our Management Team

Jeff Davidson, P.E.

Jeff Davidson, P.E.

Founder and President
Josh Fruth

Josh Fruth

Vice President
Ryan White, P.E.

Ryan White, P.E.

Engineering Production Manager
Fred Hood, AICP

Fred Hood, AICP

Senior Planner
Andrew Rath, P.E.

Andrew Rath, P.E.

Project Manager

The staff at Davidson Engineering are professionals who excel in their area of expertise and strongly believe in a ‘hands-on’ approach to their projects and dealing with clients.