Long identifiers since 12.2 release (2017)

long_identifiers.sql

-- Supporting 128 bytes long identifiers since 2017
CREATE TABLE my_table_which_really_deserves_such_a_long_name (
  unique_identifier_that_explains_it_all_very_easily NUMBER,
  -- Also supporting 32767 bytes for VARCHAR2 since 2013
  message VARCHAR2(32767)
);

INSERT INTO my_table_which_really_deserves_such_a_long_name
VALUES ( 1, 'Hello World!' );

1 row inserted.

SELECT * FROM my_table_which_really_deserves_such_a_long_name;

 UNIQUE_IDENTIFIER_THAT_EXPLAINS_IT_ALL_VERY_EASILY       MESSAGE
--------------------------------------------------- -------------
                                                  1  Hello World!