Table and field names in Oracle SQL?

Question

Oracle

How it is accepted to write names of tables and fields in oracle? Small C using underscore or PascalCase?

Answer 1

Tables and fields in ORACLE can be accessed using any case. For example expressions

select mycol from my_table;
select MYCOL from MY_TABLE;
select Mycol from My_table;

Completely equivalent. But only on condition that the table and fields were specified without quotes during creation.
In other words create table my_table (mycol char(10));, good, but create table "My_Table" ("Mycol" char(10));- bad, it's better not to do it.

Answer 2

SQL style guide