!!!Oracle SQL Tips
[Oracle]{{category SQL}}

::SYSDBA権限を付与
 grant sysdba to system
::テーブル作成
 create table users (
   user_id char(4),
   name varchar2(20)
 )
 /
 alter table users
   add constraint users_pk01 primary key(user_id)
 /

::参照制約の作成
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19201-02/statements_3.html#13646
*作成
 alter table admin_users
    add constraint admin_users_ref01 foreign key(user_id) references users(user_id)
*削除
 alter table admin_users drop constraint admin_users_ref01 

::ON DELETE CASCADE
referencesに指定する
 alter table browse_node
	add constraint browse_node_ref01 foreign key(parent_id) references browse_node(node_id) on delete cascade

*複数の列に参照をはる
 alter table table01 add constraint table01_ref01 foreign key(field01,field02) references table02(field01,field02) on delete cascade

::テーブルの削除
制約のカスケード削除、パージオプション
 drop table users cascade constraint purge

----
{{include_html banner_html, "!Oracle"}}