easy table project PL/SQL Oracle

The table is given:

CREATE TABLE salaries2 (

Employee_mark INT NOT NULL,


luna number (2) NOT NULL,


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.

Habilidades: SQL, Oracle

Sobre o Cliente:
( 1 comentário ) Roma, Italy

ID do Projeto: #32752140

Concedido a:


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 Mais

€20 EUR em 2 dias
(0 Comentários)

4 freelancers estão ofertando em média €20 nesse trabalho


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.

€30 EUR em 1 dia
(5 Comentários)

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

€20 EUR em 1 dia
(2 Comentários)

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

€10 EUR in 3 dias
(0 Comentários)