![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
fly一样的感觉
乐观开朗
展开
-
PL/SQL Developer连接远程数据库
PL/SQL Developer 登录时没有可选数据库和连接不上问题 https://www.cnblogs.com/nsw2018/p/9837611.html原创 2021-07-20 10:30:30 · 139 阅读 · 0 评论 -
Oracle表的导入及表空间的创建
创建新用户: SQL> create user [username] identified by [password]; User created. 授权: SQL> grant connect,resource,DBA TO [username]; Grant succeeded. 登录新账号: SQL> connect [username]@orcl 输入口令: 已连接。 ...原创 2021-07-05 14:10:21 · 143 阅读 · 0 评论 -
反向递归SQL
select * from prep_sffpremage_menus where id in( select id from prep_sffpremage_menus start with id in (49,41) connect by prior parentid = id group by id )原创 2020-12-10 18:58:00 · 229 阅读 · 0 评论