12.2: Identifiers can now be up to 128 bytes in length!

View All Scripts Login to Run Script

Script Name 12.2: Identifiers can now be up to 128 bytes in length!
Description Yes, indeed, with 12.2, Oracle Database removes the restriction of a maximum of 30 bytes for an identifier name: table name, column name, procedure name, package name, parameter name....you name it! Now you can write more self-documenting code (but don't overdo it!), as well as migrate code and data structures more easily from other databases and languages that already supported longer names.
Area PL/SQL General
Contributor Steven Feuerstein
Created Wednesday January 11, 2017

Statement 1

CREATE OR REPLACE VIEW all_approved_quizzes_already_taken
AS
   SELECT * FROM DUAL

View created.

Statement 2

CREATE OR REPLACE PROCEDURE mark_quiz_closed_when_all_players_finished
AS
BEGIN
   NULL;
END;

Procedure created.

Additional Information