Questions tagged as 'oracle'

Tagged questions
1
answer

Auto Relationship

I have a drug chart. In it I have: Drug code (PK) description ans code There is the possibility of having more than one drug code for the same ans code. I need to make an appointment to bring all medications that have the same a...
asked by 28.06.2016 / 14:31
1
answer

Create user using a function

Someone could help me, she gets error when saving '-' Error (19.5): PLS-00103: Encountered the symbol "CREATE" when expecting one of the following: (start case declare exit for goto if loop mod null pragma raise return select select update wh...
asked by 25.05.2016 / 18:58
1
answer

SQL in propagated data

I need to hit the SQL below for the Oracle database. The idea is to retrieve the code from the Produto table associated with the code of the Matriz table. In this structure, Matriz is related to at least Fili...
asked by 06.04.2016 / 16:34
1
answer

Empty string return - Oracle

I have a table with a string and several fields separated by | (pipe) I need to bring each field into a column. I even got a way, the problem is that when a record does not have the field filled in the string brings ||. Detail, I can not...
asked by 07.04.2016 / 21:05
2
answers

Procedure execution with date type argument in a dblink

When executing the procedure below, via DBLINK in Oracle corporativo..UP_COP025_ASS_DMANDA_JURID_I 17444968, 1, "1", "20150806", "RJ", " ", " ", "000020" I get the error:    error: Syntax error during implicit conversion of VARCHAR value...
asked by 08.03.2016 / 13:54
1
answer

Filter Last 3 Ratings Oracle sql

I'm making a report and I need to filter out the last 3 vendor evaluations in case this vendor has been downgraded by the date requested in the report. Each evaluation has several questions and I need to bring all these questions to each of t...
asked by 08.02.2016 / 14:41
1
answer

Change data from a column in the table

I need to change 1200 records only from one column in the table, generated the data in the generatedata, the rest of the columns should remain with the data, does anyone know a quick way to do this?     
asked by 21.01.2016 / 14:13
1
answer

When I step date filter for the same day, query returns empty and there is data

In my table / base there is data for day 05/08/2015 , it happens that when I pass a date filter for the same day, it does not work, it returns empty. If I go like this: 04/08/2015 and 05/08/2015 does not work either. It only...
asked by 18.01.2016 / 12:50
1
answer

How do you hit the order by command?

I typed the following command in oracle; select * from emp where ndep in(10,30); and I had this as a result; It'sallright,theproblemisthatIwantedtoputitinthedescendingorderofthedepartmentnumber;Theseweremyattempts;1stattempt;select*from...
asked by 24.12.2015 / 18:42
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