Oracle DBA Tutorial
Members Login
Username
Password
Login
Remember Me
New Member
Lost Account Info?
Home
List All Users
Search
Search
Advanced Search
User Details
Calendar
My ActiveBoard
->
SQL Tutorial
->
What is a Schema Object and its rules?
Start A New Topic
Reply
Post Info
TOPIC: What is a Schema Object and its rules?
Anonymous
Date:
Aug 5, 2009
What is a Schema Object and its rules?
Permalink
Reply
Quote
Schema Object Naming Rules
The following rules apply when naming schema objects:
Names must be from 1 to 30 bytes long with these exceptions:
Names of databases are limited to 8 bytes.
Names of database links can be as long as 128 bytes.
Names cannot contain quotation marks.
Names are not case sensitive.
A name must begin with an alphabetic character from your database character set unless surrounded by double quotation marks.
All the rules can be read at http://oracleonline.info/schema_objects.html
__________________
Page 1 of 1
sorted by
Oldest First
Newest First
SQL Tutorial
Quick Reply
Please log in to post quick replies.
My ActiveBoard
->
SQL Tutorial
->
What is a Schema Object and its rules?
Subscribe
Jump To:
--- Oracle DBA ---
All About Oracle
Backup and Recovery Concepts
Oracle DBA
Advanced Queuing
Oracle 11g New Features
SQL Interview Questions
PL/SQL Interview Questions
Sql Statement Tuning
Oracle 10g New Features
Oracle Data Guard
Oracle DBA Interview Questions
SQL Tutorial
Oracle Certification
Oracle Jobs
Create your own FREE Forum
Report Abuse