Questions tagged as 'pl-sql'

Tagged questions
0
answers

Display button after submitting page oracle apex

I have a test page on link user test password, which is already working ok in general It migrates employees using a shuttle object, and uses collections to update the information. So far so good. It happens that I do not want to leave enabled,...
asked by 11.02.2017 / 21:48
1
answer

Make a select according to an indexed table

I have a table, getSalas , which simplified something like this: CREATE TABLE getSalas( ID_SALA NUMBER(4), NOME_CARATERISTICA VARCHAR2(20), VALOR_CARATERISTICA NUMBER(4) ); The contents of this table are of the type:    1, '...
asked by 26.01.2017 / 14:04
2
answers

calculate how many hours between calling date and current date in pl / sql [closed]

I need to make a query that brings the calls that are outside the SLA for 48 hours calculating the dates and times of the call's opening and current date, can anyone help me?     
asked by 31.05.2016 / 02:25
2
answers

Select with duplicate record

I have a question that may be trivial for most, but that I got stuck here, I look for a lot of research before posting, but I'll need a help. I'm building a select to bring me the closing of the results with base date, for this I need, for ex...
asked by 31.03.2016 / 14:11
0
answers

How to pass a parameter of type 'Nested Table' to a stored procedure in Oracle

I'm working with Oracle for just over 2 months and need to pass a dataset to be used in the query parameter inside the procedure. I searched a lot on the net and found no solution to solve my problem, I always get the same error message - incorr...
asked by 04.12.2015 / 15:30
1
answer

Procedure pl / sql

Talk to the galley blz? Hi, I'm new to PL / SQL and I'm creating my first procedure because I need to load two tables (Insert or Change) I'm using Merge. But when I try to execute my procedure I already get the following error    PLS - 000103...
asked by 14.10.2015 / 17:30
1
answer

Object in oracle giving as invalid (Invalid)

I gave select * from all_objects where object_name = 'meu_objeto'; . Well, that way, I had 4 lines. Two referring to SYNONYM and this does not interest me and two more lines: PACKAGE and PACKAGE BODY . In the (tuple) li...
asked by 30.11.2015 / 16:30
1
answer

Override PL-SQL condition

I have a condition, like this one, in a query . If you receive the parameter empty or 0, you would like this condition to cease to exist, or be aborted, for query to fetch all doctors. where CD_MEDICO_CIRURGIAO = :medico How to do it?...
asked by 14.07.2015 / 13:42
1
answer

Update in table with date field

Hello! I need to do an update on a table. I have some sort of chat in the bank, where it records the time the conversation was started, and should record the time it ended. However, before I implemented the code that would record in the bank...
asked by 08.07.2015 / 17:06
2
answers

Is there a similar clause similar to LIMIT in PL / SQL

I'm using PL / SQL and would like to know if you have any clause or sql script that is similar to the sql LIMIT clause, I've been searching here and found rownum < = X, but does not meet what I want to do. I'll try to explain SELECT select...
asked by 23.02.2018 / 16:04