Oracleでスキーマ(schema)の使い方

2016年9月2日

操作コマンド
SQL> Gruant dba to scott
SQL> create tablekoyolist(name char(15));
Table created.

SQL> create table system.user_infotbl(name char(15));
Table created.

SQL> insert intokoyolist values('scott’);
1 row created.

SQL> insert into system.user_infotbl values('system’);
1 row created.

SQL> commit;
Commit complete.

SQL> conn system/manager
Connected.

SQL> select * fromkoyolist;
NAME
———-
system

SQL> ALTER SESSION SET CURRENT_SCHEMA = scott;
Session altered.

SQL> select * fromkoyolist;
NAME
———-
scott

SQL> select owner ,table_name from dba_tables where table_name=upper('user_infotbl’);
OWNER TABLE_NAME
—————————— ——————————
SCOTTkoyolist
SYSTEMkoyolist