摘要：从Oracle 9i Release2开始，你就可以在insert和update语句中使用记录了。比如下面的代码例子：CREATE OR REPLACE PROCEDURE SET_BOOK_INFO ( BOOK_IN IN BOOKS%ROWTYPE ) IS BEGIN INSERT INTO BOOKS VALUES BOOK_IN ; EXCEPTION WHEN DUP_VAL_ON_INDEX THEN UPDATE BOOKS SET ROW = BOOK_IN WHERE ISBN = BOOK_IN.ISBN ; ... 阅读全文

摘要：创建临时表空间: create temporary tablespace test_temp tempfile 'D:\app\Administrator\product\11.2.0\dbhome_1\oradata\test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; 创建数据表空间:create tablespace test_data logging datafile 'D:\app\Administrator\product\11.2.0\ 阅读全文