oracle數(shù)據(jù)庫設(shè)計(jì)規(guī)范(參考版)
2024-08-15 18:29本頁面
【正文】 INTEGER DECIMAL4 Oracle保留字和關(guān)鍵字ACCESS DECIMAL INITIAL ON STARTADD NOT INSERT ONLINE SUCCESSFULALL DEFAULT INTEGER OPTION SYNONYMALTER DELETE INTERSECT OR SYSDATEAND DESC INTO ORDER TABLEANY DISTINCT IS PCTFREE THENAS DROP LEVEL PRIOR TOASC ELSE LIKE PRIVILEGES TRIGGERAUDIT EXCLUSIVE LOCK PUBLIC UIDBETWEEN EXISTS LONG RAW UNIONBY FILE MAXEXTENTS RENAME UNIQUEFROM FLOAT MINUS RESOURCE UPDATECHAR FOR MLSLABEL REVOKE USERCHECK SHARE MODE ROW VALIDATECLUSTER GRANT MODIFY ROWID VALUESCOLUMN GROUP NOAUDIT ROWNUM VARCHARCOMMENT HAVING NOCOMPRESS ROWS VARCHAR2COMPRESS IDENTIFIED NOWAIT SELECT VIEWCONNECT IMMEDIATE NULL SESSION WHENEVERCREATE IN NUMBER SET WHERECURRENT INCREMENT OF SIZE WITHDATE INDEX OFFLINE SMALLINT1. 刪除記錄時(shí)，必須有Where唯一條件2. 當(dāng)有主從表時(shí)，要先刪除從表記錄，在刪除主表記錄 id’s type is number1. 避免使用數(shù)據(jù)庫的類型自動(dòng)轉(zhuǎn)換功能：錯(cuò)誤：SELECT category_id, category_name FROM categoryWHERE category_id = ‘123’。= TO_DATE(‘200
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號(hào)-1