PL/SQL Fundamentals Exercises: PL/SQL block to show Single and Multiline Comments
PL/SQL Fundamentals: Exercise-6 with Solution
Write a PL/SQL block to show single and multiline comments.
DECLARE some_condition BOOLEAN; pi NUMBER := 3.1415926; -- the value of pi is 3.1415926 : this is single line comment radius NUMBER := 10; area NUMBER; BEGIN IF 2 + 2 = 4 THEN some_condition := TRUE; /* IF is the simple control flow statement : this is multi line comment*/ END IF; /* The line below in the statement computes the area of a circle. After the area is computed, the result is displayed. : : this is multi line comment*/ area := pi * radius**2; DBMS_OUTPUT.PUT_LINE('The area of the circle is: ' || area); END; /
The area of the circle is: 314.15926 Statement processed. 0.00 seconds
At the time of testing or debugging a program, you can disable a line of code by making it a comment. For example:
-- DELETE FROM EMPLOYEES WHERE FIRST_NAME='Lex';
Improve this sample solution and post your code through Disqus
Previous: Write a PL/SQL block to show the result to neglect the case sensitivity of a user defined identifier which is also a reserved word.
Next: Write PL/SQL blocks to show the declaration of variables.
What is the difficulty level of this exercise?
- New Content published on w3resource :
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework