Oracle DatabaseExpress
讎りヲ
Oracle遉セ縺碁幕逋コ繝サ雋ゥ螢イ縺励※縺繧騎DBMS
騾溘&縲∫「コ螳滓ァ縲∽ソ晄戟縺ァ縺阪k繝繝シ繧ソ驥上↓蜆ェ繧後※縺繧九
縲薫racleDatabaseExpress11g縲阪r蜈ャ蠑上し繧、繝縺九i繝繧ヲ繝ウ繝ュ繝シ繝(辟。譁)
窶サ繝ヲ繝シ繧カ繝シ逋サ骭イ縺悟ソ隕
謗・邯
SQL*Plus縺九i
縲SQL*Plus 謗・邯縲榊盾辣ァ
SQL Developer縺九i
CONNECT 繝ヲ繝シ繧カ繝シ蜷/繝代せ繝ッ繝シ繝
SQL*Plus縺ィ縺ッシ
縲SQL*Plus縲榊盾辣ァ
陦ィ鬆伜沺菴懈
SQL> CREATE TABLESPACE MY_DATA
2> DATAFILE 'C:\oraclexe\data\MY_DATA.dbf' SIZE 200M
3> SEGMENT SPACE MANAGEMENT AUTO;
陦ィ鬆伜沺縺御ス懈舌&繧後∪縺励◆縲
繝ヲ繝シ繧カ繝シ菴懈
SQL> CREATE USER testuser
2 IDENTIFIED BY testpass
3 DEFAULT TABLESPACE MY_DATA;
繝ヲ繝シ繧カ繝シ縺御ス懈舌&繧後∪縺励◆縲
讓ゥ髯蝉サ倅ク
SQL> GRANT connect,dba TO testuser;
讓ゥ髯蝉サ倅ク弱′謌仙粥縺励∪縺励◆
陦ィ菴懈
SQL> CREATE TABLE MYTABLE
2 (
3 ID NUMBER,
4 NAME VARCHAR(100),
5 PRIMARY KEY(ID)
6 );
陦ィ縺御ス懈舌&繧後∪縺励◆縲
繝繝シ繧ソ謖ソ蜈・
SQL> INSERT INTO MYTABLE(ID,NAME) VALUES(1,’TEST’);
1陦後′菴懈舌&繧後∪縺励◆縲
繧ウ繝溘ャ繝
SQL>COMMIT;