YeiZea

¿Wikileaks Security? in (DATA BASE) by yei zeta

May 3rd, 2013
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. ********** THE IN YEI ZETA DAMAGE*********
  2.  
  3.  
  4. HTTP/1.0 302 Found
  5. Date: Sat, 27 Apr 2013 05:04:27 GMT
  6. Server: LiteSpeed
  7. Connection: close
  8. X-Powered-By: PHP/5.3.10
  9. Set-Cookie: PHPSESSID=52d482bfa9a15901a1838976e0a3acce; path=/
  10. Expires: Thu, 19 Nov 1981 08:52:00 GMT
  11. Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
  12. Pragma: no-cache
  13. location: http://www.wikileaks.org/
  14. Content-Type: text/html
  15. Content-Length: 0
  16.  
  17. AUDIT SELECT, INSERT, DELETE
  18. ON emp
  19. BY ACCESS
  20. WHENEVER SUCCESSFUL;
  21. SELECT * FROM DBA_OBJ_AUDIT_OPTS
  22. WHERE OWNER = 'SCOTT' AND OBJECT_NAME LIKE 'emp%';
  23.  
  24. SELECT * FROM DBA_AUDIT_OBJECT;
  25.  
  26. SELECT USERNAME, LOGOFF_TIME, LOGOFF_LREAD, LOGOFF_PREAD,
  27. LOGOFF_LWRITE, LOGOFF_DLOCK
  28. FROM DBA_AUDIT_SESSION;
  29.  
  30.  
  31.  
  32. SELECT * FROM dba_fga_audit_trail;
  33.  
  34. --1
  35. select ename,substr(ename,-3) "Last Three chars" from emp;
  36. --2
  37. select ename,substr(ename,1,1) ||'A'||substr(ename,3,length(ename)) "Second Char Replaced With 'A' " from emp;
  38. --3
  39. select ename,substr(ename,-1)||substr(ename,2,length(ename)-2)||substr(ename,1,1) "Last Char Replaced With First" from emp;
  40. --4
  41. select ename,sal,hiredate,to_char(hiredate,'day') "Hire Day" from emp order by to_char(hiredate+4,'d');
  42. --5
  43. select sal,count(sal) from emp group by sal having count(sal) >1 ;
  44. --6
  45. select to_char(hiredate,'yyyy') "Hire Year", count(empno) "Emp Count" from emp group by to_char(hiredate,'yyyy')
  46. order by to_char(hiredate,'yyyy');
  47. --7
  48. select rownum, ename, sal
  49. from (select ename,empno,sal from emp order by sal desc)
  50. where rownum < 4;
  51.  
  52. SELECT ename, sal
  53. FROM emp e1
  54. WHERE 3 > (SELECT COUNT(DISTINCT sal)
  55. FROM emp e2
  56. WHERE e1.sal <= e2.sal)
  57. ORDER BY sal DESC;
  58.  
  59. SELECT ename, sal
  60. FROM ( SELECT ename, sal, RANK() OVER (ORDER BY sal DESC) sal_rank
  61. FROM emp )
  62. WHERE sal_rank <= 3;
  63. --8
  64. select dname,loc,avg(nvl(sal,0)) "Avrage Salary"
  65. from dept d left outer join emp e on (e.deptno = d.deptno)
  66. group by dname,loc order by avg(nvl(sal,0)) desc;
  67. --9
  68. update emp
  69. set sal = ( select avg(nvl(sal,0))
  70. from emp e where e.deptno = emp.deptno );
  71. rollback;
Advertisement
Add Comment
Please, Sign In to add comment