Why are Oracle table/column/index names limited to 30 characters?

by

I believe it’s the ANSI standard.

EDIT:

Actually, I think it’s the SQL-92 standard.

A later version of the standard appears to optionally allow for 128 character names, but Oracle doesn’t yet support this (or has partial support for it, insofar as it allows 30 characters. Hmmm.)

Search for “F391, Long identifiers” on this page… http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/ap_standard_sql001.htm

(Looking for a ref)

More Related Contents:

  1. null vs empty string in Oracle [duplicate]
  2. Convert timestamp datatype into unix timestamp Oracle
  3. check if “it’s a number” function in Oracle
  4. Trigger to enforce M-M relationship
  5. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  6. Is it possible to kill a single query in oracle without killing the session?
  7. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  8. How to View Oracle Stored Procedure using SQLPlus?
  9. Calculate difference between 2 date / times in Oracle SQL
  10. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  11. How to generate entire DDL of an Oracle schema (scriptable)?
  12. How to get records randomly from the oracle database?
  13. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  14. Get resultset from oracle stored procedure
  15. Deploying and Configuring ODP.NET to work without installation with Entity Framework
  16. ways to avoid global temp tables in oracle
  17. Spring Batch ORA-08177: can’t serialize access for this transaction when running single job, SERIALIZED isolation level
  18. How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
  19. Error while trying to retrieve text for error ORA-01804
  20. Does Oracle support full text search?
  21. Oracle.ManagedDataAccess.EntityFramework – ORA-01918: user ‘dbo’ does not exist
  22. Why doesn’t PL/SQL respect privileges granted by Roles?
  23. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  24. Can We use threading in PL/SQL?
  25. Speed up to_sql() when writing Pandas DataFrame to Oracle database using SqlAlchemy and cx_Oracle
  26. Get ID of last inserted record in oracle db
  27. How to use parameters in a ‘where value in…’ clause?
  28. ORA-01861: literal does not match format string
  29. Query a Table’s Foreign Key relationships
  30. Why cannot I create triggers on objects owned by SYS?

Leave a Comment