Questions tagged as 'plsql'

Tagged questions
1
answer

How can I know if a txt file exists from PLSQL

I have the following problem, I am creating a Trigger in Oracle so that I write information in a txt file, up to here everything is fine, I can write without dramas, the problem is when I need to add information to the file, apart from the one t...
asked by 27.05.2018 / 00:26
2
answers

Delete n rows of a table

My question is this: How can I delete n rows from a table if they meet the condition x rows in total? Where x> > > > > n. I want to use it because I am going to have a job that runs at a certain time and if every time it is execut...
asked by 27.03.2018 / 13:53
1
answer

Problem with for (cursor) and if linked Oracle PL / SQL procedure

What I intend is to create a procedure that updates the sale price of a piece whose price is passed by parameter, this will be done only if the new price is greater than the existing one in the database. For now I want to do it without exception...
asked by 12.05.2018 / 16:58
1
answer

Help ORACLE Queries

List the department, the total salary of the departments that the sum of their salary is greater than 20000. SELECT D.DEPARTMENT_NAME,SUM(E.SALARY) FROM DEPARTMENTS DINNER JOIN EMPLOYEES E ON D.DEPARTMENT_ID=E.DEPARTMENT_ID GROUP BY D.DEPART...
asked by 20.06.2018 / 16:35
1
answer

Error in PL / SQL with a procedure with cursors

I try to solve the following question: Ask the User for nationality, and show the clients with that nationality, for this I used an anonymous block and a procedure that is as follows: Procedure: CREATE OR REPLACE PROCEDURE mostrarNacio...
asked by 30.05.2018 / 20:50
1
answer

How to do an UPDATE correlated with conditions in PL SQL?

I have 2 tables: Table Solicitudes , with columns Id_cliente and No_cuenta_prestamo Table Disposiciones , with columns Id_cliente and Estado_Actual Subsequently I run the following code: ALT...
asked by 17.04.2018 / 21:27
1
answer

Loop within Oracle Forms PL / SQL Block

Good day, I have a block with the following elements: * TextBox *Check box * Label in the TextBox I execute a query to show me data from a table, the checkboxes will serve me to indicate which of the elements shown I want to execute in a s...
asked by 03.04.2018 / 21:14
1
answer

SQL (ORACLE) How can I insert the current date into a table when inserting a record?

I know it's a Trigger and I have this, but it generates an error: create or replace trigger INSERTAR_HORA AFTER insert on TAREA_SOPORTE for each row begin UPDATE TAREA_SOPORTE SET HORA_GENERADO= CURRENT_TIMESTAMP...
asked by 04.10.2017 / 08:19
1
answer

How to get the number of the day of the week PL SQL ORACLE regardless of language

The idea is to be able to get the number of the week in a function in ORACLE but that it will always return the same values regardless of the language configuration so as not to give wrong calculations in the dates, for example Spanish: L...
asked by 02.06.2017 / 17:27
1
answer

Handle an SQL type from java

I have a plSql that returns a type of data. How can I handle these from java, I mean, I make the call to the PL from java, but I do not know how to pick up that type of response to use their fields.     
asked by 25.08.2016 / 14:59