Most voted "oracle" questions
Oracle Server is a relational DBMS (Danco Data Management System), created by Oracle Corporation. Do not use this tag for other Oracle owned Sgdbs servers (for example Mysql, Timesten and Berkeley DB).
Learn more…1,134 questions
Sort by count of
-
1
votes0
answers33
viewsOracle Pivot returning more than one line
all right, guys? I have a problem here. I have the code below: SELECT /*+parallel(12)+*/ DES_REGIS, DES_CONTR, COMPRAS_OFFUS_PARC_COM_JUROS, COMPRAS_OFFUS_PARC_SEM_JUROS, COMPRAS_OFFUS_AVISTA,…
-
1
votes1
answer66
viewsHow to join the select of these 3 tables that have no connection at all?
The image below shows 3 tables, united by Excel. The first is called customer, the second representative and the third is called channel. But I would like to join them in a single select in sql, and…
-
1
votes1
answer956
viewsAdd a 'Virtual' column to a SELECT in Oracle
I would like to place a temporary column that was generated only in the query that will be linked to CD_NIVEL say, "If CD_NIVEL = 5 creates a column 'Exclui' as if it were a description of what the…
-
1
votes1
answer53
viewsHow to Migrate Oracle 11G Long Raw Columns
I need to migrate information from a column of type long raw oracle 11g. CREATE TABLE PROD_IMAGEM ( ID NUMERIC(8), IMAGEM LONG RAW ); CREATE TABLE BKP_TAB_IMAGEM ( ID NUMERIC(8), IMAGEM LONG RAW );…
-
1
votes1
answer88
viewsOracle SQL Function
How do I perform the function that returns the number of credits for a given course by blocking the code? As the example at the end. TB_DISCIPLINA COD_DISCI DESCRICAO CREDITOS TB_CURSO_COD_CURSO…
-
1
votes1
answer43
viewsTime mask HH:MM from a number type field using oracle sql for reporting
I have a query that I use to report hours worked, I tried to use to_char and some other examples I found in stackoverflow. SELECT CASE WHEN BC.ENTRADA1 IS NULL THEN 0 ELSE…
-
1
votes1
answer40
viewsReuse of Clause AND (ORACLE)
Eai Galera. I need to run a select where it gets very repetitive my conditions being various joins in the same table, Follows: select elfo.el_field_option_id "Centro de Custo ID", elfo.label "Centro…
-
1
votes1
answer558
viewsHow to load an Oracle database into R?
I have access to an Oracle database, but have always used this data in the R using the PL/SQL to extract the data in csv. But now I would like to connect my Oracle database on itself RStudio. After…
-
1
votes1
answer91
viewsHow to add values of others in a new column? Ora-00904
I created the columns A, B, C e D. When trying an E Column, which is the sum of the previous ones gives this error ORA-00904, have tried some examples I found in pequisa, gives in the same.. SELECT…
-
1
votes1
answer1099
viewsOracle - WHERE WITH SYSDATE
In the first select the BALANCE is coming zeroed, in the second I replace the sysdate by which would be the date it brings the correct value what must be the problem in sysdate+4 in Where? SELECT…
-
1
votes1
answer1161
viewsPercent calculation in Oracle SQL
I’m mounting a query where I need the percentage of category for each cargo. If I filter for only one load, the query returns correctly. But if I put more than one (a period, for example) the…
-
1
votes1
answer41
viewsHow to find Wrapped objects in the database
I have a database with several objects Wrapped, and I need a way to search and locate all objects that are encrypted, ie with the wrap, to subsequently have a treatment. What are Wrapped objects:…
-
1
votes1
answer227
viewsProblem running web application . net with oracle. Duplicate key
Good afternoon, I implemented a Mvc app that uses Oracle access through Oracle.Manageddataaccess version :4.122.19.1. But received the following message from IIS when running the app: Erro de…
-
1
votes3
answers37
viewsSelect To view two-year billing sum
Good afternoon, I’d like to see the billing sum of two different dates(2018 x 2019, but I’m having trouble with the subselect "Details: "ODBC: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00907: right…
oracleasked 5 years, 1 month ago lorDrakkar 11 -
1
votes1
answer64
viewsSubquery with the records of a column
I have the following problem... I need to extract the information from a table where it has the following structure: tabela: PROCESSO_VALOR_TIPO Coluna : field_model_ids Dados :…
-
1
votes0
answers1296
viewsjava.sql.Sqlrecoverableexception: ES error: Connection closed by the other end, Authentication lapse 0 ms
I have a simple Java application that makes a JDBC connection in an Oracle database, follow the source. public class Main { public static void main(String[] args) { try { Connection conn =…
-
1
votes1
answer211
viewsTwo conditions in Where do not bring a result
I am doing a query in Oracle Database 12C and I have a problem: I want only products that have address_1 as 'A' appear in my ResultSelect. In the example below the item "code: 312107" it has two…
-
1
votes0
answers215
viewsError when deleting an Oracle table reference
I am trying to delete a record from my table TB_CONTATO who is the daughter of the table TB_CLIENTE: DELETE FROM TB_CONTATO WHERE ID_CLIENTE = 2999 But it occurs of violation of integrity:…
-
1
votes0
answers51
viewsDelete with Insert in PL/SQL with FK error
Good night, I have a table that calls horariofunc and the primeiry key of this table is linking in the address table. I happen to be using to update the data a delete and an Insert with the new…
-
1
votes0
answers91
viewsInstead of Trigger to enter values - ORACLE
Summarizing my problem, I need to automatically insert values into a table after other values are entered into it. The way I found to do this on the Oracle was by using a Trigger of the kind INSTEAD…
-
1
votes2
answers144
viewsCASE WHEN in Where clause and with THEN with more than 1 return value
Hello. I have an application for assembly of queries, in which I pass the parameters in the clause "Where". Only I came across a situation where I need to use CASE and in the THEN clause a range of…
-
1
votes1
answer186
viewsSum PL SQL Lines
Galerinha, I created a code that organizes all the tasks of the company by sector. The objective of this code is to identify the percentage of delayed activities by sector. The result was expected.…
-
1
votes2
answers636
viewsReturn of a Knex query using . map
Good afternoon, you guys. I have a Controller that receives data from a frontend spreadsheet, read the dice and play these to run a query in the database, so my intention is to play the results back…
-
1
votes2
answers106
viewsSQL search between two tables with duplicate result
I have a View and a table. A View V_CUSTOMER with customer data, but does not have the same CPF/CNPJ as in the view, which is identified by the field V_CUSTOMER.CUSTOMER_ID that makes the…
-
1
votes1
answer35
viewsReturn value that is not in the other table
I have a query that returns purchase requests on a date, the requests are three, the 1594, 1595 and 1596.. These solitaires have shopping order referring to them that are in another table and that I…
-
1
votes0
answers77
viewsUsing pivot, in this query with dynamic columns
I have the query below where I display products, ordered by the product code, the date of movement of the product is from the latest to the oldest, but as I wanted only the last 5 dates of a defined…
-
1
votes0
answers24
viewsDemand Forecast Monte Carlo Method
Good personal evening, I am developing a select in order to simulate a demand forecast in my company, I am using the Monte Carlo method, which uses a function to generate random values within the…
-
1
votes1
answer51
viewsAdd up the total quantity of a product with different batch? SQL ORACLE
Hello! How are you? I hope everyone is well! Guys I’m new in the business and I believe my problem is easy to solve, but I still have no knowledge to solve and from now I thank everyone for the…
-
1
votes0
answers48
viewsADD CONSTRAINT USING INDEX LOCAL
I have a table signed by DATA_HORA and I would like to create CONSTRAINT forcing the use of INDEX LOCAL instead of GLOBAL, but I am facing the following error. That’s possible? Relatório de erros -…
-
1
votes1
answer63
viewsSQL doubt in query
Can someone give me some guidance in this consultation? How to find out how many possible shows watched? For viewers of the day "24/07/2020" who passed the turnstile before the opening time of the…
-
1
votes0
answers56
viewsIdentify which set of coordinates is within a radius in the ORACLE base
Hello personal I have a script here in Mysql, however I need to apply it in an Oracle database, SELECT *,(RAIO_TERRESTRE * acos( cos(radians(PARAMETRO_LATITUDE)) * cos(radians(COLUNA_LATITUDE)) *…
-
1
votes0
answers21
viewsAdd column values created in PIVOT
Well, in this query I have to list the products that went out for consumption in a certain period, and how much was consumed of each product. I have the Cód of the product, name, date of movement,…
-
1
votes0
answers54
viewsError calling Stored Procedure ORACLE by PHP passing date as parameter
I have the following Stored Procedure on Oracle: CREATE OR REPLACE PROCEDURE SP_RELATORIO( P_ID_SITUACAO IN TB_PROSPECT.ID_SITUACAO%TYPE, P_ID_GRUPO IN TB_GRUPO.ID_GRUPO%TYPE, P_DT_INICIAL IN…
-
1
votes0
answers109
viewsDifference between Insert all and Insert with select dual on Oracle
Hello, good morning! I have some questions about how best to include mass data in an Oracle database so that the database does not suffer so much. Doing some research I identified two methods to do…
-
1
votes0
answers27
viewsQuery pass null parameter, bringing all values
Hello, I have a query in which I need you to bring me or the value passed in the parameter or, if no value is given, bring all information that is not null: Example select cd_medicamento,…
-
0
votes1
answer2060
viewsOCI-22053: overflow error - C#
I am developing a web application in MVC with C#. I made a method that makes a select in my bank oracle and with the value returned I fill a DataTable. But it returns an error the moment I run…
-
0
votes1
answer3836
viewsPLS-00103 error when trying to compile a Package
I am trying to compile the package below and the error is being returned: Error(9,3): PLS-00103: Found the symbol "BEGIN" when one of the following symbols was expected: language CREATE OR REPLACE…
-
0
votes2
answers11150
viewsHow to Mount a Transaction with Commit and Rollback on Oracle?
I’m trying to mount a transaction on Oracle, but I don’t know how to perform a Rollback in case there’s an error in one of the querys. I searched some websites, but I couldn’t find anything clear…
-
0
votes2
answers2742
viewsHow to Migrate SQL Server Database to Oracle
I created a diagram on sql-server, where it automatically creates the entire database structure, only that I will have to migrate to Oracle. I can migrate the whole structure (tables, Fks, Pks,…
-
0
votes1
answer1549
viewsORA-00942 TABLE DOES NOT EXIST error occurring in System.Data.Oracleclient. VB.NET
I have an application in Vb.net using .Net Framework 2.0. Below is an excerpt from my application code: strComando = "SELECT CD_LOCALIDADE, NO_LOCALIDADE FROM COPAGIS_GDB.MUB_LOCALIDADES WHERE…
-
0
votes1
answer3314
viewsHow to pass values to Procedure - PL/SQL parameters
I asked the management company of our system to change the code of some neighborhoods of the system, the same carried out such change, now I need to change the code of other neighborhoods that are…
-
0
votes1
answer840
viewsCalling Function or Procedure Multiple Times
How to create a Function or Procedure that calls another Procedure to perform a neighborhood exchange on my ERP system? Below is the precedent I want to define values for its parameters. It should…
-
0
votes1
answer938
viewsBank Access Attempt Log (Oracle 11G)
We have an Oracle 11G here in the company. Last week some joker tried to access for more than 10 times with incorrect user or passwords. I searched and I’m searching for some way to save access logs…
-
0
votes1
answer5423
viewsHow to disable a Constraint in ORACLE?
I have a table where two specific fields together cannot have the same values. I BELIEVE who are they: NUM_PERIODO_LANCAMENTO COD_INDICADOR Assuming I have that data: NUM_PERIODO_LANCAMENTO = 1 ,…
-
0
votes1
answer8195
viewsMerge two Select
I am developing a report in Powerbuilder and would like to know how I can join results of two SQL queries in the report. If I add the f_bloqueto_nosso_numero function in the first querie and add the…
-
0
votes0
answers409
viewsTrigger error involving Linked Server
I created a Trigger that fetches data from an SQL Server table and writes or updates data from another table in Oracle if there is a change. All this via Linkedserver. But executing it generates the…
-
0
votes2
answers4752
viewsRun a precedent from a Java application
I have a file inside the oracle database, but I would like to run it from a java desktop application that I am developing. How do I run an oracle protocol with java parameters?
-
0
votes1
answer3407
viewsImport XML to Oracle tables
. Hello, I need to import an XML file to an oracle table. There are several examples on the internet, but none of them worked for me. In general, I’m having the error: LPX-00210: expected '<'…
-
0
votes1
answer539
viewsOracle Database 11G R2 Start Service
How do I start the Oracle database service? I installed 11G R2 for DESKTOP on the machine on Windows.
-
0
votes1
answer37
viewsHow to get all lines using duplicate value in IN
How do I get all lines using IN(), and inside IN() have duplicate values SELECT NOME FROM PESSOA WHERE ID IN (1,1,1,2,3,3,4) I want in return come 3 times the name of ID 1, and 2 times the name of…