PL/SQL Fundamentals Exercises: PL/SQL block to Neglect Double Quotation Marks in Reserved Word Identifier
PL/SQL Fundamentals: Exercise-4 with Solution
Write a PL/SQL block to show the result to neglect double quotation marks in reserved word identifier.
In the example below he references should be a quoted user-defined identifier which is a reserved word and also have been neglected to enclose it in double quotation marks.
DECLARE "WORLD" varchar2(20) := 'world'; -- WORLD is not a reserved word "DECLARE" varchar2(20) := 'declare'; -- DECLARE is a reserved word BEGIN DBMS_Output.Put_Line(World); -- Double quotation marks are optional DBMS_Output.Put_Line(DECLARE); -- Double quotation marks are required end; /
ORA-06550: line 6, column 24: PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following: ( ) - + case mod new not null table continue avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month day hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date 4. BEGIN 5. DBMS_Output.Put_Line(World); -- Double quotation marks are optional 6. DBMS_Output.Put_Line(DECLARE); -- Double quotation marks are required 7. end; 8. /
Improve this sample solution and post your code through Disqus
Previous: Write a PL/SQL block to show a reserved word can be used as a user-define identifier.
Next: 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.
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