Executing the PL/SQL Procedure 2 – Taking SQL Developer for a Drive

The idea of shift-left has become increasingly popular as teams face pressure to deliver software more frequently and with higher quality. Shift-left potentially speeds up development efficiency and helps reduce costs by detecting and addressing software defects as early as possible in the development cycle, ideally long before such defects get to production. “Fixing the […]

Executing the PL/SQL Procedure – Taking SQL Developer for a Drive

Executing the PL/SQL Procedure Right-click the UPDATE_EMPLOYEES procedure name in Figure 3-7. This should display the procedure-specific context menu, as shown in Figure 3-8. Notice the options available in relation to managing the PL/SQL procedure, such as: Figure 3-8. Executing PL/SQL in the containerized Oracle Database instance Clearly, this menu provides a lot of power. […]