Re: Max length name of a database/schema

From: HansF <news.hans_at_telus.net>
Date: Fri, 29 Oct 2004 14:40:44 GMT
Message-ID: <MDsgd.39333$9b.32555@edtnps84>

Fred BROUARD - SQLpro wrote:

>
>
> Did you know what is the maximum character length for a name of a database
> or schema ?
>

Yes.

<answering the implied question as well> All identifiers in Oracle are 30 characters. I note you have SQL Server background - one common trap for those wiith your background: [per standard?] Oracle upper cases all unquoted identifiers. Once you start using quoted identifiers you need to use the double-quotes for ever. </answer>

BTW, that info is found in the SQL Language refece manual at http://docs.oracle.com

/Hans Received on Fri Oct 29 2004 - 09:40:44 CDT