Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ********** THE IN YEI ZETA DAMAGE*********
- HTTP/1.0 302 Found
- Date: Sat, 27 Apr 2013 05:04:27 GMT
- Server: LiteSpeed
- Connection: close
- X-Powered-By: PHP/5.3.10
- Set-Cookie: PHPSESSID=52d482bfa9a15901a1838976e0a3acce; path=/
- Expires: Thu, 19 Nov 1981 08:52:00 GMT
- Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
- Pragma: no-cache
- location: http://www.wikileaks.org/
- Content-Type: text/html
- Content-Length: 0
- AUDIT SELECT, INSERT, DELETE
- ON emp
- BY ACCESS
- WHENEVER SUCCESSFUL;
- SELECT * FROM DBA_OBJ_AUDIT_OPTS
- WHERE OWNER = 'SCOTT' AND OBJECT_NAME LIKE 'emp%';
- SELECT * FROM DBA_AUDIT_OBJECT;
- SELECT USERNAME, LOGOFF_TIME, LOGOFF_LREAD, LOGOFF_PREAD,
- LOGOFF_LWRITE, LOGOFF_DLOCK
- FROM DBA_AUDIT_SESSION;
- SELECT * FROM dba_fga_audit_trail;
- --1
- select ename,substr(ename,-3) "Last Three chars" from emp;
- --2
- select ename,substr(ename,1,1) ||'A'||substr(ename,3,length(ename)) "Second Char Replaced With 'A' " from emp;
- --3
- select ename,substr(ename,-1)||substr(ename,2,length(ename)-2)||substr(ename,1,1) "Last Char Replaced With First" from emp;
- --4
- select ename,sal,hiredate,to_char(hiredate,'day') "Hire Day" from emp order by to_char(hiredate+4,'d');
- --5
- select sal,count(sal) from emp group by sal having count(sal) >1 ;
- --6
- select to_char(hiredate,'yyyy') "Hire Year", count(empno) "Emp Count" from emp group by to_char(hiredate,'yyyy')
- order by to_char(hiredate,'yyyy');
- --7
- select rownum, ename, sal
- from (select ename,empno,sal from emp order by sal desc)
- where rownum < 4;
- SELECT ename, sal
- FROM emp e1
- WHERE 3 > (SELECT COUNT(DISTINCT sal)
- FROM emp e2
- WHERE e1.sal <= e2.sal)
- ORDER BY sal DESC;
- SELECT ename, sal
- FROM ( SELECT ename, sal, RANK() OVER (ORDER BY sal DESC) sal_rank
- FROM emp )
- WHERE sal_rank <= 3;
- --8
- select dname,loc,avg(nvl(sal,0)) "Avrage Salary"
- from dept d left outer join emp e on (e.deptno = d.deptno)
- group by dname,loc order by avg(nvl(sal,0)) desc;
- --9
- update emp
- set sal = ( select avg(nvl(sal,0))
- from emp e where e.deptno = emp.deptno );
- rollback;
Advertisement
Add Comment
Please, Sign In to add comment