ADVANCED TOPICS IN COMPILER DESIGN
CODE GENERATION FOR OBJECT ORIENTED LANGUAGES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Use an Exception section
|
|
|
You don’t need to do anything, the results will display automatically.
|
|
|
Use DBMS ____ OUTPUT.PUT ____ LINE
|
|
|
Write a C or Java program to display the results
|
Detailed explanation-1: -How can you display results to check that a PL/SQL block is working correctly? You don’t need to do anything, the results will display automatically.
Detailed explanation-2: -PL/SQL code normally will change data, insert values, and so forth, inside the database. It will not normally display results back to the user. To do this we use a procedure called dbms output. put line to place the results in a buffer that SQL*Plus will retrieve and display.
Detailed explanation-3: -If the condition is true, the statements get executed and if the condition is false or NULL then the IF statement does nothing. IF statement adds the keyword ELSE followed by an alternative sequence of statement. If the condition is false or NULL, then only the alternative sequence of statements get executed.
Detailed explanation-4: -The DBMS OUTPUT is a built-in package that enables you to display output, debugging information, and send messages from PL/SQL blocks, subprograms, packages, and triggers.