--创建表空间createtablespace textdatafile'F:/db/ordata/hibernate/text.dbf'size10mAUTOEXTENDONNEXT10M MAXSIZEUNLIMITEDLOGGINGEXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO;--创建用户createuser textidentifiedby textdefaulttablespace text--为用户分配权限grantconnect,resource,dbato text;--用户登录表的结构createtable street(idNUMBER(5) primarykeynotnull, p_id NUMBER(5),nameVARCHAR2(18) notnull,constraint s_fk_p_id foreignkey (p_id) references district(id));--创建表createtable district(idNUMBER(5) primarykeynotnull, nameVARCHAR2(18) notnull);--创建序列createsequence seq_streetstartwith1incrementby1nomaxvaluecache10;createsequence seq_districtstartwith1incrementby1nomaxvaluecache10;droptable street;droptable district;delete district;delete street;select * from street;select * from district;delete district whereid != 6;--PL/SQL--插入数据DECLARE v_id NUMBER(5) := 7; v_name VARCHAR2(18) := '汉阳区';BEGINinsertinto district values(v_id,v_name);EXCEPTIONWhenothersthen DBMS_OUTPUT.PUT_LINE('插入数据失败');END;--IF-THEN语句DECLARE num1 number := 5; num2 number := 1; num3 number := 3;resultvarchar2(20);BEGINIF num1 > num2 THENresult := 'num1 is big';ELSIF num1 < num2 THENresult := 'num3 is big';ELSEresult := 'num2';ENDIF; DBMS_OUTPUT.PUT_LINE(result);END;--CASE 语句DECLARE chap char := 'c';resultvarchar2(20);BEGINCASE chapWHEN'A'THENresult := 'is A';WHEN'B'THENresult := 'is B';ELSEresult := 'Ok!';ENDCASE; DBMS_OUTPUT.put_line(RESULT);END;--LOOP循环DECLARE num4 number := 0;BEGINLOOP num4 := num4+1;IF num4 > 10THENEXIT;ENDIF; DBMS_OUTPUT.PUT_LINE(num4);ENDLOOP; END;--WHILE LOOP循环DECLARE num5 number := 1;BEGINWHILE num5 < 5LOOP num5 := num5 + 1; DBMS_OUTPUT.PUT_LINE(num5);ENDLOOP;END;--FOR LOOP循环DECLARE num6 number := 1;BEGINFOR i IN1..10 LOOP num6 := num6+i;ENDLOOP; DBMS_OUTPUT.PUT_LINE(num6);END;--动态SQL，执行DDLBEGINEXECUTEIMMEDIATE'create ta...
