Table Design avoid using Reserved Words

Table Design avoids the use of reserved Words in the v $ reserved_words record keywords and reserved words. The reserved field content is Y, indicating that the reserved word is used in the identifier. If the reserved keyword is N, it may also trigger Oracle bugs, so avoiding the use is the best choice. Here is an experiment. An error will be reported during creation. To create a project successfully, double quotation marks must be added.

SQL> select * from v $ reserved_words wherekeyword = 'SIZE '; keyword length reserved RES_TYPE RES_ATTR RES_SEMI DUPLICATE -------- ------------------ -------- ---------- SIZE 4 y n nsql> createtable test (id number, size number); create tabletest (id number, size number) * row 1st error: ORA-00904: identifier invalid SQL> createtable test (id number, "size" number); table created. SQL> insertinto test values (); 1 row has been created. SQL> commit; submitted completely. SQL> select * from test; ID size ------------------ 1 1SQL> selectsize from test; select size fromtest * row 1st error: ORA-00936: Missing expression SQL> select "size" from test; size ---------- 1