Q:

Write a PL/SQL block to show an invalid case-insensitive reference to a quoted and without quoted user-defined identifier

hamza
Save to bookmark
|
2022-05-18
|
  166 
0

Write a PL/SQL block to show an invalid case-insensitive reference to a quoted and without quoted user-defined identifier.

When identifier is enclosing with double quotation and reference to the identifier is also double quoted but in different case:

pl/sql,
login and add your own answer to this question

All Answers

hamza
2022-05-18
need an explanation for this answer? contact us directly to get an explanation for this answer 

DECLARE
  "WELCOME" varchar2(10) := 'welcome'; -- identifier with quotation 
BEGIN
  DBMS_Output.Put_Line("Welcome"); --reference to the identifier with quotation and different case
END;
/

Sample Output:

ORA-06550: line 4, column 25:
PLS-00201: identifier 'Welcome' must be declared
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored

2.   "WELCOME" varchar2(10) := 'welcome'; 
3. BEGIN
4.   DBMS_Output.Put_Line("Welcome"); 
5. END;
6. /

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions

need a help?

find thousands of online teachers now