L_zsen的博客

1、下载oracle镜像docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g 2、启动镜像docker run -d -p 1521:1521 --name oracle_11g --restart=always registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g3、启动oracle服务docker start oracle_11g4、进入容器内部、设置orac

oracle中可以使用start with connect by 查询树形集合,用来查询层级关系很是好用--当模糊查询出来的结果父级重复时可以去重即可--查询父级（包含自己）SELECT DISTINCT ID,PID,NAME FROM TABLE_NAME A START WITH EXISTS ( SELECT ID FROM VIEW_DEPT WHERE NAME_TYPE =...