Questions tagged as 'pl-sql'

Tagged questions
1
answer

Questions about functions and procedures inside packages (oracle)

I have a package in my bank and I can not see the source code of the procs and functions inside it. Below the packege code and the procs and functions inside: CREATE OR REPLACE PACKAGE TS_ODO.ODO_AUT_RCS_DIRECIONAMENTO is -- Purpose : Real...
asked by 17.11.2015 / 19:31
1
answer

Debug function inside a package

I have a package with various functions and procs. How do I, using pl / sql developer, to debug? I would like to know how I go about the error and see what is being done. Using the pl / sql Tests tool I know I can debug. What happens is that...
asked by 03.12.2015 / 19:29
1
answer

Decode in full select

Can I perform a decode on a select that returns all the data in a table and some of the other tables? In this select, I would like to do a decode for one of the columns of PP (request_peace), but as it does a full search I do not know if it i...
asked by 06.11.2014 / 20:26
1
answer

Procedure in Package receive an array (coming from a cursor / function) as input parameter - Oracle

Good afternoon, I already have a certain experience with PL / SQL but I have now started working with the Oracle database and packages. I have a problem where my procedure in the package is getting two parameters and from there performing...
asked by 04.12.2018 / 19:25
2
answers

SELECT Cursor using top1

I need to return only the highest value of one of the lines below, taking into account that I also need to submit the order code. I tried to run via cursor but without success. By the cursor would pass the 3 lines, but would need to con...
asked by 25.10.2018 / 23:42
2
answers

function snippet failed to read table

I'm developing a function that read from one table and inserts into another: The error is: Warning: Function created with compilation errors. I've removed the select line and it works. So, the error is in it. create or replace function F...
asked by 06.10.2018 / 02:26
1
answer

Use variable in an execution

I'm creating the following pl: declare cont integer; tabela varchar2(100) := 'TABLE_TESTE'; col varchar2(100) := 'TESTE'; begin SELECT COUNT(*) into cont FROM USER_TAB_COLUMNS WHERE TABLE_NAME = UPPER(tabela) AND COLUMN_NAME...
asked by 03.10.2018 / 21:11
1
answer

not in the same table

Let's say I have the CON_CONTRATOS table and I have con_customerId , con_vencimento among others. And I need to do a select that returns me ALL the contracts of a customer whose contract is only with con_vencimento not nul...
asked by 05.10.2018 / 13:07
0
answers

PL / SQL - how to see the amount of rows manipulated through a trigger?

I've already tried with sql%rowcount but when it's a trigger it just does not work .. how can I return the number of rows manipulated in a DML statement from a trigger?     
asked by 22.07.2018 / 00:04
0
answers

Unknown date format in Oracle

Good morning. I have to access the data in an Oracle database, where a field described as "validation date" has the following data: DtValid ------- 115365 115364 115363 115362 115361 Does anyone know what kind of date this is? What format i...
asked by 15.07.2018 / 17:31