为什么存储过程名称有最大长度? [英] Why is there a maximum length for stored procedure names?
问题描述
Possible Duplicate:
Why are Oracle table/column/index names limited to 30 characters?
在Oracle中编写存储过程时,我选择了一个特别具有描述性的名称,而在尝试更新脚本时,我被告知该名称太长.
When writing a stored procedure in Oracle, I chose a particularly descriptive name, and when attempting to update the script I was informed the name was too long.
37 15 PLS-00114: identifier 'blah_blah_blah_blah_blah_blah' too long
为什么对存储的过程名称有如此严格的限制?这是特定于Oracle还是在其他数据库系统中常见?
Why is there such a restrictive limit on stored proc names? Is this just specific to Oracle or is this common in other db systems?
很抱歉重复
推荐答案
实际上只有Oracle 30个字符.
its actually 30 characters only in Oracle.
定义语言时,每种语言/数据库都有长度限制,因为在DB中创建的每个对象的名称都存储在系统表中,并且每一列都有固定的长度.
Every language/db has limit of length while defining names because the name of every object created in DB is stored in system tables and every column has some fixed length.
为了提高性能,在使用DB的情况下,我们使用简短的名称.
For performance, we keep the names short in case of DB.
这篇关于为什么存储过程名称有最大长度?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!