oracle语法和数据对象123（国外英文资料）.docVIP

oracle语法和数据对象123 ORACLE commonly used SQL syntax and data objects I. data control statement (DML) section 1.INSERT (records inserted into data tables) INSERT INTO table name (field name 1, field name 2, VALUES (value 1, value 2), ); INSERT INTO table name (field name 1, field name 2, ) SELECT field name 1, field name 2, FROM another table name; Field values for string types must be enclosed in single quotes, such as GOOD DAY If the field value contains a single quotation mark to string conversion, we replace it with two single quotes. The field value of a string type will go wrong beyond the length of the definition. It is better to perform a length check before inserting Field values for date fields can be accurate to seconds by system time SYSDATE of the current database Or converts a string into a date type function TO_DATE (` 2001-08-01 , YYYY-MM-DD ) TO_DATE () also has many date formats, see Oracle DOC. Year month month day hour: minute: seconds format YYYY-MM-DD HH24:MI:SS INSERT, the maximum operable string length is less than or equal to 4000 single bytes. If you want to insert a longer string, consider the field using the CLOB type, Method borrows the DBMS_LOB package that comes with Oracle In INSERT, if you want to automatically increase the serial number from 1, you should create a serial number first The name of the CREATE SEQUENCE sequence number (preferably table name + sequence number marker), INCREMENT BY 1, START WITH 1 MAXVALUE 99999, CYCLE, NOCACHE; The maximum value is determined by the length of the field. If the automatically defined sequence number NUMBER (6) is defined, the maximum value is 999999 The INSERT statement inserts this field as the name of the serial number.NEXTVAL 2.DELETE (statement deleted from the data table) DELETE FROM table name WHERE condition; Note: deleting the record does not release the occupied chunks of the Oracle tablespace. It only labels the deleted data blocks as unused. If you really want to delete all the rec