Do not use special characters such as ( ) - & @ * $ | % ~ except for underscore (_). Also do not use Oracle SQL or PL/SQL reserved words, especially in the Oracle name. For the latest information on reserved words, you can generate a list of all keywords and reserved words with the V$RESERVED_WORDS view described in the Oracle® Database Reference.
See Also
All You Need to Know About SQL Data TypesSQL Data Typesdate (Transact-SQL) - SQL ServerCHAR vs VARCHAR in SQL - GeeksforGeeksNote:
- The system uses the value you enter in the Name field as the default Oracle name.
- DUPLICATE is a reserved word in DMW for columns. It is used in the Default Listings page to allow filtering on duplicate records.
See Also
The Big Data Guide