BD LAB4

system
parola

an2
user


interesanti ne starneste interesul

800lei *12luni ZALAU BURSA
bursa privata
zice asa student
isabau@tenaris.com
burseromania@robertorocca.org

PROBLEMA 1

PAS1

CREATE TABLE Angajatii_mei(
ID number(2), NUME varchar(20), Prenume varchar(30), UserID varchar(12), Salariu number(4));

PAS2

Inserez in Tabel datele

CREATE TABLE Angajatii_mei(
ID number(2), NUME varchar(20), Prenume varchar(30), UserID varchar(12), Salariu number(4));
INSERT INTO Angajatii_mei VALUES
('1','Patel','Ralph','rpatel','795');
INSERT INTO Angajatii_mei VALUES
('2','Dancs','Betty','bdancs','860');
INSERT INTO Angajatii_mei VALUES
('3','Biri','Ben','bbiri','1100');
INSERT INTO Angajatii_mei VALUES
('4','Newman','Chad','cnewman','750');
INSERT INTO Angajatii_mei VALUES
('5','Ropeburn','Audry','aropebur','1550');
SELECT * FROM Angajatii_mei;


PAS 3

UPDATE Angajatii_mei
SET NUME='Drexter'
WHERE ID=3; modifica idul 3 numele

PAS 4
(s-a facut o marire)
CU UPDATE

UPDATE Angajatii_mei
SET SALARIU=1000
WHERE SALARIU<900;

PAS 5
daca gaseste un rand

DELETE FROM Angajatii_mei WHERE NUME='Dancs';

PAS 6 STEREGEM INREGISTRARIL:

TRUNCATE TABLE Angajatii_mei;

PAS7

CREATE TABLE departament(ID number (7), Nume varchar2(25));


PAST8
INSERT INTO departament(ID,nume)
SELECT deptno, dname
FROM dept;


PAS 9

CREATE TABLE Angajatii(ID number(7),Nume varchar2 (10),Prenume varchar2 (25),Dept_ID number (7));

INSERT INTO Angajatii(ID,Nume,DEPT_ID)
SELECT EMPNO, Ename,MGR
FROM emp;

SELECT * FROM Angajatii


PAS12

DELETE FROM EMPLOYEE2 WHERE DEPT_ID=(SELECT DEPTNO FROM DEPT WHERE LOC='DALLAS');