Using keywords as field names in Oracle

When using P/l SQL to create a table, if the keyword is used as the field name, such as uid, type, date, etc., an invalid identifier (invalid identifier) is prompted ). In some cases, you have to use keywords as field names, just like what to do when you change from other databases to Oracle during system upgrades. It has been verified that the solution is to use double quotation marks (""), such as "type", and insert and other statements as well.

Create table Test_Tab

(

Id number,

"Uid" number,

"Type" number

 

);