Questions tagged as 'plsql'

Tagged questions
2
answers

Exercise in PL / SQL

Encode a procedure that receives as parameters a department number, an amount and a percentage and that raises the salary to all the employees of the department indicated in the call. The increase will be the percentage or amount indicated in th...
asked by 07.04.2018 / 19:42
1
answer

Call an SP from another SP ORACLE

I have the following SP, create or replace PROCEDURE INUP_PARTY( o_PARTYID2010 OUT VARCHAR ) AS v_partyMAX NUMBER :=0; BEGIN SELECT MAX(PARTYID2010) INTO v_partyMAX FROM PARTY2010; INSERT INTO PARTY2010 ( PARTYID2010...
asked by 22.11.2017 / 15:17
1
answer

Sum of rows in Oracle PL / SQL

I want to add these two amounts but I get two different rows because they are unequal the amount should give me "2231" and a single row: MONTO NAC CEDULA CODIGO SUBCODIGO FISCAL FECHA 1673,25 V 8018573 28 50 2017 11/05/17 557...
asked by 13.09.2017 / 00:28
1
answer

Select with case and decode with different columns [closed]

I want to make a query with a case and decode in the same selection with different columns so that: select NOMBRE, case when DESDE >= 0000 THEN decode(DIA,'0','DOM','1','LUN','2','MAR','3','MIER','4','JUE','5','VIE','6','SAB','ALL','TOD...
asked by 31.08.2017 / 18:26
1
answer

How to use the LIKE as a parameter in a function in postgres

Hello everyone, I am trying to pass a query that I use regularly to a function but I run into problems to create it. What I have so far is the following CREATE OR REPLACE FUNCTION "public"."prueba" (in regional varchar, in fecha date) RETURNS...
asked by 10.04.2017 / 22:31
2
answers

Compare two tables, one of sql server vs. another one of pl / sql

How or where can I do a select comparing two tables from different databases? Example: I have two databases, one in SQL Server 2008 r2 and one in Oracle There is a table of ventas_cabecera in both Which of the platforms...
asked by 08.03.2016 / 14:36
1
answer

Oracle FORMS - Validate or invalidate records

I'm doing a FORM with a series of columns in GRID which are PARAMETER - ALPHA VALUE - VALUE NUMBER - VALUE DATE - COMMENT Parameter and Comment are mandatory but I want the user to have to enter at least one of the values. If you enter one...
asked by 10.12.2018 / 13:16
1
answer

Problem with stored procedures in oracle and with .net

I have a problem that does not allow me to advance in my work, I hope you can help me. I'm doing a Web API that connects to a database in Oracle, it's a simple CRUD, I've done the Stored Procedures and everything, I've tried them from Oracle...
asked by 04.12.2018 / 07:36
1
answer

Sintax error, rule partially recognized PL / SQL

I find myself performing a simple procedure in PL/SQL to practice receiving an entry and exit number and increasing it each time it is executed. The code is like this. CREATE PROCEDURE sumauno(suma in out int) IS BEGIN SET suma=suma+1;...
asked by 23.11.2018 / 17:57
0
answers

Create procedure to print the attributes of a pl / sql object on the screen

I am using sql developer with oracle database, the fact is that I have a created object called mesa, whose attributes are date of manufacture, color, number of legs and name, the fact is that I have a function that returns how old are you and I...
asked by 01.12.2018 / 12:37