?
Solved

Maximum number of characters table?

Posted on 2006-05-17
1
Medium Priority
?
1,030 Views
Last Modified: 2008-02-01
What is the maximum number of characters allowed in a table alias in Oracle version 9i?

Thanks.
0
Comment
Question by:mohammadzahid
1 Comment
 
LVL 3

Accepted Solution

by:
JacekMycha earned 200 total points
ID: 16707385
All object names can be up to 30 characters long. Both tables and synonyms.

You can have table name prefixed by schema owner. You can have case-sensitive table names (but I don't recommend this).

Regards,
JacekMycha
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question