easy table project PL/SQL Oracle
€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.
หมายเลขโปรเจค: #32752140
เกี่ยวกับโปรเจกต์
มอบให้กับ:
As a BI Developer i have a experience of 3+ years in a MNC. I worked on the Visualization tools like Tableau, Cognos, Power BI, Spotfire , ETL Tools like Informatica and Talend and Databases like SQL, PLSQL, Aurora, Or เพิ่มเติม
freelancer 4 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €20
Hello, I can develop the function and the PL/SQL block for you. required. I have more than 12 years of experience in Oracle PL/SQL development. It will be a pleasure to work for you. Kind regards.
Hi Sir, I can do this PL SQL Task in Oracle. I can start now I have seen your job requirements and I am sure that I can do your task efficiently in less timeline as I am an expert Oracle developer Thank, Hasnain
I am an Oracle certified Backend developer that has 2+ years of PL/SQL development.I will write the optimal function with a logging mechanism