查看表创建时间
select ao.*
from ALL_OBJECTS ao
where OBJECT_NAME = 'MODULE'
and OBJECT_TyPE = 'TABLE';
select * from user_tables;
select username,count(username) from v$session where username is not null group by username ;
/**
*递归查询
*表结构,ID,name,url,parentid,remark,
*/
select a.*,level from module a
start with id in('2c9081f7223e302b01223e302bb30000') --树顶级节点
connect by prior id=parentid --prior 是递归必要关键字,如果没有prior 则只查询一级不会递归查下去
:start with ...connect by 的用法, start with 后面所跟的就是就是递归的种子。
递归的种子也就是递归开始的地方 connect by 后面的"prior" 如果缺省:则只能查询到符合条件的起始行,并不进行递归查询;
connect by prior 后面所放的字段是有关系的,它指明了查询的方向
select ao.*
from ALL_OBJECTS ao
where OBJECT_NAME = 'MODULE'
and OBJECT_TyPE = 'TABLE';
select * from user_tables;
select username,count(username) from v$session where username is not null group by username ;
/**
*递归查询
*表结构,ID,name,url,parentid,remark,
*/
select a.*,level from module a
start with id in('2c9081f7223e302b01223e302bb30000') --树顶级节点
connect by prior id=parentid --prior 是递归必要关键字,如果没有prior 则只查询一级不会递归查下去
:start with ...connect by 的用法, start with 后面所跟的就是就是递归的种子。
递归的种子也就是递归开始的地方 connect by 后面的"prior" 如果缺省:则只能查询到符合条件的起始行,并不进行递归查询;
connect by prior 后面所放的字段是有关系的,它指明了查询的方向