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
-
0
votes0
answers8
viewsPaging oracle Apex without updating query
Hello I’m with a problem, my company has a screen where we have a classic report which contains people’s permissions for screens and system functions, but we have a problem, we have a query that…
-
0
votes2
answers37
viewsHow can I apply increase and percentage reduction over unit value
The script below calculates the consumption value for materials and medicines , grouping by patient. select coalesce( sum ( ( (L.QTDE) - coalesce( sum( ( select sum(QTDE) from GECADDEV CD inner join…
-
0
votes0
answers20
viewsManipulating data and dates in oracle
I am developing a report with a view with Oracle database, and I need to make a function where the output value will be the running days since the last product drive, ie basically present day less…
-
0
votes0
answers46
viewsSeparate parent and child field from the same table on a row in the oracle
I have a table that has a father-son relationship: code product Cod father degree 1 banana pie 10 3 2 apple pie 11 3 10 banana 111 2 11 apple 111 2 111 fruit -9999999 1 I need to bring the fields…
-
0
votes1
answer20
viewsGroup By of 1 Oracle SQL Column with latest date
I have a table (TVIC_ODS_MVEL_PRQE), in ORACLE SQL, with millions of records and need to extract from it only 2 columns: phone number (NU_TLFN) and date (DT_PRMR_ATVC_LNHA). The problem is that I…
-
0
votes1
answer34
viewsAdd Count to a query
Good morning, I’m trying to sum up a Count in a query that returns three columns in the oracle the total diet column being the event count for that group! NM_DIETA TOTAL_DIETA DS_SETOR Extra: fruit…
-
0
votes0
answers12
viewsOracle XE 18c database size limitation
According to official documentation from Oracle available in https://www.oracle.com/br/database/technologies/appdev/xe/faq.html has the limitations: What are the resource limits of Oracle Database…
-
0
votes1
answer32
viewsDISTINCT in a WHERE Oracle
I need to return the last two purchases of each table item NOTA_FISCAL_ENTRADA_ITEM, but returns column values VL_UNITARIO_ENTRADA_EST different. That is, if in the last two purchases the value is…
-
-1
votes1
answer123
viewsView creation with record limit
I want to create a view that should only return a maximum of X records, independent of the selection clauses applied. That is, whatever filter you apply, the number of lines should always be X.…
-
-1
votes1
answer80
viewsCopy a column from a given table to another column from another table
I’m trying to do the update below, only I’m having difficulty. I’m grateful for the help!! UPDATE pctabpr set pctabpr.ptabela = (SELECT ptabela FROM pcembalagem WHERE pcembalagem.codprod =…
-
-1
votes1
answer32
viewsHow not to select lines with values from an informed list of values
Instead of using the logical operator of different !=, would like to use a code that performs the query disregarding a list of values as in In only that the reverse. Select from teste where teste1…
-
-1
votes1
answer1266
viewsHow to convert sysdate to milliseconds in Oracle?
How to convert sysdate for milisegundos directly on Oracle? I need to give the same result as the code below in java, but directly in query: String s=df.format(Calendar.getInstance());…
-
-1
votes1
answer2206
viewsHow to Identify and Fix 00302 Error in Oracle?
How can I fix an error of this nature (ERROR 00302) and how to know which line is the error in oracle SQL Developer? Error(16,6): PL/SQL: Statement ignored Error(16,52): PLS-00302: component…
-
-1
votes1
answer362
viewsUsing subselect in oracle. Why is the error occurring?
I’m trying to use this code below, but the oracle returns me the following error: ORA-00907: right parenthesis not found 00907. 00000 - "Missing right parenthesis" *Cause: *Action: Line error: 30…
-
-1
votes1
answer314
viewsAccess oracle database remotely
Is there any way to access, or at least import/create my database in some workspace, or oracle server (free)? So it can be accessed remotely. If yes, how could I do this "access" ?
-
-1
votes2
answers1365
views"ORA-01417: a table may be Outer joined to at Most one other table"
I’m riding a select and I came across the following mistake: ORA-01417: a table may be Outer joined to at Most one other table SELECT A.SEQPESSOA, A.NUMERONF, A.NROEMPRESA, A.SEQPRODUTO,…
-
-1
votes1
answer751
viewsCould not create the driver from Nhibernate.Driver.Oracledataclientdriver, Nhibernate, Version=4.0.0.4000, Culture=neutral,
I am working on an application with NHibernate and Fluent Nhibernate. I’m having trouble with my settings App.config. I don’t know exactly what’s wrong with my settings. I’m getting this Exception:…
-
-1
votes1
answer57
viewsHelp with oracle database query
How to increase wages by 0.1% of those with lower salary than the AVG of your department This is the table I was able to average salaries per department: SELECT cod_departamento, AVG(VAL_SALARIO)…
oracleasked 6 years, 9 months ago Pedro Alencar 89 -
-1
votes2
answers321
viewsError installing jdbc oracle in eclipse
I am finding impediments in the installation of oracle jdbc. Canvas Error message: Error Reading file C: Users alex.jose.silva.m2 Repository with oracle ojdbc14 10.2.0.3.0 ojdbc14-10.2.0.3.0.jar C:…
-
-1
votes1
answer4381
viewsChange oracle Quence
How do I update the Sequence value? Situation: I will create a Quence but it may be that this table is registered or not. Then how do I generate Quence 0 or then with value from which there is…
oracleasked 6 years, 4 months ago Andersson OS 107 -
-1
votes1
answer438
viewsHow to select N records in a select in Oracle plsql?
I have 3 tbs, I make the following catch the id of tb1 in common with tb2 and tb3(id ), then compare if field 1 of tb1(LENGTH) is larger than field 1 of t2, in tbs 1 and 2 there are several ids of…
-
-1
votes1
answer105
viewsOraoledb - What is
What is Oraoledb? What is its function? For example, there is an error here in the work system that only appears the Oraoledb error, what are the reasons?
-
-1
votes1
answer43
viewsConversion of Procedures
Does anyone know or know an easy but easy way to migrate stored-procedures from SQL-Server to Oracle.
-
-1
votes2
answers849
viewsCondition within the WHERE clause
Good afternoon ! I have a task to perform a select, but the parameters are passed as variables and I need to treat the input of one of these variables with the following logic: if &CT is not…
-
-1
votes1
answer493
viewsPLSQL - Procedure for Password Encryption
I searched on the internet a precedent for encrypt the users password, however I only found functions. There is how to generate a Procedure to carry out this process? CREATE OR REPLACE FUNCTION…
-
-1
votes1
answer75
viewsHow does Oracle act after running a PHP script without a commit?
If I run a series of SQL commands with Oracle database, OCI library, without running the commit and defining that it will not be done commit automatic. What will Oracle do at the end of running the…
-
-1
votes1
answer111
viewsMigration oracle to sql server
Can anyone indicate me a good data migration tool for the oracle database to the sql server database and vice versa? I need to take a lot of records from the oracle database and save it in the sql…
-
-1
votes1
answer40
viewsDoubt Bring Specific Date - Oracle
In the query below is bringing this way. Data Inicial Data Final Dia da Semana 16/10/18 30/10/2018 3 Where that initial and final date is a specific period and the day of the week in that case is 3…
-
-1
votes1
answer54
viewsChange multiple identical words in Oracle query
I am having to deal with a very large amount of equal words in my Oracle query and having to change one by one each of them each time I have to test the query with a different field is being…
-
-1
votes1
answer325
viewsOracle - Alias in Case
How can I put an alias in the column name in a CASE? CASE atu.cod_situacao_matricula "Alias" WHEN 2 THEN 'Matriculado' CASE atu.cod_situacao_matricula as Alias WHEN 2 THEN 'Matriculado' Both give…
-
-1
votes1
answer715
viewsAccentuation of indigenous names in the Oracle database
We have a situation of inclusion of records of indigenous names in the Oracle bank, where there is a variation of accentuation, and may have "e" or "u" with tilde. Our Oracle parameters (version 9i)…
database oracle character-encoding accentuation unicodeasked 5 years, 6 months ago Mauricio Adriano 21 -
-1
votes1
answer59
viewsExit code: 139 plugin Sqlplus Jenkins what is this error?
I have a Jenkins working for some time but we need to make the builds integrated with Oracle so I used Sqlplus Script Runner, and this occurring an ero already searched in several places but nothing…
-
-1
votes2
answers51
viewsSort table values by Day and Month
I have this Select below: SELECT b.id, b.codigo, a.codacesso, a.seqproduto, a.desccompleta, b.quantidade, b.data_vencimento, b.data_atual, b.observacao, b.usuario, b.estado, b.loja, a.medvdiageral,…
-
-1
votes2
answers153
viewsRemove duplicity in two columns
I would like to know how to resolve the following situation I have a view where the item code is duplicated by the key of another column ex: data------cod_prod-----descricao-----…
-
-1
votes1
answer119
viewsSQL SCRIPT WITH ERROR
Out of curiosity I took a report from my second semester of ADS and this course consists in making an SQL script based on 3 tables: ALUNO, CLASSE, MATRICULA. I made the script according to the…
-
-1
votes1
answer184
viewsCan you help me?
I am with a project to be done, the project itself consists of creating an sql script based on entity model and relationship, the booklet itself is not very well formulated and based on what I…
-
-1
votes1
answer195
viewsCLOB Filter - Number+text
I have a system whose all fields of a document are Clobs, including combo box with measly "Yes" and "No". I am building a query, I need to filter a Clob field and the values are '0||Yes' and…
-
-1
votes1
answer263
viewsRun Automatic Update - Oracle
I often run a Update on Oracle to change the status in my database, but I would like this update to run automatically, once a day. UPDATE inativa_produto set compras = 'N', estoque = 'N',…
-
-1
votes1
answer28
viewsCompare null field
Good afternoon guys, all right? I am putting together a financial report where I wish to create a field that returns me whether that amount has been paid or not. The query checks the date of the…
-
-1
votes1
answer95
viewsLaravel - [DB::Connection(...)->select(...)] Works on one Job, but does not work on another!
Hello, I have a problem that seems impossible to solve. In my Laravel 6.X application, I have a report that performs database extracts for Excel files, this report has two extraction versions: •…
-
-1
votes1
answer191
viewsORA-00904: Invalid identifier, I am creating a table but this error appears, could anyone help me?
CREATE TABLE CARRO( ID_CARRO VARCHAR(20), MODELO VARCHAR2(10), COR VARCHAR2(10), PLACA VARCHAR2(10), CONSTRAINT PK_CARRO PRIMARY KEY (ID_MARCA, MODELO), CONSTRAINT FK_CARRO_REF_MARCA FOREIGN KEY…
-
-1
votes1
answer28
viewsI need to condition to bring in group by only the data that do not have a condition
I have the following query: SELECT id_grupo, id_analista FROM tb_grupo_analista GROUP BY id_grupo, id_analista; there is a third column called tp_controle, where I need to condition the query from…
-
-1
votes1
answer1691
viewsConvert LONG column to VARCHAR2 in ORACLE - problem related to LONG column value size relative to VARCHAR2
CREATE OR REPLACE FUNCTION PRC_HAM_CONVT_LONG_VARCHAR2 ( p_owner VARCHAR2, p_tabela VARCHAR2, p_coluna VARCHAR2, p_rowid UROWID )RETURN VARCHAR2 IS v_cursor INTEGER; --cursor v_length INTEGER;…
-
-1
votes2
answers62
viewsDatabase Register
My database has this structure. I would like to know how to create the record on PEOPLE and at the same time get the ID and save it on PESSOAS_FISICAS. I created this command for such, but it didn’t…
-
-1
votes1
answer21
viewsHow to list tables that contain null values in an oracle database?
Which tables contain null values? My logic was: SELECT * FROM all_tables; WHERE table IS NULL;
-
-1
votes1
answer40
views -
-1
votes0
answers10
viewsHow to send data to Oracle with jQuey
Hello! On an Apex page, a pdf is generated by clicking a button, this is done by Jquery. I would like that when that same button was pressed, a data was saved in a table field in the BD (Oracle).…
-
-1
votes2
answers228
viewsTwo tables without relationship filter - Laravel
I’m having trouble filtering with two different models. The problem is that there is no relationship between the tables. That’s right =/ The modeling was done by someone else, who said that it would…
-
-1
votes1
answer81
views -
-1
votes1
answer36
viewsHow can I run a Rigger that automatically updates a table when an attribute is updated?
Create OR Replace TRIGGER filme_log before Update OF custo On filme Referencing New As New Old As Old For Each Row Begin Insert into filme_log Values(:new.nome_original, :old.custo, :new.custo,…