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;

Follow me!