Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

WHAT ARE RULES FOR NAMING A TABLE OR COLUMN?

April 26, 2017column naming rules Table

0

Posted

WHAT ARE RULES FOR NAMING A TABLE OR COLUMN?

1 Answer

0

Posted

Ans: 1) Names must be from 1 to 30 bytes long. 2) Names cannot contain quotation marks. 3) Names are not case sensitive. 4) A name must begin with an alphabetic character from your database character set and the characters $ and #. But these characters are discouraged. 5) A name cannot be ORACLE reserved word. 6) A name must be unique across its namespace. Objects in the name space must have different names. 7) A name can be enclosed in double quotes.