Questions tagged as 'plsql'

Tagged questions
0
answers

Before Update Trigger SQL SERVER 2012

alter TRIGGER AsignacionHorasDocente_TRG on tbdocentes after UPDATE as BEGIN DECLARE @nhoraCurso INT = (select sum(hor_curso) from tbcursos where id_categoria=1); DECLARE @nhoraDocente INT = (select sum(hdi_docente) from tbDocentes where id_c...
asked by 01.11.2018 / 08:32
0
answers

Help, why does the error: missing right parenthesis in Oracle?

I have the following query that shows me the name of RESPONSIBLE and ALTERNATE of a service the field TYPE RANGE, can have the values 1 or 2, where 1 = RESPONSIBLE and 2 = ALTERNATE SELECT E.NOMBRE_TRABAJADOR RESPONSABLE,...
asked by 08.10.2018 / 03:51
0
answers

CONSULTATION TO PUT DATA FROM A COLUMN IN ROWS plsql

Hello everyone, I hope someone can help me and I've been looking for how to transform columns into rows and find their registry when it has been modified, filtered by date range and the truth is that it has not been much, and searched and looked...
asked by 29.09.2018 / 21:27
0
answers

PL / SQL DBMS_OUTPUT does not work

Hello kid after a couple of years of not touching anything in Oracle's PL / SQL. I have to touch it a little to remember. install the ORACLE sql devolper. BEGIN dbms_output.put_line('HOLAAAAAAAAAAA'); END; But in the output DBMS does not...
asked by 22.09.2018 / 12:39
2
answers

Problems when creating SP in Oracle

Good morning, I have a problem creating a stored procedure in Oracle and trying to save it tells me that I do not have privileges for the table to which I refer, but if I create the SP if I run the slect directly if it brings me re...
asked by 20.09.2018 / 01:11
0
answers

Problem when dropping tables with empty PL / SQL records

Very good, I have done a procedure in PL that filters tables whose columns match or contain the word you receive from a parameter and generate a .CSV file, the fact is that I have thought about, in addition, discard those tables that do not cont...
asked by 05.09.2018 / 13:46
1
answer

format for numbers with many SQL characters

Hi, I am working with ORACLE 11g, making a query to the table through sqlplus, then I save the result of the query in a log. The problem is that there are two fields that return an amount of sum and have many characters so they do not look like...
asked by 14.08.2018 / 19:33
1
answer

How to get the percentage in SQL

The amounts that I handle to make the query are: (3427.2*100)/3716041.16 = 108427.9049953314659197012138188608776844 How to get it done that throws the percentage in whole because how will the system know that the percentage is 108% SELEC...
asked by 09.08.2018 / 18:55
2
answers

PL / SQL Check the value of a column ending with '_' or '%'

I have this table with random values and I want to select only those that end with "_" or "%" in the flavor column using the option "ESCAPE". I have tried this way but it also brings me those that have "_" in the middle of the value....
asked by 03.08.2018 / 09:03
0
answers

Insert massive random with Bulk collect and forall in oracle pl / sql

for simulation questions I am trying a user table with at least 6 million records more quickly using bulk collect and forall, the codes that adapt this worked only once and then I did not understand why it stopped working. here I leave the code...
asked by 31.07.2018 / 23:48