View the Exhibit and examine the structure of the EMP table.
Which stages are performed when the above block is executed? (Choose all that apply)
A. Bind
B. Parse
C. Fetch
D. Execute
View the Exhibit and examine the structure of the EMP table.
Which stages are performed when the above block is executed? (Choose all that apply)
A. Bind
B. Parse
C. Fetch
D. Execute
Parse – for all statements
Execute – non query (DML)
Fetch – query statements
v_sal+1000 does result in bind “internally”
Answer: B,C,D