Write a PL/SQL block to show a valid case-insensitive reference to a quoted and without quoted user-defined identifier
- pl/sql
- 2021-09-26
- mhanasmh00489829403
الأجوبة
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
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة