合 在Docker中快速体验Oracle 23c免费开发者版
docker环境下载
1 2 3 4 5 6 7 8 | docker rm -f lhroel87 docker run -itd --name lhroel87 -h lhroel87 \ -p 1521:1521 -p 38389:3389 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/oracle23cfree:1.0 \ /usr/sbin/init docker exec -it lhroel87 bash |
启动数据库和监听
1 2 | /etc/init.d/oracle-free-23c status /etc/init.d/oracle-free-23c start |
示例:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | [root@lhroel87 /]# /etc/init.d/oracle-free-23c status Status of the Oracle FREE 23c service: LISTENER status: STOPPED FREE Database status: STOPPED [root@lhroel87 /]# /etc/init.d/oracle-free-23c start Starting Oracle Net Listener. Oracle Net Listener started. Starting Oracle Database instance FREE. Oracle Database instance FREE started. [root@lhroel87 /]# /etc/init.d/oracle-free-23c status Status of the Oracle FREE 23c service: LISTENER status: RUNNING FREE Database status: RUNNING [root@lhroel87 /]# su - oracle Last login: Fri Apr 7 03:04:15 UTC 2023 on pts/1 [oracle@lhroel87 ~]$ |
测试新特性
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | [oracle@lhroel87 ~]$ sas SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Fri Apr 7 02:45:24 2023 Version 23.2.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected to: Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release Version 23.2.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FREEPDB1 READ WRITE NO |
(1) 不带FROM子句的SELECT查询
在Oracle 23c中,第一次实现了不带From子句的查询,也不需要dual,就是跟SQL Server,MySQL一样了
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | SQL> select 1; 1 ---------- 1 SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; Session altered. SQL> SELECT SYSDATE; SYSDATE ------------------- 2023-04-07 03:05:51 SQL> |
(2) 单表支持4096列
Oracle 此前版本单表支持1000列。