Write a PL/SQL block to show an invalid 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 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. /أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة