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
-
4
votes1
answer1914
viewsProcedure oracle to copy data between tables
I need to make a trial copy of my TAB_FORNECEDOR table, everything you have in it and pass to TAB_FORNECEDOR2 table. I know I need to make a loop cursor, a commit delete before everything, can give…
-
4
votes1
answer7480
viewsORA-00980: synonym Translation is no longer Valid
What this mistake means? What actions can be taken to remedy it?
oracleasked 9 years, 9 months ago Leonel Sanches da Silva 88,623 -
4
votes2
answers3709
viewsHow do I update multiple rows of a table after it undergoes a certain change?
CREATE or REPLACE TRIGGER TG_ATUALIZA_BLOQUEIO AFTER UPDATE ON pcclient FOR EACH ROW begin if :NEW.BLOQUEIO = 'S' THEN UPDATE PCCLIENT SET BLOQUEIO='S' where codcliprinc=:OLD.CODCLIPRINC; END IF;…
-
4
votes1
answer322
viewsHow to update the result field based on criteria?
I have the following table: CREATE TABLE ALUNO ( RA NUMBER(9), DISCIPLINA VARCHAR2(30), MEDIA NUMBER(3,1), CARGA_HORA NUMBER(2), FALTAS NUMBER(2), RESULTADO VARCHAR2(10) ); And the following data:…
-
4
votes1
answer322
viewsWhat is the most efficient way to connect an Oracle BD to a Mysql BD
Having the following scenario: a simple telephony application "writes" in a Mysql BD and an Oracle BD needed from time to time to search for information in this Mysql BD. Someone already did this?…
-
4
votes1
answer4489
viewsHow to make an ajax autocomplete?
I’m trying to implement an ajax autocomplete, where I do a database search and show the input options, but I’m not able to identify where I’m wrong. Follows the code: <div class="row troca">…
-
4
votes3
answers4174
viewsRecover larger and shorter hours conditioned on dates
Inside a table containing the columns data_inicio, data_fim, hora_inicio, hora_fim need to identify within a set of records the following occurrences: the lowest start date, the highest end date,…
-
4
votes1
answer831
viewsAutomatic class generator
How do I take the BD(Oracle) entity and generate in my system a class that represents that entity? Ex: I have this entity Client ID int Primary key Name varchar(100) And now with the tool it already…
-
4
votes1
answer562
viewsView SQL at Runtime
Is there a monitor that shows me the sql script at runtime? For example, during debug, I would like to see how the script was mounted by the following code: var q = (from proc in…
-
4
votes1
answer368
viewsHow to remove duplicated rows by holding other columns
In the example below, I am interested in removing duplicates of rows in columns title and time no matter how many columns. In the example below I am interested that the query returns rows 32, 34 and…
-
4
votes2
answers1104
viewsOracle SQL result ordering
I am done the query below, which was ordered by the date of creation of the product batch. With the migration of version 11 to R12 of Oracle, the batch creation field became the migration date, that…
-
4
votes2
answers92
views -
4
votes0
answers84
viewsOracle , how the parameter no_proxy_domains of UTL_HTTP.set_proxy works
In the package UTL_HTTP , we have the method set_proxy in it a parameter no_proxy_domains , how this works. In short I want to request a URL without authentication.…
-
4
votes4
answers6919
viewsSELECT of month/year in DATES
I need select to return all the rows that were inserted in July 2010, as shown in the example, regardless of the day. How to return this query? SELECT * FROM FRCAST WHERE DATA_ID =…
-
4
votes1
answer11299
viewsCluster and Sum in Oracle
I have a customer record ID NOME GRUPO 2033 JOAO FORNECEDORES 2044 MARIA MANUTENCAO 2055 JOSE FORNECEDORES And I have a record of purchases made by each customer ID_CLIENTE VALOR_COMPRA 2033 4.000…
-
4
votes1
answer3970
viewsHow to calculate a person’s age in Oracle SQL?
I need a sql command that returns the age of the person. I have the birth date of the person in the database, I need to calculate his age by SQL.
-
4
votes1
answer4925
viewsTO_DATE(SYSDATE, 'YYYY-MM-DD') works sometimes
I have the following problem: I use the JDBC to connect with Oracle. And I call rs.getTimestamp(index) to pick up a date field. When I run the function TO_DATE(SYSDATE, 'YYYY-MM-DD') the…
-
4
votes2
answers166
viewsTablespace and data files on Oracle
A tablespace is a data file that stores multiple tables, such as a zip file? What is the relationship between tablaspace and data file?
-
4
votes2
answers75
viewsReturn a case sensitive record
I own a constraint in the bank that is all with your name capitalized. As I do a count to find the same one using the UPPER? 'Cause I want to pass the where a tiny name to return. This one of mine…
-
4
votes5
answers3132
viewsWhat is the difference between comparison operators on Oracle?
In Oracle there are several operators to make "different" comparisons, such as: <> ¬= != ^= Example: Select * from tabel where nomeTabela <> 's'; Select * from tabel where nomeTabela !=…
-
4
votes1
answer144
viewsWhy does Oracle not have autoincrement?
Assuming that it is known that Oracle has the resources of the table quence. I would like to understand why they only recently implemented the autoincrement in Oracle, since it was a feature…
-
4
votes2
answers923
viewsIs it possible to use native query + spring date for paging?
I need to make a pagination using dynamic querys because I have to do many joins, I’m trying to make only one select * to test the use of native query + spring data, but the error message is as…
-
4
votes1
answer236
viewsDifference between select a. or b
What’s the difference of doing the search by select a. or b.? Example: select --a.num_duplicata,a.data_prorrogacao,a.seq_duplicatas, a.cli_dup_cgc_cli9 as cgc9,a.cli_dup_cgc_cli4 as…
-
4
votes1
answer2217
viewsHow to Bring the 2 highest values of each different id - SQL
I put together a spreadsheet to facilitate the understanding of my doubt. How to select only the 2 "two" largest room house tuition? I only managed to bring the highest value of each room, I wanted…
-
4
votes2
answers299
viewsData Modeling: Integrity x Performance
In the company that I work for, there’s a data architecture that I’ve never seen before, and I’d like to know if this is common, or if it’s a new market trend. Just to mention the bank is Oracle.…
-
4
votes2
answers1687
viewsPL/SQL Anonymous block | PLS-00103: Encountered the Symbol "CREATE" when expecting one of the following:
I get the following error : [Err] ORA-06550: line 7, column 2: PLS-00103: Encountered the symbol "CREATE" when expecting one of the following: 'Cause I’m using a create Quence inside my BEGIN with ;…
-
4
votes2
answers72
viewsKnow which values within the IN condition are not linked to the table
Hello, I have a very simple table as an example: I also have a query that checks the existing values within the IN, example: SELECT * FROM tLetras l WHERE l.letras IN…
-
4
votes3
answers137
viewsSQL Query - ORA-01795
I need to make a report from a database query. The problem is that the query returns more than 1000 expressions and presents the following error: ORA-01795: the maximum number of expressions in a…
-
3
votes1
answer1710
viewsHow to export data from an Oracle 11 database and import into an Oracle 10?
I am having trouble exporting data from an Oracle 11 to another Oracle in version 10. I tried to copy the binary exp from old machine to new but as they are different architectures (32/64 bits) did…
-
3
votes1
answer1381
viewsDoes anyone know how to connect the oracle to codeigniter?
I’m not getting the connection codeigniter in the oracle. Displays this error: A PHP Error was encountered Severity: Notice Message: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed…
-
3
votes2
answers21001
viewsHow to resolve java.net.Unknownhostexception error
I’m trying to install the sqldeveloper and datamodeler in my Fedora 20 and I’m having trouble with following error: java.net.UnknownHostException: localdomain: localdomain: Name or service not known…
-
3
votes1
answer11313
viewsOracle 11 is expiring the passwords. How do I reset this?
I recently migrated (six months ago) to Oracle 11 and now using the command sqlplus system@INTANCIA I started to receive the message below: ORA-28002: the password will expire within 7 days NOTE:…
-
3
votes1
answer151
viewsSerialize XML and save to Oracle with C# and ADO
I wonder if there is something equivalent in Oracle for this select in SQL Server: select NickName, ExternalId1 from Basics where externalId1 = @externalId1 for xml auto, elements; And to this…
-
3
votes2
answers3307
viewsChange Oracle session to accept comma and dot number in C#
When opening an oracle connection on C#, I need you to . and the , behave according to the rule 0.000,00 a real number. I would like to know how to change this format in the open session on…
-
3
votes1
answer288
viewsView saved BMP image in Oracle in PHP
How to recover a BMP image saved in an Oracle database and display it on the screen Unfortunately I cannot store the image files on the server and save in the database only the way.
-
3
votes2
answers1252
viewsJPA, Oracle and Exception Handling
I am using vraptor 4, JPA and Oracle. But when an exception occurs during persistence the error code that Oracle generates is not coming along with Exeption. This is the Repository @Repository…
-
3
votes1
answer8490
viewsOracle Relationship Search Query
I have a program to search dependencies of records to proceed with data deletion here in the company. We support some databases but on Oracle the query is processed very slowly (about 10 to 15…
-
3
votes1
answer633
viewsHow to collect statistics in Oracle Metadata tables ?
Collecting statistics from User Tables is simple, just use the dbms_utility.analyze_schema, but you can (and can) do this for the Oracle Metadata tables ? This post, was the origin of this doubt.…
-
3
votes1
answer474
viewsHow to give a EXECUTE IMMEDIATE command on an ORACLE database from a JAVA application?
The error is when I execute: execute immediate 'update teste set num = 1234 where num = 1'; Exception: java.sql.SQLSyntaxErrorException: ORA-00900: instrução SQL inválida…
-
3
votes1
answer7688
viewsError comparing ORA-00932 dates
I’m having a problem comparing two dates in the oracle. I’m using the case method to compare the dates and at the end this should return to my table a number, which in the case represents an age,…
-
3
votes1
answer987
viewsORA-00911: invalid Character
I’m having trouble with Oracleparameter, I could not find the problem, because I can not see the sql after the assignment of the parameters... follow the code: private DataTable GetSearch() { string…
-
3
votes5
answers37379
viewsHow to update with Oracle Inner Join
Good afternoon , How do I update with Inner Join , because I need to change the field idnaoleitura = 24 to idnaoleitura = 0 where idrota in (35,45,48,53,60,68,70,79) , remembering the idrota this in…
-
3
votes1
answer219
viewsOracle 12C + Java + Xmltype
Hello, Good morning in my company we are testing the Oracle 12c. And I found a "little problem" to query a field that is the type Xmltype. We store all the nfe xml in the database, so we always have…
-
3
votes1
answer47156
viewsRun oracle Procedure
I created this protocol, but I can’t execute it. I have the following error when trying Execute: PLS-00306: incorrect number of argument types in call to 'SP_CARTAO' CREATE OR REPLACE PROCEDURE…
-
3
votes1
answer81
viewsDB oracle Closed Connection
Introducing I am developing an application and have to add data to an oracle database that is local. Using JDBC I connect try (Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@" +…
-
3
votes2
answers10071
viewsUpdate to clear entire column
I need to make a update in the database in which zero 30 thousand records, however I need to reset only the record of one of the columns. Example table: cd_product|ds_product|pr_product|dt_update…
-
3
votes1
answer86
viewsORACLE EXPLAIN PLAN, wrong values?
I’m using the explain plan of Oracle to raise some statistics and the following problem is happening: When I created the database, I created an X table with 50 Inserts. Soon after, I inserted about…
-
3
votes2
answers3054
viewsFormat CPF column with regular expression
In a table containing the column CPF I would like to format it in order to present the content properly. By appropriate way I refer to the format 999.999.999-99. It is possible to format this…
-
3
votes3
answers1451
viewsView Oracle database data via Mysql
I need to know how to have the data of an Oracle database in my Mysql database, a kind of view. I do not wish to make insert, update nor delete in the Oracle bank, I need only one select of this…
-
3
votes2
answers8499
viewsSubselect in Oracle bank
I am trying to elaborate a query and within one of my joins it is necessary to be made a subselect to ensure the integrity of the query as the example below: select t01.teste from teste t01 left…