Q:

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

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

Write a PL/SQL block to show a valid 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 without quoted:

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 without quotation
END;
/

Sample Output:

welcome

Statement processed.

0.00 seconds

When identifier is enclosing without double quotation and reference to the identifier is without quoted:

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

Sample Output:

welcome

Statement processed.

0.00 seconds

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