easy table project PL/SQL Oracle
Budget: €8 – €30 EUR
The table is given:
CREATE TABLE salaries2 (
Employee_mark INT NOT NULL,
an NUMBER (4) NOT NULL,
luna number (2) NOT NULL,
NUMBER (3),
income base NUMBER (16.2),
increase NUMBER (16.2),
tax NUMBER (16.2),
NUMBER retainers (16.2),
CONSTRAINT pk_salaries PRIMARY KEY (employee_brand, year, month),
CONSTRAINT ck_salarii_an CHECK (an between 2001 and 2012),
CONSTRAINT pk_salarii_luna CHECK (luna BETWEEN 1 and 12)
);
Write a function that determines the net income of the employee with the registration number "employee_mark" (input parameter. Net income = Basic income * (bonuses / 100) - tax - withholdings).
Give an example PL / SQL execution block that defines a cursor that changes the hourly wage by 10 percent more, if it is lower than the value of 24 lei / hour.
CREATE TABLE salaries2 (
Employee_mark INT NOT NULL,
an NUMBER (4) NOT NULL,
luna number (2) NOT NULL,
NUMBER (3),
income base NUMBER (16.2),
increase NUMBER (16.2),
tax NUMBER (16.2),
NUMBER retainers (16.2),
CONSTRAINT pk_salaries PRIMARY KEY (employee_brand, year, month),
CONSTRAINT ck_salarii_an CHECK (an between 2001 and 2012),
CONSTRAINT pk_salarii_luna CHECK (luna BETWEEN 1 and 12)
);
Write a function that determines the net income of the employee with the registration number "employee_mark" (input parameter. Net income = Basic income * (bonuses / 100) - tax - withholdings).
Give an example PL / SQL execution block that defines a cursor that changes the hourly wage by 10 percent more, if it is lower than the value of 24 lei / hour.