sql
来源：互联网 发布：大数据金融公司 编辑：程序博客网 时间：2024/06/02 04:14
--select * from dba_segments order by BLOCKs desc
--select count(*) from dba_segments
--select * from dba_segments where owner='SCOTT' ORDER BY SEGMENT_TYPE
--SELECT * FROM SCOTT.EMP
--SELECT E.ENAME||' S MANAGER IS '||M.ENAME FROM SCOTT.EMP E,SCOTT.EMP M where m.empno=e.mgr;
SELECT * FROM SCOTT.EMP;
