I have 2 schemes in oracle each with their username and password, I have a billing and a payroll of which in the billing scheme I have a table called fct_personas and in payroll I have a table called nomi_employees
I would like to know how to u...
I am working in JEE, with WebLogic and OracleXE as a database engine, I am using a DataSource (NO JPA), in this database you have to create sequences to generate autoincremental values, I already did it and it works well when I execute it becaus...
Create some triggers so that my primary keys are autoincrementable at the time of inserting but at the time of executing my script everything executes well when you are going to execute the first trigger that is Trigger_idcomisario stays in a lo...
Hi, I have a problem because a foreign key is part of the primary key of the other table and that is why it gives the error, the model according to the solution of the book is as it is here, so I do not know how do for Oracle to assume it as goo...
The idea is that the stored procedure returns a set of identifiers.
Ex.
pra_id:
303
404
Currently this is what I am trying to do, and it is to use the return of the pra_id as filters:
SELECT rea.rea_id, rea.pra_id, etr.etr_id, etr.etr...
I am doing a job for the school, in which they ask me to make a view that collects the following data:
ID of the employee, name and surname, salary, maximum salary and% of the current salary with respect to the maximum (I do not understand th...
Good evening, stackOverflow colleagues, I have a problem when creating the next method that validates a login.
public Usuarios loginExist(String username, String password) {
try {
EntityManager em;
EntityTransaction t;...
Friends I have the following table called
Scheduling_delivery with the following fields
cod_entrega, cod_ordenamiento, cod_centro_atencion, cod_medicamento
I need to find when there is only duplicate data on the medication.
for example...
I just installed Oracle Database 12c Release 2 (12.2.0.1.0) on my pc with windows 10.
The problem is that I can not create a connection from the Oracle SQL Developer and the message appears in red (see image).
When testing the connectiv...
I have this query from PHP , which does not return values but if I execute it from Oracle SQL Developer it shows me data.
$sucursalesaño=[];
$ventasaño=[];
$query ='SELECT S.SUCURSAL , SUM(V.TOTAL_VENTAS)
FROM T_VENT...