Differences

This shows you the differences between two versions of the page.

Link to this comparison view

bd2:laboratoare:07 [2019/11/10 17:24]
apetrescu0506
bd2:laboratoare:07 [2019/11/11 12:50] (current)
ciprian.truica
Line 249: Line 249:
 UPDATE EMP UPDATE EMP
 SET COMM = NVL(COMM, 0) + 100 SET COMM = NVL(COMM, 0) + 100
-WHERE EMPNO = 999;+WHERE EMPNO = 1111;
  
 UPDATE EMP UPDATE EMP
 SET SAL = NVL(SAL, 0) + 500 SET SAL = NVL(SAL, 0) + 500
-WHERE EMPNO = 999;+WHERE EMPNO = 1111;
  
 DELETE FROM EMP DELETE FROM EMP
-WHERE EMPNO = 999;+WHERE EMPNO = 1111;
  
 SELECT * SELECT *
Line 282: Line 282:
 <code sql> <code sql>
 INSERT INTO sefi INSERT INTO sefi
-VALUES(50, '​Mediu',​ 1234, '​Preda',​ sysdate, 2000100);+VALUES(50, '​Mediu',​ 1234, '​Preda',​ sysdate, 2000100);
 </​code>​ </​code>​
 Comanda INSERT a generat o eroare, deoarece nu se acceptă inserarea într-un astfel de view. Comanda INSERT a generat o eroare, deoarece nu se acceptă inserarea într-un astfel de view.
bd2/laboratoare/07.1573399489.txt.gz · Last modified: 2019/11/10 17:24 by apetrescu0506
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0