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
answers238
viewsError connecting Codeigniter with Oracle
I am trying to connect the codeigniter with oracle and is giving this error: Fatal error: Call to undefined function oci_connect() in C:\Apache24\htdocs\system\database\drivers\oci8\oci8_driver.php…
-
0
votes1
answer279
views -
0
votes1
answer60
viewsError using ALIAS in select
In the select below, I would like to use the alias novonome in the second column (instr). select substr(titulo, 1, 20) AS **novonome**, instr(**novonome**, ' ')+1 from conteudo; But I get the…
-
0
votes1
answer62
viewsHow to make an appointment to know the averages of people a day of a week
Hello, I would like to know how to make a query (Query) in the Oracle database to know: What is the average number of guests per day of any week. Below is the bank script: CREATE TABLE…
-
0
votes2
answers1401
viewsOracle Update with Join - ORA-01779
Good morning, I am trying to update a column using information from another table using ORACLE. However, I am receiving the error "ORA-01779: it is not possible to modify a column that changes a…
-
0
votes0
answers440
viewsError executing a Trigger ORA-04092: not possible on a trigger
I have the following problem: - I’m not able to perform a job (Scheduling) after an Insert rescued by Trigger. Row 2: ORA-04092: not possible on an ORA-06512 trigger: in "SYS.DBMS_ISCHED", line 135…
-
0
votes0
answers198
viewsFatal oci_connect error
I have a bank oracle which is on a virtual machine, and I’m doing a university job I’d like to connect this web system to that bank. Here comes the doubts, I need to install some application in the…
-
0
votes2
answers729
viewsPower BI - Oracle SQL Query
Hello, I am trying to get data in Power BI via Query on an Oracle DB and is showing the following error. Cannot establish connection Details: "Oracle: ORA-01843: not a Valid Month" SELECT DISTINCT…
-
0
votes3
answers1128
viewsOracle - Select distinct in one column only
I have a table: aluno1 - data 1 student 1 - date2 student 2 - date1 student 2 - date2 And I want my query to return: aluno1 - date1 (date + recent) aluno2 - date2 (date + recent) How do I give a…
-
0
votes1
answer111
viewsNumber(3.0) field in Oracle database for Java
I have a table in an Oracle 11g database with a field of type NUMBER(3,0) In a Spring project, I own the following: @Repository public interface TipoPropriRepository extends…
-
0
votes1
answer2766
viewsError while running a Trigger
I’m having the following error while running my Rigger, how could I resolve? ERROR Error when I give Insert in the purchasing table INSERT into compra_product (CPR_CODIGO, PRO_CODIGO,CPP_QTDE,…
-
0
votes1
answer2984
viewsOracle sql - Expression not found
What I’m trying to do is this: List the names of the Cds that have a sales price greater than 10.00 reais or the label is code 3, ordered alphabetically by decreasing the names of the Cds. Show CD…
-
0
votes1
answer203
viewsFind shift based on a given date time in ORACLE/sql
In a table X I have a date column that also returns the time, I wonder if, based on this time, I have how to create a column with the name of the turn. ex( if you have a die 20-02-2002 06:00:00 I…
-
0
votes1
answer31
viewsHow to ban a DDL action on oracle
I want to do a Rigger that prohibits any DML operation on a given table. In case these are the parameters: between 20:00 to 06:00, and Sunday all day. CREATE OR REPLACE TRIGGER TG_HORARIO BEFORE…
-
0
votes0
answers61
viewsMemory Leak error in connection drivers when trying to launch Tomcat
I have a Java/Vraptor4 application on a Tomcat9.0 , when I am climbing up Tomcat the following error is released: abr 09, 2019 10:50:13 AM org.apache.catalina.startup.VersionLoggerListener log…
-
0
votes0
answers92
viewsHow to run the JOIN command in ORACLE?
Hello. I am having problems with my query at ORACLE, someone would tell me how to solve it ? SELECT C.NRO_CONTA, C.NOME, C.SALDO, SUM(RESULTADO.COTAS) FROM CONTA C JOIN FUNDOS_APLIC AS RESULTADO ON…
-
0
votes0
answers329
viewsStrange characters being inserted into the Oracle Insert
I have an oracle XE database, I want to import sql scripts to fill the tables, however, characters with accent and Ç for example get strange characters for example. In this example Index: Insert…
-
0
votes1
answer69
viewsLock in SQL Server and Oracle
Hi, I’ve been running some lock tests on SQL Server and noticed a difference from Oracle. In oracle I did an update on a line without effecting commit or rollback and in another session I was able…
-
0
votes1
answer924
viewsPL/SQL - Record Type vs Rowtype
When to use a record type, defined by the programmer, rather than declaring a variable of type %rowtype? ex: /**Definido pelo usuário**/ declare type bbb is record( id int, nome varchar(100)); v…
-
0
votes1
answer136
viewsupdate nls_database_parameters Oracle
I need to change the parameters nls Oracle, placing the image characteristics below: I’ve tried a lot of tips, but you always say I have insufficient privileges. These are my settings: NLS_LANGUAGE…
-
0
votes1
answer544
viewsSubquery in Oracle SQL
I have a code that aims to return open invoices from a customer in a specific period of time. But I want to add a field that shows the total number of invoices, regardless of the debt period. The…
-
0
votes1
answer319
viewsProblems for invoking/inserting data with Procedure
I created this project in Oracle, but I’m not able to insert data with the EXEC. Way I’m declaring the EXEC: EXECUTE SP_PRODUTO(8,'teste' 1); erro APRESENTADO: ORA-06550: linha 1, coluna 126:…
-
0
votes1
answer88
viewsDate range query in a given time
I have a query that takes all the data between days. However, I would like him to take this data only in an interval of hours (from 08:00 to 17 for example). My query currently looks like this:…
-
0
votes1
answer72
viewsSprint Boot - Dynamic connection
I have an application developed with Sprint Boot that currently connects to a single Oracle database using the settings of Application.properties. However, I need this application to connect to…
-
0
votes0
answers106
viewsCreate a Boolean column in Oracle Database
In an oracle bank I have to create a column with the Boolean type ALTER TABLE dbamv.prepad ADD editable BOOLEAN default FALSE; But the database displayed an error message: ORA-00902: invalid data…
-
0
votes0
answers534
viewsQuery error - Inconsistent NCLOB data
Hello, I am trying to perform a query in an Oracle database and is returning an error ORA-00932: inconsistent data types: expected - obtained NCLOB 00932. 00000 - "inconsistent datatypes: expected…
-
0
votes2
answers26
viewsfailure in function snippet to read table
I’m developing a function that reads from one table and inserts into the other: The error is: Warning: Function created with build errors. I removed the select line and it works. So, the error is in…
-
0
votes0
answers26
viewsLimit month to export report
Good morning, everyone, I have a system, and it exports the company’s YEAR report. I wanted to limit this report to 18 months. That is, the user can make a report of no more than 18 months, besides,…
-
0
votes1
answer274
viewsField for numbering or ranking distinct records - Oracle
I have a problem which is this:: Knowing that a care can have several exams, I need to number the exams in order to know the first, second, third..., for each service. Example: LINHA ATENDIMENTO…
-
0
votes1
answer1396
viewsconvert varchar to date oracle plsql
I need to convert a varchar for date so that you can filter all dates longer than a certain date, for example: I want all dates that are larger than November 2018 to be listed, I am doing as…
-
0
votes3
answers44
viewsReturn larger field to ID
Good morning, I need some guidance regarding the following situation: In this table I need to return only the MAX(nutab) for each codprod and control. I tried using the MAX, but so only returned…
-
0
votes0
answers25
viewsDoes the following equation respect the syntax of Relational Algebra?
π Nome.Empregado (σ Empregado.IdentEmp = TrabalhoNo.IdentEmp ^ TrabalhaNo.ProjNum = Projeto.ProjNum ^ Nome = ‘Banco de Dados’ ((Empregado x TrabalhoNo) x Projeto)) More specifically in the part I…
-
0
votes0
answers29
viewsSpecify Oracle Entity Framework version
Today we are working with two versions of oracle 12c and 11g. The development is carried out in version 12c. When using the Entity Framework to perform an Count, the same is applying a function that…
-
0
votes2
answers104
viewsTraining ORACLE PL/SQL
Galley, I need to study PL/SQL but my notebook is not supporting Oracle Database Express. Is there a lighter tool or some website I can train? Thank you!
-
0
votes3
answers2475
viewsReturn 0 if the value does not exist in the table
I am using select to check if there is SEQ_RESUMO in the table. If there is this returning me the value of SEQ_RESUMO, ate ai ok. But when the value does not exist in the table, according to the…
-
0
votes1
answer190
viewsInsert for each record found - PL/SQL
good morning. I’m new to Pl/sql and I need to insert 110 records (Number 1 to 110) in a table ( table: stick) for each ID of the court table. Insert would be more or less: INSERT INTO…
-
0
votes2
answers53
viewsSelect floor() in oracle
In Mysql would be the equivalent of SELECT floor(4.5); How to do the same in Oracle PL SQL?
-
0
votes1
answer721
viewsProcedure in Package receiving an array (coming from a cursor/function) as input parameter - Oracle
Good afternoon, I already have some experience with PL/SQL but now I started working with oracle and Packages. I have a problem from which my package process is receiving two parameters and from it…
-
0
votes2
answers267
views -
0
votes0
answers392
viewsError Query Oracle
People, when executing the query below, the following error is occurring. By parsing, the error occurs when I put sum. For what reason? "ORA-00918: column defined ambiguously 00918. 00000 - "column…
-
0
votes1
answer109
viewsHelp with DBMS_STATS.GATHER_TABLE_STATS - Oracle for DB2
I am passing an Oracle protocol for DB2 and I am not able to run on DBMS_STATS account.GATHER_TABLE_STATS : DBMS_STATS.GATHER_TABLE_STATS ('DMTLDBR','TB_FATO_OBJETIVO',PART_MES_ANT,10, TRUE,'FOR ALL…
-
0
votes0
answers163
viewsDifferent Value - Oracle Query
In the query below in the column Valor_Total_da_Ordem is giving a totally different value, far above what was actually to be. The value is giving 55990.62. The correct value being 1333.11. What may…
-
0
votes0
answers38
viewsDoubt Query Line - Oracle
In the query below is leaving this way. Unidade Ordem_Compra CNPJ Aprovador Sim Boavista 29021 155454878787 Ivan Sim Boavista 29021 155454878787 Romel The question is: How do I leave on a line just…
-
0
votes0
answers152
viewsTrunc date oracle, Tuning SQL
Is there any way to optimize query sql, where it is necessary to truncate two dates of a column? Select * from work_table a where trunc(a.datetime) = trunc(a.datetime);…
-
0
votes1
answer175
viewsORA-28000: the Account is locked error appearing frequently
I work at an institution where we use an application that connects to an ORACLE database. Recently the BD user password has been changed, and the message Account is locked appears frequently... I…
oracleasked 5 years, 2 months ago V. Gianvechio 1 -
0
votes1
answer1805
viewsSELECT inside a FOR in declare SQL/ORACLE
I need to generate an excel of a table data but I need to do for each my company, so n have to run select changing the company id I thought to do with Procedure but the ones I have and just update…
-
0
votes2
answers378
viewsGet the invoiced amount from the previous month
Good evening staff. I am a student beginner in database and would like to take a question for study purposes. Suppose I have the following structure: MES QTDUSUARIOS MUNICIPIO VALORFATURADO 2018-01…
-
0
votes1
answer679
viewsHow to use Max() and Count() function together?
Talk personal! I am training a subselect with having using the MAX AND COUNT functions together, but Sqlserver is returning me an error called: "It is not possible to perform an aggregation function…
-
0
votes1
answer142
viewsConnect BD sql server to sql
I am trying to connect my sql Developer to sql server, but it is not working. Password and user are correct. They know what the problem is?…
-
0
votes1
answer294
viewsError inserting BLOB type into Oracle Bank
I’m having a problem inserting a javascript signature into the database. You’re making me wrong again: oci_execute(): ORA-01704: too long string literal I don’t know what it might be, I’ve been…