简单实用oracle sql查询

以父子关系查询出来的集合：

select groupid,groupname,parentid,isleaf,isactual,level from teabgroup
where corporationid in (61) and statusid=2 start with parentid=0 connect by prior groupid=parentid

//获得系统时间
select Sysdate from dual

//修改数据库内存大小
select * from v$sga

alter system set db_cache_size=99999M scope=spfile;

//取得系统序列

Select tprozfbinfoid.Nextval From dual