https://qiita.com/Non-biri/items/16fe2f63a893cf579f85

Oracle Database ユーザー作成方法 (11g,12c,18c,19c)
参考ページ

https://dekiruengineer.com/engineer/create_users_in_the_oracle_database/

Oracleにユーザーを追加しテーブルを作成してみた
参考ページ

Oracleにユーザーを追加しテーブルを作成してみた

演習

１）TableSpaceの作成
    新しい　DBFを作る形
    auto extend は　On

2)ユーザーの作成
    上記１で作成した　TableSpaceをデフォルトとする。

３）TNSNames　の更新

４）新しいユーザーでPDBに接続

５）表：ｅｍｐｌｏｙｅｅの作成

６）ｅｍｐｌｏｙｅｅにデータＩｎｓｅｒｔ

回答事例

CREATE TABLESPACE userwork
DATAFILE ‘C:\app\fjbit\product\21c\oradata\XE\XEPDB1\userwork.dbf’
SIZE 100M AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED;

CREATE USER its
IDENTIFIED BY orcl
DEFAULT TABLESPACE userwork
TEMPORARY TABLESPACE TEMP;

権限付与
GRANT CONNECT TO its;
GRANT RESOURCE TO its;
GRANT UNLIMITED TABLESPACE TO its;

C:\app\fjbit\product\21c\homes\OraDB21Home1\network\admin\tnsnames.ora
編集

XEPDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = g701)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)

tnsnames.ora Network Configuration File: C:\app\fjbit\product\21c\homes\OraDB21Home1\NETWORK\ADMIN\tnsnames.ora

Generated by Oracle configuration tools.

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = g701)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

XEPDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = g701)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)

LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = g701)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

SQLDeveloperでの接続

コマンド（ＳＱＬＰｌｕｓでの接続）

Oracle　Create　Table

https://sql-oracle.com/?p=1694

DROP TABLE 参考URL

https://docs.oracle.com/cd/E16338_01/server.112/b56299/statements_9003.htm

DROP TABLE employee CASCADE CONSTRAINTS PURGE;

CREATE TABLE employee (
e_id char(7),
name varchar(20) ,
name_kana varchar(100) ,
gender smallint ,
birth date ,
depart_id char(4) ,
position varchar(20) ,
b_id char(7) ,
last_update date ,
retired smallint ,
CONSTRAINT pk_emp PRIMARY KEY (e_id)
);

複数行Insert　Oracleとそれ以外

https://qiita.com/ryhoh/items/c460347d8b2d133ab247

MySQL CSV Export

MySQLでSELECTしたデータをCSVファイルに出力してみよう！【MAC環境】

MySQL　Workbench

Install

https://www.mysql.com/jp/products/workbench/

CSV Export

https://dabohaze.site/mysql-workbench-csv-export-import/

Oracle SQL Loader

https://products.sint.co.jp/siob/blog/what-is-sql-loader