Write a PL/SQL block to show the result to neglect double quotation marks in reserved word identifier
- pl/sql
- 2021-09-26
- mhanasmh00489829403
الأجوبة
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;
/
Sample Output:
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. /أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة