API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 15th, 2019
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 12.87 KB | None | 0 0
raw download clone embed print report
  1. 21-DEC-18   15:43:04    IP: 89.188.33.31    LOGOUT
  2. 21-DEC-18   15:42:25    SELECT id_zaposlenog, ime, prezime FROM milosb.radnici_t3 WHERE id_rukovodioca IN (SELECT ID FROM (SELECT a.id_zaposlenog ID,COUNT(*) FROM milosb.radnici_t3 a, milosb.radnici_t3 b WHERE b.id_rukovodioca=a.id_zaposlenog GROUP BY a.id_zaposlenog HAVING COUNT(*)=1)) ORDER BY id_zaposlenog DESC     OK
  3. 21-DEC-18   15:41:29    SELECT * FROM milosb.radnici_t3     OK
  4. 21-DEC-18   15:41:12    IP: 89.188.33.31    LOGIN
  5. 21-DEC-18   15:40:16    SELECT a.id_zaposlenog,COUNT(*) FROM milosb.radnici_t3 a, milosb.radnici_t3 b WHERE b.id_rukovodioca=a.id_zaposlenog GROUP BY a.id_zaposlenog HAVING COUNT(*)=1     OK
  6. 21-DEC-18   15:40:06    SELECT e1.id_zaposlenog,COUNT(*) FROM milosb.radnici_t3 a, milosb.radnici_t3 b WHERE b.id_rukovodioca=a.id_zaposlenog GROUP BY e1.id_zaposlenog HAVING COUNT(*)=1   X
  7. 21-DEC-18   15:38:29    SELECT * FROM milosb.radnici_t3     OK
  8. 21-DEC-18   15:37:34    SELECT department_name, COUNT(*) br FROM hr.employees e, hr.departments d WHERE e.department_id=d.department_id AND e.employee_id IN (SELECT e FROM (SELECT e1.employee_id e, COUNT(*) c FROM hr.employees e1, hr.employees e2 WHERE e2.manager_id=e1.employee_id GROUP BY e1.employee_id HAVING COUNT(*)>=2)) GROUP BY department_name ORDER BY br DESC    OK
  9. 21-DEC-18   15:36:47    SELECT e1.employee_id e, COUNT(*) c FROM hr.employees e1, hr.employees e2 WHERE e2.manager_id=e1.employee_id GROUP BY e1.employee_id HAVING COUNT(*)>=2     OK
  10. 21-DEC-18   15:36:40    SELECT e1.employee_id e, COUNT(*) c FROM hr.employees e1, hr.employees e2 WHERE e2.manager_id=e1.employee_id GROUP BY e1.employee_id HAVING COUNT(*)>2  OK
  11. 21-DEC-18   15:36:26    SELECT e1.employee_id e, COUNT(*) c FROM hr.employees e1, hr.employees e2 WHERE e2.manager_id=e1.employee_id GROUP BY e1.employee_id    OK
  12. 21-DEC-18   15:36:08    SELECT e1.employee_id, COUNT(*) FROM hr.employees e1, hr.employees e2 WHERE e2.manager_id=e1.employee_id GROUP BY e1.employee_id    OK
  13. 21-DEC-18   15:35:45    SELECT e1.employee_id, COUNT(*) FROM hr.employees e1, hr.employees e2 WHERE e2.manager_id=e1.employee_id GROUP BY e1.employee_id HAVING COUNT(*)>3  OK
  14. 21-DEC-18   15:35:32    SELECT e1.employee_id, COUNT(*) FROM hr.employees e1, hr.employees e2 WHERE e1.manager_id=e2.employee_id GROUP BY e1.employee_id HAVING COUNT(*)>3  OK
  15. 21-DEC-18   15:34:01    SELECT zad2f1() FROM dual   OK
  16. 21-DEC-18   15:33:57    CREATE OR REPLACE FUNCTION zad2f1 RETURN NUMBER IS PRAGMA autonomous_transaction; CURSOR c IS SELECT * FROM tabela_t4 FOR UPDATE; a NUMBER; br NUMBER:=0; BEGIN FOR ii IN c LOOP IF ABS(ii.broj-ii.broj2)>6 THEN a:=ii.broj; ii.broj:=ii.broj2; ii.broj2:=a; br:=br+1; END IF; END LOOP; COMMIT; RETURN br; END;    OK
  17. 21-DEC-18   15:33:42    SELECT zad2f1() FROM dual   X
  18. 21-DEC-18   15:33:36    CREATE OR REPLACE FUNCTION zad2f1 RETURN NUMBER IS PRAGMA autonomous_transaction; CURSOR c IS SELECT * FROM tabela_t4 FOR UPDATE; a NUMBER; br NUMBER:=0; BEGIN FOR ii IN c LOOP IF ABS(ii.broj-ii.broj2)>6 THEN a:=ii.broj; ii.broj:=ii.broj2; ii.broj2:=a; br:=br+1; END IF; END LOOP; RETURN br; END;    OK
  19. 21-DEC-18   15:33:30    CREATE OR REPLACE FUNCTION zad2f1 RETURN NUMBER IS PRAGMA autonomous_transaction CURSOR c IS SELECT * FROM tabela_t4 FOR UPDATE; a NUMBER; br NUMBER:=0; BEGIN FOR ii IN c LOOP IF ABS(ii.broj-ii.broj2)>6 THEN a:=ii.broj; ii.broj:=ii.broj2; ii.broj2:=a; br:=br+1; END IF; END LOOP; RETURN br; END;     X
  20. 21-DEC-18   15:31:47    SELECT zad2f1() FROM dual   X
  21. 21-DEC-18   15:31:29    SELECT zad2f1 FROM dual     X
  22. 21-DEC-18   15:31:09    CREATE OR REPLACE FUNCTION zad2f1 RETURN NUMBER IS CURSOR c IS SELECT * FROM tabela_t4 FOR UPDATE; a NUMBER; br NUMBER:=0; BEGIN FOR ii IN c LOOP IF ABS(ii.broj-ii.broj2)>6 THEN a:=ii.broj; ii.broj:=ii.broj2; ii.broj2:=a; br:=br+1; END IF; END LOOP; RETURN br; END;   OK
  23. 21-DEC-18   15:31:00    SELECT * FROM user_errors   OK
  24. 21-DEC-18   15:30:50    CREATE OR REPLACE FUNCTION zad2f1 RETURN NUMBER IS CURSOR c IS SELECT * FROM tabela_t4 FOR UPDATE; a NUMBER; br NUMBER:=0; BEGIN FOR ii IN c LOOP IF ABS(ii.broj-ii.broj2)>6 THEN a:=ii.broj; ii.broj:=ii.broj2; ii.broj2:=a; br=br+1; END IF; END LOOP; RETURN br; END;    X
  25. 21-DEC-18   15:25:50    SELECT * FROM tabela_t4     OK
  26. 21-DEC-18   15:24:45    SELECT e1.employee_id, COUNT(*) FROM hr.employees e1, hr.employees e2 WHERE e1.manager_id=e2.employee_id GROUP BY e1.employee_id    OK
  27. 21-DEC-18   15:24:14    SELECT e1.employee_id FROM hr.employees e1, hr.employees e2 WHERE e1.manager_id=e2.employee_id  OK
  28. 21-DEC-18   15:22:05    CREATE TABLE tabela_t4 AS SELECT * FROM milosb.tabela_t4    OK
  29. 21-DEC-18   15:21:15    BEGIN stampaj('B'); END;    OK
  30. 21-DEC-18   15:21:05    BEGIN stampaj('A'); END;    OK
  31. 21-DEC-18   15:20:45    CREATE OR REPLACE PROCEDURE stampaj(p VARCHAR2) IS a VARCHAR2(10); BEGIN IF p='A' THEN SELECT AVG(broj) INTO a FROM milosb.tabela_t4; dbms_output.put_line(a); ELSIF p='B' THEN SELECT COUNT(*) INTO a FROM milosb.tabela_t4 WHERE broj+10*broj2>broj*broj2/2; dbms_output.put_line(a); ELSE dbms_output.put_line('Andrej Jokic'); END IF; END;     OK
  32. 21-DEC-18   15:20:37    SELECT * FROM user_errors   OK
  33. 21-DEC-18   15:20:35    CREATE OR REPLACE PROCEDURE stampaj(p VARCHAR2) IS a VARCHAR2; BEGIN IF p='A' THEN SELECT AVG(broj) INTO a FROM milosb.tabela_t4; dbms_output.put_line(a); ELSIF p='B' THEN SELECT COUNT(*) INTO a FROM milosb.tabela_t4 WHERE broj+10*broj2>broj*broj2/2; dbms_output.put_line(a); ELSE dbms_output.put_line('Andrej Jokic'); END IF; END;     X
  34. 21-DEC-18   15:20:25    SELECT * FROM user_errors   OK
  35. 21-DEC-18   15:20:15    CREATE OR REPLACE PROCEDURE stampaj(p VARCHAR2) IS a VARCHAR2; BEGIN IF p='A' THEN SELECT AVG(broj) INTO a FROM milosb.tabela_t4 dbms_output.put_line(a); ELSIF p='B' THEN SELECT COUNT(*) INTO a FROM milosb.tabela_t4 WHERE broj+10*broj2>broj*broj2/2 dbms_output.put_line(a); ELSE dbms_output.put_line('Andrej Jokic'); END IF; END;   X
  36. 21-DEC-18   15:18:46    SELECT * FROM user_errors   OK
  37. 21-DEC-18   15:17:59    CREATE OR REPLACE PROCEDURE stampaj(p VARCHAR2) IS BEGIN IF p='A' THEN dbms_output.put_line(SELECT AVG(broj) FROM milosb.tabela_t4); ELSIF p='B' THEN dbms_output.put_line(SELECT COUNT(*) FROM milosb.tabela_t4 WHERE broj+10*broj2>broj*broj2/2); ELSE dbms_output.put_line('Andrej Jokic'); END IF; END;     X
  38. 21-DEC-18   15:17:43    SELECT * FROM history WHERE LOWER(komanda) LIKE '%procedure%'   OK
  39. 21-DEC-18   15:16:26    SELECT * FROM user_errors   OK
  40. 21-DEC-18   15:15:48    CREATE OR REPLACE PROCEDURE stampaj(p VARCHAR2) BEGIN IF p='A' THEN dbms_output.put_line(SELECT AVG(broj) FROM milosb.tabela_t4); ELSIF p='B' THEN dbms_output.put_line(SELECT COUNT(*) FROM milosb.tabela_t4 WHERE broj+10*broj2>broj*broj2/2); ELSE dbms_output.put_line('Andrej Jokic'); END IF; END;    X
  41. 21-DEC-18   15:10:53    SELECT department_name, COUNT(*) br FROM hr.employees e, hr.departments d WHERE e.department_id=d.department_id AND e.employee_id IN (SELECT e1.employee_id FROM hr.employees e1, hr.employees e2 WHERE e1.manager_id=e2.employee_id) GROUP BY department_name ORDER BY br DESC     OK
  42. 21-DEC-18   15:07:21    SELECT department_name, COUNT(*) br FROM hr.employees e, hr.departments d WHERE e.department_id=d.department_id GROUP BY department_name    OK
  43. 21-DEC-18   15:07:08    SELECT department_name, COUNT(*) br FROM hr.employees e, hr.departments d WHERE e.department_id=d.department_id     X
  44. 21-DEC-18   15:06:19    SELECT * FROM history WHERE LOWER(komanda) LIKE '%employees%'   OK
  45. 21-DEC-18   15:06:13    SELECT * FROM history WHERE LOWER(komanda) LIKE '%employees%'   OK
  46. 21-DEC-18   15:01:31    SELECT a.id_zaposlenog, a.ime, a.prezime FROM milosb.radnici_t3 a, milosb.radnici_t3 b WHERE a.id_rukovodioca=b.id_zaposlenog   OK
  47. 21-DEC-18   14:59:23    SELECT * FROM milosb.radnici_t3     OK
  48. 21-DEC-18   14:55:50    SELECT * FROM milosb.radnici_t3     OK
  49. 21-DEC-18   14:54:36    SELECT j.naziv, COUNT(*) br FROM jedinice j, opt o, nastavnici n, predmeti p WHERE n.nid=o.nid AND o.pid=p.pid AND n.jid=j.jid AND n.jid<>23 AND p.jid=23 GROUP BY j.naziv ORDER BY br DESC     OK
  50. 21-DEC-18   14:54:21    SELECT j.naziv, COUNT(*) br FROM jedinice j, opt o, nastavnici n, predmeti p WHERE n.nid=o.nid AND o.pid=p.pid AND n.jid=j.jid AND n.jid<>23 AND p.jid=23   X
  51. 21-DEC-18   14:49:18    SELECT * FROM jedinice  OK
  52. 21-DEC-18   14:49:13    SELECT * form jedinice  X
  53. 21-DEC-18   14:49:04    IP: 89.188.33.31    LOGIN
  54. 21-DEC-18   14:47:41    SELECT s.naziv, COUNT(*) brp FROM spr s, predmeti p, opt o, nastavnici n WHERE s.jid=p.jid AND s.sprid=p.sprid AND p.pid=o.pid AND o.nid=n.nid AND s.jid<>13 AND n.jid=13 GROUP BY s.naziv ORDER BY brp DESC    OK
  55. 21-DEC-18   14:47:31    SELECT s.naziv, COUNT(*) brp FROM spr s, predmeti p, opt o, nastavnici n WHERE s.jid=p.jid AND s.sprid=p.sprid AND p.pid=o.pid AND o.nid=n.nid AND s.jid<>13 AND n.jid=13 GROUP BY s.naziv  OK
  56. 21-DEC-18   14:47:17    SELECT s.naziv, COUNT(*) brp FROM spr s, predmeti p, opt o, nastavnici n WHERE s.jid=p.jid AND s.sprid=p.sprid AND p.pid=o.pid AND o.nid=n.nid AND s.jid<>13 AND n.jid=13   X
  57. 21-DEC-18   14:44:38    SELECT * FROM jedinice  OK
  58. 21-DEC-18   14:44:23    SELECT * FROM spr   OK
  59. 21-DEC-18   14:40:56    SELECT s.jid||s.sprid sifra,s.naziv,COUNT(*) br_predmeta FROM predmeti p,spr s WHERE s.sprid=p.sprid AND p.jid=s.jid AND semestar=7 GROUP BY s.jid||s.sprid,s.naziv ORDER BY br_predmeta DESC   OK
  60. 21-DEC-18   14:39:47    SELECT s.sprid,s.naziv,COUNT(*) br_predmeta FROM predmeti p,spr s WHERE s.sprid=p.sprid AND semestar=7 GROUP BY s.sprid,s.naziv ORDER BY br_predmeta DESC   OK
  61. 21-DEC-18   14:36:48    GRANT SELECT ON pregled_fond TO milosb  OK
  62. 21-DEC-18   14:36:18    CREATE OR REPLACE VIEW pregled_fond AS SELECT a.naziv, SUM(b.fc) fond FROM test3_t1 a, test3_t2 b WHERE a.jid=b.jid AND a.SID=b.SID GROUP BY a.naziv ORDER BY fond DESC     OK
  63. 21-DEC-18   14:35:55    GRANT SELECT ON test3_t2 TO milosb  OK
  64. 21-DEC-18   14:35:52    GRANT SELECT ON test3_t1 TO milosb  OK
  65. 21-DEC-18   14:35:45    GRANT SELECT ON test3_t1, test3_t2 TO milosb    X
  66. 21-DEC-18   14:34:06    SELECT a.naziv, SUM(b.fc) fond FROM test3_t1 a, test3_t2 b WHERE a.jid=b.jid AND a.SID=b.SID GROUP BY a.naziv ORDER BY fond DESC    OK
  67. 21-DEC-18   14:30:49    ALTER TABLE test3_t1 ADD CONSTRAINT check_test3_t1 CHECK(koeficijent>=1 AND koeficijent<=15)    OK
  68. 21-DEC-18   14:30:24    ALTER TABLE test3_t1 DROP CONSTRAINT SYS_C0040184   OK
  69. 21-DEC-18   14:29:29    SELECT * FROM user_constraints  OK
  70. 21-DEC-18   14:29:09    INSERT INTO test3_t2(pid,jid,SID,predmet,fc) SELECT * FROM milosb.t2_2014   OK
  71. 21-DEC-18   14:29:00    SELECT * FROM user_constraints  OK
  72. 21-DEC-18   14:28:51    ALTER TABLE test3_t2 DROP CONSTRAINT SYS_C0040214   OK
  73. 21-DEC-18   14:28:25    DROP CONSTRAINT SYS_C0040214    X
  74. 21-DEC-18   14:27:53    SELECT * FROM user_constraints  OK
  75. 21-DEC-18   14:27:35    INSERT INTO test3_t2(pid,jid,SID,predmet,fc) SELECT * FROM milosb.t2_2014   X
  76. 21-DEC-18   14:27:29    ALTER TABLE test3_t2 MODIFY fc NUMBER(*,2) DEFAULT 3 CHECK(fc>=1 AND fc<=10)    OK
  77. 21-DEC-18   14:27:07    ALTER TABLE test3_t2 MODIFY fc NUMBER(*,2) DEFAULT 3 CHECK(fc>=1 AND fc<=10),   X
  78. 21-DEC-18   14:25:57    INSERT INTO test3_t2(pid,jid,SID,predmet,fc) SELECT * FROM milosb.t2_2014   X
  79. 21-DEC-18   14:25:17    SELECT * FROM milosb.t2_2014 ORDER BY fc DESC   OK
  80. 21-DEC-18   14:25:04    SELECT * FROM milosb.t2_2014    OK
  81. 21-DEC-18   14:24:58    SELECT * FROM milosb.t2_2014    OK
  82. 21-DEC-18   14:24:33    SELECT * FROM user_constraints  OK
  83. 21-DEC-18   14:24:13    SELECT * FROM user_cons     X
  84. 21-DEC-18   14:23:37    INSERT INTO test3_t2(pid,jid,SID,predmet,fc) SELECT * FROM milosb.t2_2014   X
  85. 21-DEC-18   14:22:57    SELECT * FROM milosb.t2_2014    OK
  86. 21-DEC-18   14:22:45    INSERT INTO test3_t1(jid,SID,naziv) SELECT * FROM milosb.t1_2014    OK
  87. 21-DEC-18   14:21:38    SELECT * FROM milosb.t1_2014    OK
  88. 21-DEC-18   14:21:32    SELECT * FROM t1_2014   X
  89. 21-DEC-18   14:20:43    CREATE OR REPLACE TRIGGER tr_k2 BEFORE INSERT OR UPDATE ON test3_t1 FOR EACH ROW BEGIN :NEW.naziv:='SPR_'||UPPER(:NEW.naziv); END;  OK
  90. 21-DEC-18   14:17:04    CREATE TABLE test3_t2( pid NUMBER PRIMARY KEY, jid NUMBER(2), SID NUMBER(2), predmet VARCHAR2(100), fc NUMBER(*,2) DEFAULT 3 CHECK(fc>1 AND fc<10), CONSTRAINT fk_test3_t2 FOREIGN KEY(jid,SID) REFERENCES test3_t1(jid,SID))   OK
  91. 21-DEC-18   14:13:18    CREATE TABLE test3_t1( jid NUMBER(2), SID NUMBER(2), naziv VARCHAR2(105) NOT NULL, koeficijent NUMBER(*,2) DEFAULT 5 CHECK(koeficijent>1 AND koeficijent<15), CONSTRAINT pk_test3_t1 PRIMARY KEY(jid,SID))  OK
  92. 21-DEC-18   14:12:48    DROP TABLE test3_t1     OK
  93. 21-DEC-18   14:12:27    CREATE TABLE test3_t1( jid NUMBER(2), SID NUMBER(2), naziv VARCHAR2(105) NOT NULL, koeficijent NUMBER(*,2) DEFAULT 5 CHECK(koeficijent>1 AND koeficijent<15))   OK
  94. 21-DEC-18   14:11:49    CREATE TABLE test3_t1( jid NUMBER(2), SID NUMBER(2), naziv VARCHAR2(105) NOT NULL, koeficijent NUMBER(*,2) CHECK(koeficijent>1 AND koeficijent<15) DEFAULT 5 )  X
  95. 21-DEC-18   14:04:01    IP: 89.188.33.31    LOGIN
  96. 21-DEC-18   14:02:28    IP: 89.188.33.31    LOGOUT
  97. 21-DEC-18   14:00:28    SELECT (SELECT COUNT(*) FROM history) ukupno,(SELECT COUNT(*) FROM history WHERE status='OK') tacno FROM dual   OK
  98. 21-DEC-18   14:00:01    SELECT (SELECT COUNT(*) FROM history),(SELECT COUNT(*) FROM history WHERE status='OK') FROM dual    OK
  99. 21-DEC-18   13:56:36    IP: 89.188.33.31    LOGIN
  100. 21-DEC-18   13:27:53    SELECT COUNT(*) FROM history WHERE status='OK'  OK
  101. 21-DEC-18   13:26:48    SELECT COUNT(*) FROM history    OK
  102. 21-DEC-18   13:26:26    IP: 37.0.71.186
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!