Concluído

easy table project PL/SQL Oracle

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.

Habilidades: SQL, Oracle

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

ID do Projeto: #32752140

Concedido a:

avinashca34

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)
0.0

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

robertantoni79

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)
2.9
Hasnain136

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)
2.2
Djambaz

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)
0.0