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
answers108
viewsSearch in Oracle Bank losing session
Good morning dear friends, i am having serious problems regarding using Oracle database and losing session. The scenario is as follows: of thousands that you want to accomplish, some of them crash…
-
0
votes2
answers265
viewsNo update of a Collection PL/SQL
I am trying to update a parameter in a table, based on previous values of a Collection, it will update the idAccept attribute of a particular document table id. I also created an Insert in a test…
-
0
votes0
answers314
viewsOracle conversion of LONG RAW to BLOB
I tried to use TO_LOB to convert the value LONG RAW in the insert but returns: ORA-00932 inconsistent datatypes tips Fate is a column BLOB of a table already in use of the system and its type cannot…
oracleasked 7 years, 7 months ago Andrey Hideki Nakano 141 -
0
votes2
answers182
viewsOracle Insert Too Many values
Personal Good night I want to insert data in a table but it presents an error "Too Many values" I will put my code for you to analyze. Insert into tab_Conta(id_correntista,id_banco,…
-
0
votes1
answer36
viewsOracle - From/to Webfocus for Oracle
Guys, I’d like some help. I have an ETL that was created in Webfocus, and I will migrate it to Oracle. I’ve done a lot of/stops, and would like an alternative to the following situations. In…
-
0
votes1
answer493
viewsOracle - Error returning "Name" + Count() - "not a GROUP BY Expression"
Hello! I’m trying to return the names of people and the amount of cars each has according to the 2 tables below, but accuses the following error: ORA-00979: not a GROUP BY Expression 00979. 00000 -…
-
0
votes1
answer51
viewsWrite to oracle without repeating name
I have this block inside a record label that records a representative, which comes from a screen in ASP Classic. v_qtd_rep := ts_obtem_dados_no_xml(v_no_completo,'QTD_REP'); for i in 1..v_qtd_rep…
-
0
votes3
answers928
viewsUpdate in a field that cannot be negative
I need to make a update in a given field, where it should reach at least up to "zero" cannot be negative. And when it reaches zero I need it to give the update of the remaining quantity in the next…
-
0
votes3
answers5873
viewsRemove repeated lines in all aspects on Oracle
In a column REGISTER I have two lines repeated in all aspects: NOME ID EMAIL SEXO JOAO 1234 [email protected] M JOAO 1234 [email protected] M How to compare these two rows, check if all columns are…
-
0
votes1
answer80
viewsGrouping of lines Group By
I have the following appointment: SELECT distinct CAPA.COD_HOLDING, CAPA.COD_MATRIZ, CAPA.COD_FILIAL, CAPA.ID_NF_ENTRADA, CAPA.NUM_NF, CAPA.DT_ENTRADA, CAPA.DT_EMISSAO, CAPA.COD_CLIFOR, CAPA.COD_UF,…
-
0
votes1
answer14
viewsAuthenticated users
as add (authenticated users) back to GROUP OR USER NAMES in tab security guard in a certain folder?
-
0
votes1
answer844
viewsWhy does this query not work on Oracle?
I am translating a query from SQL Server to Oracle and found an error that makes no sense and I am unable to fix. The error shown is as follows:: ORA-00904: "ITM"."NRO_INT_ITEM": identificador…
-
0
votes1
answer37
viewsCharacter Explosion in Oracle
I have the client base, and the client base: COD CLIENTE 128 JOAO 129 MARIA 130 DULCE NOTA 234.123.334.128.50 235.124.338.128.49 Note that the client code is inserted in the note number, which in…
-
0
votes1
answer1784
views"is not a valid java home jdk"
I’m trying to install Weblogic 12c from a . jar. I execute the command java -jar wls_121200.jar , but CMD returns to me This installer must run using the Java Development Kit (JDK), however, C:…
-
0
votes1
answer28
viewsCreate condition in instruction
Hello, I have the following select: SELECT CONSTRAINT_NAME FROM user_cons_columns WHERE COLUMN_NAME = 'CANCELAMENTO' and table_name = 'NAVIO'; After picking the name the same goes to another query…
-
0
votes1
answer93
viewsWhat is the "function" in Oracle equivalent to a "set Generator"?
I’d like to know, what is the command on Oracle would be equivalent to SET GENERATOR GEN_ID_TABELA TO 5; (command made in FireBird) Because I would like to create a script with the inserts, but to…
-
0
votes1
answer92
viewsORACLE Date Error
Although I have many materials on the subject , nothing has helped me to solve. I am trying to make a simple query in an oracle database and get an error, follow the error. OCIStmtExecute:…
-
0
votes1
answer478
viewsOracle plsql email attachment file will empty
I have the PLSQL block listed below, the email is sent but the file that should be attached arrives empty in the destination email. Send an existing file, no ? What am I doing wrong ? Grateful…
-
0
votes1
answer605
viewsIntegrate Wordpress with Oracle
I will develop a "E-commerce" services in Wordpress, known as Woocommerce, except that I need to integrate it with Oracle, in addition to the Mysql itself that it will run... Example: When someone…
-
0
votes1
answer288
viewsHow to make a change to "Cascade" using oracle
How can I change my table ID BANDAS_E_ARTISTAS and ensure that other foreign tables also change via PL/SQL? TABLE BANDAS_E_ARTISTAS ID NOME_ARTISTICO 01 RAÇA NEGRA 02 OS MENUDOS 03 KELLY KEY 04 LUIZ…
-
0
votes1
answer367
viewsOracle does not export all tables
I am performing an export by database at a time 11.2.0.1.0 but when checking the log I realize that the tables that have no record are not exported. command I’m using to export the database exp…
-
0
votes2
answers374
viewsError inserting an image into Oracle using PHP PDO
I’m making a system in PDO PHP that records some images in the database, that same system was migrated from a database MySQL and it was working perfectly, but at the time I’m going to record the…
-
0
votes0
answers327
viewsHow to create a new database in ORACLE?
I installed oracle database, oracle client e sql Developer num windows 8.1 64 bits. With the installation of the oracle database, a database was created at localhost:1521 But now I would like to…
-
0
votes1
answer148
viewsHow to suppress Oracle input window without using set define off
I need to insert an image in oracle using php, but after I convert it to insert into the database, it gets some characters & in the middle of the string, this character in Oracle triggers an…
-
0
votes0
answers73
viewsDatabase connection error
When trying to make a connection to the dodo bank I have the following error: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@delphix-db-1.homolog.infra:1521:BRMQA10 at…
-
0
votes1
answer92
viewsCould not read from remote Repository
I created a BARE repository in the folder: c://projetos/cliente1 this in the VMBOX ORACLE that is called (vmserver) then when time access from real pc, returns the following message: $ git clone…
-
0
votes2
answers343
viewsjava.lang.Noclassdeffounderror
I am locked in a project that should be a "bank", with an account and transaction CRUD. I have to use Oracle bank because of the facul. This error happens when giving an input to the bank.…
-
0
votes1
answer357
viewsHow to mount an Inner Join by filtering through a field with minimum value?
I wanted to ride a inner join that brings only the values filtered by a minimum value field select min(data_vencimento) from pagamento where cod_situacao = 3, cli.cpf, cli.nome, con.data_inicio,…
oracleasked 7 years, 5 months ago Marcus Vinicius 59 -
0
votes1
answer76
viewsHelp in SQL ORACLE query
Column DEPENDENCY: T - Titular; E - Esposa; F - Filhos; FA - Filho Adotivo As table above, how do I bring data only of CEP S that are divergent as the CEP of the Holder: Titular Admilson has 2…
-
0
votes1
answer74
viewsError nullpointer when query in database with parameter
When I run the query below I have a nullPointer error. @Query(value = "SELECT * FROM x WHERE USER_NAME = :name", nativeQuery = true) DataBaseCobilling findByCdIdent(@Param("name") String name); But…
-
0
votes1
answer100
viewsUse conditional to check dates if not in a search column with null value
I have the following tables in BD Oracle 11g irrigation ---------------- militet_applied, close_date rainfall --------------- rain_index, reading_date And I would like to make a select similar to…
-
0
votes1
answer1280
viewsChange date column to timestamp
I have a table with a column like date but I need to see the GMT information, my idea is to convert it to timestamp. How can I change that even if the column already contains value? create table…
-
0
votes0
answers72
viewsValue shown in production other than development
I have an application in ASP.NET MVC with the Entity Framework with an Oracle database, and the same one showing some wrong data, and this happens only in production, in Debug(locally) the data is…
-
0
votes0
answers28
viewsASP.NET MVC project using Entityframework
Guys, a very beginner question, I did an ASP.NET MVC project using the Entityframework, I did using the standard Unitofwork: public class UnitOfWorks : IDisposable { // Context private AgendaContext…
-
0
votes0
answers48
viewsreplace null with previous oracle value
I intend to replace a null value by the last value before that null or nulls. using LAG in cases where I have 2 nulls or more only makes the replace in the first null. COL1 is the key, COL2 is the…
oracleasked 7 years, 7 months ago user26858 -
0
votes0
answers265
viewsHow not to convert an exponential number to decimal?
Guys I’m having the following problem: I created a function to put the thousand point(s) in the values you receive as parameter (VARCHAR2). This function takes integer values and values of type…
-
0
votes1
answer597
viewsHow to return zero when JOIN does not bring me a value?
I have a problem with this SQL, when I need to list a drive but SMTITMVE the code has not yet been recorded. Ai when JOIN AND A.NCODIMVEPI = E.NCODIMVEPI.and JOIN AND D.NCODIEQEPI = E.NCODIEQEPI.…
-
0
votes1
answer733
viewsHow to use iReport with Oracle?
I’m having trouble adding the oracle driver in the iReport Designer, I tried to follow some tutorials, but I was not successful. So my question is, how do I add and perform the necessary settings…
-
0
votes1
answer3654
viewsFind duplicate values in an Oracle table
Have a table in an Oracle database called MESSAGE. This table has some fields among them LOCALID and APPLICATIONNAME. Below are examples of values entered in the database LOCALID - APPLICATIONNAME 1…
-
0
votes3
answers290
viewsDoubt with Insert in Postgres Bank
I have an error message, tried several options of not getting a solution. Is there any configuration that is missing?…
-
0
votes1
answer207
viewsString problem in oracle
I am making a condition to add a field in the database, IE, will only add if the condition is equal to 0. The problem is that in my instruction execute immediate He says the word PRIMARIO is…
-
0
votes1
answer1445
viewsCompare Data Oracle
I have the following column in oracle DATA_FILTRO 01/04/2017 10:27:15 I would like to compare the month and year: SELECT DATA_FILTRO FROM TABELA WHERE TO_CHAR(DATA_FILTRO,'MM/YYYY') ='04/2017' In…
-
0
votes1
answer78
viewsORA-01843 error when importing table in Sqoop
I’m facing a mistake that I can’t understand the origin of. Previously I had imported a table with the same data format, with 54 million lines to my HDFS cluster hadoop. Now I’ve created a _View_ in…
-
0
votes0
answers104
viewsFailed to update to registry
I am having the following problem, when I try to change a registry made by my application, it creates a new record instead of changing. My question is, if when I do the trigger of insertion of the…
-
0
votes1
answer188
viewsCreate view by transforming deleting or transforming DATE into VARCHAR in ORACLE
I have a table with 58 different columns and would like to create a View treat the fields DATE as SWEEP, without me having to discriminate all the columns in the creation of View. CREATE VIEW…
-
0
votes1
answer737
viewsReturn rows with the highest value in a column
I have a problem with a query in an Oracle database in a table with 3 columns: ID_Loja | Canal | Valor_Venda There is the possibility of having more than one sale per store and I want to know which…
-
0
votes2
answers537
viewsHibernate does not close connections/sessions in BD
I’m in big trouble using hibernate. Each time I call a method that performs a query or update in the database, Hibernate opens a session in the database and then does not close. I’ve tried…
-
0
votes1
answer113
viewsleft Outer Join in a clause or
I have a problem with a query, that I need to do a left Outer Join from one table to another, or considering the values as 0, if any, basically what I was doing was the following. select B.coluna…
-
0
votes2
answers517
viewsLISTAGG function returning repeated values
I have a multi-valued field where I need the result to return in one line, trying to use LISTAGG, but it returns one value per line and each value repeated 5 x. Any idea ? I’ll paste the code so…
-
0
votes1
answer33
viewsSelection Using FROM TABLE
I have a table and a function that returns a pipeline, only the function needs to receive a data from the first table, I imagined that the selection would be something like this: Select…