Questions tagged as 'oracle'

Tagged questions
1
answer

Equivalence of the Firebird GEN_ID () function in ORACLE

Speak, I'm learning BD Oracle, before I used firebird. But I'm having a problem that I can not solve. I can not add a new country through the system (java), if I enter it through SQLDeveloper, it appears in the query. The error that appears when...
asked by 07.03.2017 / 17:55
1
answer

Preventing duplicate data

I want to prevent the registration of a person whose CPF has already been registered. I tried to do something but it was an error because I defined the CPF field as constraint . Instead of giving the error I would like to be shown a message adv...
asked by 19.07.2016 / 22:17
1
answer

Table Analysis with Execution Log

I have a table in Oracle 11g with the following structure: CREATE TABLE USER.LOG_EXECUCAO ( ID NUMBER, DATA DATE, QTD_REGISTROS_INSERIDOS NUMBER, TEMPO_EXECUCAO VARCHAR2(50 BYTE) )...
asked by 04.04.2016 / 14:43
2
answers

Read an Array or Bulk Collect as a table in an Oracle PLSQL

How do I load an Array or Bulk into a PLSQL and then read this as a table. Example DECLARE VA_ARRAY ....DEFINIÇÃO DO ARRAY VN_QTD NUMBER; BEGIN -- TABELA01 É UMA TABELA FÍSICA EXISTENTE NO BANCO SELECT * BULK COLLECT INTO VA_ARRAY F...
asked by 25.05.2016 / 18:31
1
answer

How do I set a primary key to an existing table in Oracle?

I usually do it directly through the IDE (Sql Developer), but I need to run the script this time. Assuming the existing table TB_CR_INDICADOR_PERIODO and column COD_CR_INDICADOR_PERIODO as the unique ID column, how could I set t...
asked by 11.05.2016 / 21:40
2
answers

The type initiator of 'Oracle.DataAccess.Client.OracleConnection' raised an exception with C #

My wpf program worked very well. They moved, to make some changes. Well, I was asked to change some folders in the application. Before I make any changes I ran the application and it is giving me this error:    The type initializer for 'Oracl...
asked by 18.05.2016 / 15:12
1
answer

Syntax understanding pl / sql Oracle 11g

I have an Oracle PROC 11g. Inside the proc is something like this: v_prazo_subs_ans ts_odo.odo_controle_sistema.val_parametro%type; Where: v_prazo_subs_ans is a variable ts_odo.odo_controle_sistema is the table...
asked by 19.11.2015 / 20:13
2
answers

Modifying Update Between Two Oracle Tables

I need to do an integration between two sws in the house and I need help. I have an integration table (3rd) that will receive the data of a new management, if it is created or modified. For this, I have a view that brings the source data a...
asked by 04.06.2014 / 03:20
1
answer

What exactly is the UTL_HTTP (ORACLE) SET_PROXY Proxy?

utl_http.set_proxy ( link '); In this example what exactly does this proxy address? I tried the internal IP and it did not work, the infra of my company said to have no "external proxy". Font Thank you.     
asked by 18.10.2018 / 01:28
1
answer

Query Oracle SQL - Subtract hours

Hello, I am a beginner in SQL and I have a mortal doubt. This query is to parse a running log on a basis of my company. The problem is that the OS time zone is +0.00 which creates incorrect logs in my log (you can not make this change, so I've a...
asked by 08.08.2018 / 21:46