I have a table of data for company officials.
I have to show who completed a year of work at the company.
The data type for the yearAdmission field: DATE (dd / mm / yy)
How can I create select to show only the employees of a company that have been admitted to it before a given year?
The type yearAdmission is date ie: dd-mm-AA
I have a trigger that after inserting a new user in the table tFuncionario I have to fill another table tPlanoSaude with the data of the official.
Employee table
HealthPlantable TriggersCodeCREATEORREPLACETRIGGERINSERTFUNCIONARIOBEFOREINS...
Well, I put PL / SQL and mysql because these two modes have procedures in both Oracle and mysql, but anyway.
The IN mode I understood that it works like a constant, it is passed through the parameter and can not be changed inside the procedure ....
I have a PLSQL code: in which I get two values one numeric and another varchar.
Code:
create or replace FUNCTION hospitalTeste123(MatriculaMedico in number, nomeSchema in varchar2 ) return varchar is
type Tmedicos is record(
matM...
I have to add the value partially the values of a category (goes the code in below)
DECLARE
--VARAVEIS
CURSOR CPRODUTO IS SELECT * FROM PRODUTO_TESTE2;
VPRODUTO PRODUTO_TESTE2%ROWTYPE;
Vsoma real;
BEGIN
Vsoma := 0;
FOR VPRODUTO IN CPRODUTO...