# 示例：检查Oracle 21c版本
SQL> SELECT * FROM v$version;

BANNER CON_ID
——————————————————————————– ———-
Oracle Database 21c Enterprise Edition Release 21.3.0.0.0 – Production 0
PL/SQL Release 21.3.0.0.0 – Production 0
CORE 21.3.0.0.0 Production 0
TNS for Linux: Version 21.3.0.0.0 – Production 0
NLSRTL Version 21.3.0.0.0 – Production 0

# 示例：使用多模型支持
— 创建图数据库
SQL> CREATE PROPERTY GRAPH social_network;

Property graph created.

— 创建JSON表
SQL> CREATE TABLE customers (
id NUMBER PRIMARY KEY,
info JSON
);

Table created.

— 插入JSON数据
SQL> INSERT INTO customers VALUES (
1,
‘{“name”: “John Doe”, “email”: “john.doe@fgedu.net.cn”, “address”: {“street”: “123 Main St”, “city”: “New York”}}’
);

1 row created.

— 查询JSON数据
SQL> SELECT info->>’$.name’ AS name, info->>’$.email’ AS email
FROM customers;

NAME EMAIL
———- ——————–
John Doe john.doe@fgedu.net.cn

# 示例：检查Oracle 23c版本
SQL> SELECT * FROM v$version;

BANNER CON_ID
——————————————————————————– ———-
Oracle Database 23c Enterprise Edition Release 23.3.0.0.0 – Production 0
PL/SQL Release 23.3.0.0.0 – Production 0
CORE 23.3.0.0.0 Production 0
TNS for Linux: Version 23.3.0.0.0 – Production 0
NLSRTL Version 23.3.0.0.0 – Production 0

# 示例：使用JSON关系双模式
— 创建包含JSON的表
SQL> CREATE TABLE products (
id NUMBER PRIMARY KEY,
name VARCHAR2(100),
details JSON
);

Table created.

— 插入数据
SQL> INSERT INTO products VALUES (
1,
‘Laptop’,
‘{“brand”: “Oracle”, “specs”: {“cpu”: “Intel i7”, “memory”: “16GB”, “storage”: “512GB SSD”}}’
);

1 row created.

— 查询数据
SQL> SELECT id, name, details->>’$.brand’ AS brand, details->>’$.specs.cpu’ AS cpu
FROM products;

ID NAME BRAND CPU
— ——- ——– ——–
1 Laptop Oracle Intel i7

— 创建JSON索引
SQL> CREATE INDEX products_details_idx ON products(details) INDEXTYPE IS CTXSYS.CONTEXT;

Index created.

# 示例：使用Data Pump迁移到Oracle 23c
— 导出
$ expdp system/password@old_db full=y directory=DATA_PUMP_DIR dumpfile=full.dmp logfile=expdp.log

— 导入到CDB
$ impdp system/password@cdb1 full=y directory=DATA_PUMP_DIR dumpfile=full.dmp logfile=impdp.log

— 导入到PDB
$ impdp system/password@cdb1/pdb1 full=y directory=DATA_PUMP_DIR dumpfile=full.dmp logfile=impdp.log

# 迁移后检查
SQL> SELECT * FROM v$version;
SQL> SELECT name, open_mode FROM v$pdbs;
SQL> SELECT count(*) FROM user_tables;