![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
cione508
这个作者很懒,什么都没留下…
展开
-
查找数据库对象
SELECT * FROM USER_TABLES; --查看当前用户下的表 SELECT * FROM DBA_TABLES; --查看数据库中所有的表 SELECT CREATED,LAST_DDL_TIME from user_objects where object_name=upper('表名');原创 2021-10-28 09:55:39 · 696 阅读 · 0 评论 -
SQL With AS 用法
with a as (select * from table) 对于复杂的SQL查询,可以通过临时表的方式 多表时 with a as (select * from table1 ), b as (select * from table1) ... select * from a,b,... where a. = b.原创 2021-03-03 21:02:10 · 442 阅读 · 1 评论