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
votes1
answer164
viewsSelect with two fields like Fks from the same table
I’d like to know how to ride a select in Oracle to perform the departure of the names of the teams that participated in a game, using the structure below: Follow the code to create the table: Code…
-
1
votes0
answers76
viewsHow to call a precedent using an oracle out-type course with C#
I’m taking a test to figure out how to make a call from a trial that has this kind of course In the past I have this: create or replace PROCEDURE "PTESTE" ( pcd_servicoagendado integer, ptipo…
-
1
votes2
answers1201
viewsDisplay a message on command output
I am running this PL/SQL and in case the condition falls on else, how to display the message to the user? declare cont integer; tabela varchar2(100) := 'PESSOA'; coluna varchar2(100) := 'NOME';…
-
1
votes2
answers48
viewsEntity framework 6.2.0 + Find
Hello, I’m using a search method with Entity framework and oracle, and found a problem with dates. In my search I use the following logic: Find(x => x.Data_Intencao >= Periodo.Date, c =>…
-
1
votes2
answers1444
viewsConvert Integer to Decimal in Oracle
how do I convert a whole number to decimal on oracle? Today, the consultation coming out this way. 75 However, I want you to go out with 2 decimal places, that way. 75.00 Below is the syntax of the…
-
1
votes1
answer1153
viewsOracle SQL Query - Subtract Hours
Hello, I’m a beginner in SQL, and I’m in mortal doubt. This query is to analyze an execution log on a basis of my company. The problem is that the time zone of the OS is +0.00 which creates…
-
1
votes0
answers36
viewsStock modeling for performance in Oracle and sqlserver
A stock table that will be widely accessed where I will have the quantity field being constantly changed with inputs and outputs which is most indicated in the matter of tunning and performance? 1-…
-
1
votes1
answer516
viewsPassing Date parameters for queries
I am having a problem when passing a parameter. I tried to debug by passing the Date as `string, but the problem arises that one expects a number instead of a character. After that I searched other…
-
1
votes1
answer1097
viewsScheduling of Jobs using Oracle Scheduler
Good morning, good afternoon and good night. You could help me with a problem regarding the oracle dbms_schedule. I need to create a JOB that starts every day at 22hrs and stops at 4hrs in the…
oracleasked 6 years, 2 months ago Leonardo de lima silva 21 -
1
votes1
answer124
viewsInterrupt Thread (Java) does not kill execution in Oracle database
Guys, I’m working on a script runner PL/SQL, using the JDBC Statement to make my connections with the bank. My problem is that the project works with Threads and when the user wants to interrupt the…
-
1
votes1
answer378
viewsOracle Where case
I need to create a condition in the where according to a boolean. If boolean = true then I will select the lines with higher end values than expected (ConfirmedVolume > ExpectedVolume, etc) if it…
-
1
votes1
answer300
views -
1
votes1
answer177
viewsSQL query returning one of the empty columns, different from the database
I’m doing an SQL query, in Oracle database, but one of the fields returns the empty value, different from the table in the database. I have tried to create, and rebuild the indexes, but the problem…
-
1
votes1
answer63
viewsHow to get all the sums of 'SUM'
Good evening everyone, I would like to sum up with the 3 (SUM CASE) below. SELECT SUM(CASE WHEN (a==b 2 THEN 1 ELSE 0 END) AS qtdDba, SUM(CASE WHEN (a==b 5 THEN 1 ELSE 0 END) AS qtdDev, SUM(CASE…
-
1
votes0
answers99
viewsHow to list a group of coordinates(latitude, longitude) in an Oracle 11g SQL table in a radius
I need to list a group of coordinates in a radius of 500m. I have a name table TB_COORDENADAS, with the columns LATITUDE and LONGITUDE. I wish to point out a coordinate (lat, lng) and list all…
-
1
votes1
answer640
viewsSQL - IN inside a SUB SELECT with NOT IN - ORACLE
I wanted to make my INSERT dynamic, I don’t need to change the ids manually. I have this script that returns all PRODUCTS that does not have 83 relationship with the EST_PROD_PRECO_CUSTO_EMPRESA…
-
1
votes0
answers36
viewsCode-based configuration - EF6
I’ve been trying for a few days to implement a connection to an Oracle 11g database using the EF6 code-based configuration, but nothing I’ve done so far seems to work. Currently this is my…
-
1
votes1
answer116
viewsRemoving comma from the pl sql column
Good afternoon, I have a table that has names. In some lines the name is separated by comma. Ex: Alberto, Luiz I want to change these lines to stay Luiz Alberto DECLARE final VARCHAR(50); inicio…
-
1
votes3
answers121
viewsMAX() returning multiple lines
When running the script the same returns not only the maximum value, that is, the longest time, but the 3 times. SELECT P.CD_PACIENTE CD_PACIENTE ,P.NM_PACIENTE NM_PACIENTE ,L.CD_UNID_INT…
-
1
votes2
answers289
viewsAdd a column with data in Varchar2 format
I want to sum up the column Value that is of the type Varchar2, I know that to use the SUM() I also have to use the GROUP BY, only that I am not able to make the sum. I don’t know which fields I…
-
1
votes3
answers83
viewsHow to consult register that does not contain a certain code?
I need to make an appointment to list calls that haven’t been validated. It works that way: A call is a support request, in which several actions occur, and all are recorded in an auxiliary table. I…
-
1
votes1
answer1994
viewsHow to identify a Job being executed?
Hello.. I created a Job in ORACLE, where it runs a PROCEDURE, but I wanted to perform a SELECT, where I returned the status of this Job. Because I will use this information to return a reply to the…
-
1
votes1
answer26
viewsReturn non-repeated lines in a Select
I am using the following select on oracle select DISTINCT delivery, dt_coletado from table1 and is returned to the following line DELIVERY DT_COLETADO 8816619995 2019-05-17 00:51:04 8816619995…
-
1
votes1
answer415
viewsError connecting Python to Oracle BD
I am unable to connect Python to my oracle database. Displays the following error : import cx_Oracle con = cx_Oracle.connect('topm/[email protected]/xe') print (con.version) con.close() Traceback (most…
-
1
votes0
answers46
viewsHex to string oracle conversion
I created the following query and executing displays an error message. Someone has an idea of what might be? Consultation: SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW(relatorio)) FROM GRELBATCH where…
oracleasked 5 years, 5 months ago LEANDRO PEREIRA GOMES 11 -
1
votes0
answers179
viewsWhat are Oracle queues (Queue)
I was working on an Oracle database import, and during the import noticed the existence of objects of type queue, I’m used to procedures,functions,view, etc. The one in question had never seen. I’d…
-
1
votes1
answer2763
viewsHow to recover script history from PL/SQL
I had to reinstall PL/SQL Developer and so lost all script history. Is it possible to recover? Thank you.
-
1
votes2
answers34
viewsHow to leave Oracle 12c Enterprise with Logs in English
Good afternoon to all, I downloaded the oracle 12 Oracle 12c Enterprise from the Oracle site with my logged in account and the installer was all in Portuguese but when it appears the option to…
-
1
votes0
answers85
viewsCamparation of databases
I receive daily an Oracle database with 12 tables containing on average 8 million records each. I need to treat it to get only the updated day records compared to the previous day’s base, but I…
-
1
votes1
answer763
viewsError making UTL_HTTP request. ORA-28759: Failure to open file
By making a request the determined endpoint, error occurs below CREATE OR REPLACE PROCEDURE CALL_REST_WEBSERV_POST_METHOD AS V_WLT_DIRECTORY VARCHAR2(4000) :=…
-
1
votes1
answer43
viewsHow to Take data from an SQL table by referencing only the first position of the VARCHAR type
I need to delete everything that starts with '9' in my seg1 column, for example: If in the table this '954747A' will be eliminated because the 9 is the first position. If you have '34465922A' It…
-
1
votes1
answer171
viewsTables Displayed in Oracle SQL Developer
Good Night, installed in my notebook the oracle database and the oracle sql: $! I would like to know how to display only the tables I created or create,and not display these others, since it leaves…
-
1
votes0
answers41
viewsDoes not enter into Oracle bank, with Nhibernate
I have a problem in an application, developed in C#, that uses Oracle database, and access the database with Nhibernate. When trying to perform the Saveorupdate() function, the Insert is not done…
-
1
votes1
answer69
viewsGENERATE A SELECT WITHIN A PROCEDURE
Good evening, everyone, I’m trying to make a select within an ORACLE database, only I’m not getting it. Below is an example of code I’m trying to generate. CREATE OR REPLACE PROCEDURE TRAZNOMES IS…
-
1
votes2
answers133
viewsCOMMIT inside a CURSOR
I have a very large database that I have to copy information from. To decrease the use of memory I thought of inserting the information in parts, using a CURSOR and paging the data, thus carrying…
-
1
votes3
answers249
viewsDOUBT IN SQL -TURN ROWS INTO COLUMNS
I got this one query, it brings to the same product 3 rows of result, wanted these results to be returned in columns, how to do? SELECT CODPROD, EMB FROM TABELA WHERE PRODUTO = 2 this research…
-
1
votes1
answer126
viewsInsert com select - oracle error ORA 00904
I’m having trouble understanding why this mistake. I want to insert a field {descricao_posto} on the table TB_POSTOS_NO_CONTRATO, using a select from another: TB_POSTO. A 1a. table has a fk_post…
-
1
votes0
answers32
viewsReturn of the oci_new_cursor
Hello! I have the following question: the oracle function for PHP oci_new_cursor, can only be used when the cursor already exists in the database? For example, I just created my query within my php…
-
1
votes1
answer445
viewsDifficulty creating Function in oracle
I’m trying to create a function in the oracle, but I’m having a hard time creating her return. CREATE OR REPLACE function simple_function( state VARCHAR2, city_id NUMBER) RETURN VARCHAR2 IS ret…
-
1
votes1
answer107
viewsHow to select distinct from the Listagg function in the 12C database
Is there any 12c bank function you can use on listagg and does not bring repeated results? SELECT SUM(quantidade) quantidade, LISTAGG (mib.segment1, ' - ') WITHIN GROUP (ORDER BY ROWNUM) item,…
-
1
votes1
answer39
viewsAssign date to a var date in oracle
v_data date; v_data := to_date(to_char('01/02/2020)); This approach does not work. How do I assign a date to a var date on oracle?
-
1
votes1
answer62
viewsSum result of 2 fields
I could use a little help with a consult. I have a sales chart where has the field vltotal and vldevolucao, the total of these fields already managed, but I’m not getting the result of the sum of…
-
1
votes0
answers69
viewsHow to sum up an Oracle select case
I am trying to make a sum in a select case, but apparently it is not valid, the following error appears " ORA-01858: a non-numeric Character was found Where a Numeric was expected". when I remove…
-
1
votes1
answer521
viewsSQL - Function to calculate working hours considering business hours, working days and holidays
I need a function to calculate working hours considering business hours, working day and holidays, I have searched in several websites and can not find any function that contain all these…
-
1
votes1
answer115
viewsSQL return in PHP converts accent to '?'
I have a problem with encounter, my return from the Bank Oracle is doing the accents in ? Could anyone help me? Detail need to convert into variable not only in Browser, because I will use for…
-
1
votes0
answers45
viewsError naming check type Constraint
Hello, I’m sorry if my question is too trivial or if I’m missing some important information, but I’m trying to create a Constraint type check giving a specific name to it, but gives the following…
-
1
votes1
answer44
viewsThere is performance loss by using alias on oracle
In oracle there is some performance loss, even small, when using alias for tables? Examples: select user.name from user; and select u.name from user u;…
-
1
votes1
answer418
viewsAvoid simultaneous user access
I need to make the user not log in to the system (asp-net mvc) on different machines. The system is on the intranet and currently there is an Access table with date and time of access of the user…
-
1
votes0
answers22
viewsHow to scaffold an existing base with Oracle.Entityframeworkcore without user superpowers?
I’m trying to do the scaffold of an Oracle base with Oracle.Entityframework.Core, but according to this link dotnet-db-samples, the following permissions are required: GRANT…
-
1
votes2
answers2244
viewsHow to calculate the cumulative sum in Oracle
Hello, I have a table with a lot of data, and I would like to count the amount of records in each date of this month. So far OK, a COUNT(*) and a GROUP BY already resolves. SELECT…