Write a PL/SQL block to show a reserved word can be used as a user-define identifier

  • pl/sql

Write a PL/SQL block to show a reserved word can be used as a user-define identifier.

In the example below quoted user-defined identifiers "DECLARE", "Declare", and "declare" have been declared. The word DECLARE, Declare and declare represent the same reserved word, "DECLARE", "Declare", and "declare" represent different identifiers.

الأجوبة

DECLARE
  "DECLARE" varchar2(25) := 'This is UPPERCASE';
  "Declare" varchar2(25) := 'This is Proper Case';
  "declare" varchar2(25) := 'This is lowercase';
BEGIN
  DBMS_Output.Put_Line("DECLARE");
  DBMS_Output.Put_Line("Declare");
  DBMS_Output.Put_Line("declare");
END;
/

Sample Output:

This is UPPERCASE
This is Proper Case
This is lowercase

Statement processed.

0.16 seconds
هل كان المحتوى مفيد؟

معلومات ذات صلة

تبحث عن مدرس اونلاين؟

محتاج مساعدة باختيار المدرس الافضل؟ تواصل مع فريقنا الان لمساعدتك بتأمين افضل مدرس
ماهو التخصص الذي تبحث عنه؟
اكتب هنا...