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
-
31
votes4
answers6983
viewsDelete thousands of records from a table
I have a table, for example, pessoa, and would like to delete all people over 40, with the script below do it: DELETE FROM pessoa WHERE pessoa.idade > 40; The problem there is more than 2 million…
-
18
votes2
answers7922
viewsWhat is and what is the utility of the DUAL table for Oracle?
I came across this scenario during the modification of a report in the system: One of querys is returning to this such table DUAL: select * from dual But in the system there is no DUAL table, and…
-
15
votes2
answers7839
viewsWhat is the difference between View and Materialized View?
According to Oracle documentation, a Materialized View is a database object that contains the results of a query and a View is a logical table based on one or more tables or views and does not…
-
13
votes3
answers9451
viewsWhat is the meaning of the sign || '-' || in SQL
I am performing a query in an Oracle database and come across this symbology || '-' ||, in my query. I’d like to know the meaning? Select xf0cdloc || '-' || XN4CDEMP AS LOCOMOTIVA, From Trem…
-
12
votes3
answers10354
viewsInsert with accents in Oracle
When I make one INSERT for example: INSERT INTO TESTE (NOME) VALUES ('INSCRIÇÃO ESTADUAL'); You’re saving it on the table this way: REGISTER THE STATE And on the screen displays "INSCRIÃÃO…
-
10
votes1
answer217
viewsWhat is the DIANA?
I had a database problem related to the size of an object, which returned the following error: pls-00123 program too big (Dian nodes) The problem I understood and I know what can be done, but I…
-
9
votes2
answers33949
viewsHow to catch the current year on ORACLE?
I need to get the annual year on ORACLE, but I only know how to get the current date, so: SELECT SYSDATE FROM DUAL You can manipulate it to get only the Year?
-
9
votes2
answers4809
viewsEntity Framework with Oracle Banks
I am creating an application in which will use an Oracle database, but when inserting the .edmx (Entity Data Model) I came across the following situation! I can’t create a connection with Oracle…
-
9
votes2
answers295
views -
9
votes1
answer3234
viewsWhat is dynamic SQL?
I have seen many cases where some show how to use, and others where they simply advise against using SQL dynamic. I had the following doubts: But anyway, when we should or should not use dynamic…
-
9
votes2
answers31808
viewsThe difference between COALESCE and NVL
In Oracle when we have a table that has two campuses A and B, and in selection (select) we want to show B when A is null we have two commands that present us the solution: Coalesce Select…
-
8
votes1
answer13268
viewsHow to create a JOB on Oracle?
I have the command below to perform the analysis of Oracle indexes: EXEC DBMS_STATS.GATHER_SCHEMA_STATS('USUARIO', estimate_percent=> 25); I would like to know how to schedule this command so…
-
8
votes1
answer1111
viewsHow to ensure transactional atomicity in more than one concurrent Thread in a Java SE environment using the Spring framework?
A Java SE solution, using the Spring framework, is being developed in order to parallelize the execution of a Stored Procedure in Oracle 9i, Procedure which takes as parameter one or more lines of a…
-
8
votes1
answer558
viewsIs it possible to define a connection pool for each user of an oracle database?
I searched the oracle documentation and only find ways to change this image, but nothing about creating another. Does anyone there know if it is possible what I am ordering? And how to proceed?…
-
8
votes3
answers15292
viewsVARCHAR2 field boundary size in Oracle
I got a column with the guy VARCHAR2 (4000 CHAR) and I’m testing the field boundary size VARCHAR2 in the Oracle. I thought there was a limit to 4000 bytes in the field, even if specifying the value…
-
8
votes3
answers761
viewsAbort AJAX request
I have a question. I need to cancel an AJAX request on the client side and the server side. On the client side I use the abort() var requisicao = $.ajax({ url : 'xyz.php' }); if(requisicao…
-
8
votes2
answers1132
viewsInsert sequence Oracle
Folks good night I’m wanting to insert data into a table , which has a sequence created, but when trying to insert data with nextval it presents the following error Error SQL Error: ORA-00911:…
-
7
votes2
answers6186
viewsFunction equivalent to "DISTINCT ON" in Oracle BD?
In Postgres, you can make distinct apply to only 1 select field using the DISTINC ON, how can I reproduce this function in an Oracle database? Follow an example query: SELECT DISTINCT ON (CITY)…
-
7
votes2
answers4076
viewsSimple example of how to generate an XML file on Oracle
One would have a simple example of a PLSQL Procedure (or documentation location) to generate an XML file based on a Schema (xsd), the data would be generated from an SQL query. In reality archives…
-
7
votes1
answer1438
viewsGenerate header when exporting data to excel
I did an export routine for the excel, using StreamWriter, but it causes me a problem. I can’t get the name of the columns that come in select. To make the header, I had to put it in the hand. This…
-
7
votes2
answers2995
viewsHow the Parallel hint works
One of the first things I see a crowd suggest to boost the performance of a query in the Oracle is the use of hint Parallel. What benefits/risks the use of this hint can bring, I may have problems…
-
7
votes1
answer3919
viewsHow to list every day between two dates for more than one record (Oracle)
I applied an orientation of another topic and it worked cool when you only have one record in the table with the interval, but I had problems when the same record has more than one date range. Using…
-
6
votes1
answer7768
viewsWhen to use a Unique constraints vs unique indices on Oracle?
Is there any kind of good practice and/or recommendation when creating unique vs indices constraints on the Oracle? When I should wear one and when I should wear the other? Is there a situation…
-
6
votes7
answers2949
viewsHow to use multiple SQL commands (in the case delete on ORACLE) in one line only on C#?
I made a command because of Foreign Keys, only to plug hole, but it is not working for an invalid character error, I believe it is the ";". I know I’m doing this the wrong way, so I accept…
-
6
votes1
answer401
viewsIs it possible to use timestamp without having to convert to String on Oracle?
I have a query that one of your filters is a date, it is possible to filter in Oracle with something like below? SELECT * FROM tabela WHERE campoData = '2014-02-10 15:56:00.000' Or we always have to…
-
6
votes4
answers22316
viewsSubtract two TIMESTAMP and receive the value in minutes on Oracle
Like subtrair two fields TIMESTAMP and receive the value in minutos in the oracle? DATAFIM - DATAINICIO = 2880 minutos (ou dois dias)…
-
6
votes2
answers1124
viewsWhen is it worth paying for Sqlserver or Oracle?
Databases open-source how Mysql and Postgres are so advanced that they can serve a wide variety of applications smoothly, perhaps most. (There’s Sqlite too, but this is more for when portability is…
-
6
votes1
answer5859
viewsWindows Service - ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have 2 projects (Webforms and Windows Services) in . Netframework 4 that connects to Oracle base via Obdcconnection. In the Web project I can successfully open the connection... But in Windows…
-
6
votes1
answer2639
viewsCall PL/SQL precedent with object collection
Consider the following types: CREATE TYPE meu_tipo AS OBJECT ( meu_id NUMBER(6), meu_nome VARCHAR2(200) ); CREATE TYPE meu_tipo_tabela AS TABLE OF meu_tipo; And the following package: create or…
-
6
votes1
answer523
viewsI’m not getting a Oracle file with Code First
Here’s what I’m doing: Folder Model dou Add > New Item follows pictures Then select ADO.Net Entity, give a name and ADD I select Code First and give Next Well in this step, I select , and look at…
-
6
votes1
answer1911
viewsMaximum size for database tables
What can be the maximum size that a table can have? To make it clearer: a table in Mysql, what is the maximum size it supports? And in SQL Server, Oracle, Postgresql?
-
6
votes2
answers1493
viewsSyntax difference between databases
What is the difference, in the syntax, of the following databases, for a simple query, of the type: SELECT * FROM tabela WHERE id = '1' ORDER BY nome GROUP BY nome LIMIT 1 Or, what do they differ…
-
5
votes3
answers2713
viewsASP.NET MVC5 - Asynchronous Methods in Controller
I’m developing an MVC layer for an ASP.NET system written initially in Webforms. It does not use Entityframework, so a good part of the system I had to elaborate a home solution. In order to use the…
-
5
votes1
answer419
viewsProblems using Java classes in Oracle Database
I’m having trouble using classes Java a little "complex" in the Oracle. When I use a simple class, as an example below: CREATE JAVA SOURCE NAMED "Welcome" AS public class Welcome { public static…
-
5
votes3
answers11223
viewsWhat is the MINUS command for and how it works on oracle
I’ve never seen this command before and I haven’t found it here either, I don’t know if it has another name and from the Oracle documentation I couldn’t understand exactly how it works. I just want…
-
5
votes1
answer393
viewsJPA - Registry error not found right after insertion
A question about JPA procedures, because of a mistake that happened and I’m not getting it. I’m taking care of a part of the system that feeds a card order table. It searches if the user that the…
-
5
votes1
answer8184
viewsIs there anything similar to WITH(NOLOCK) of SQL SERVER in ORACLE?
I recently discovered in SQL SERVER the option of not blocking tables for insertion while reading some data, and with this gain some performance in some specific situations. I searched, but I did…
-
5
votes2
answers2251
viewsOracle - How to force a field size on a Function return
I hope to be clear on this issue , I will define in a general way but I believe that enough 1) I create any FUNCTION that returns a VARCHAR, it does not interfere with the return 2) I create a VIEW…
-
5
votes1
answer819
viewsCalculate import time of DUMP
I would like to know, if possible, how to approximate the import time of a Dump. It could be something considering the following items: GB DUMP size. Number of Tables. Number of Records and(or)…
-
5
votes1
answer1048
viewsCan I invoke Function on a Trigger?
My Function done on Sql-Server: CREATE FUNCTION dbo.getQuantidade(@idProd char) RETURNS float AS BEGIN DECLARE @QTD float SET @QTD = (SELECT (prod.Quantidade) FROM Produto prod where @id_prod =…
-
5
votes2
answers26234
viewsSELECT INSERT in Oracle using Sesquence nextval and group by
Good morning, you guys! I’m trying to make an Oracle select using a SEQUENCE in id, but is giving error on account of a group by no select. Dry up my SQL: INSERT INTO SUP_T(ID, DESCRICAO) SELECT…
-
5
votes2
answers972
viewsRegular expression with specific ending bring 3 first characters
I am trying to make a regular expression on Oracle with the following requirement: End with a specific letter if you have this letter in the middle not searching. Return the first 3 digits of the…
-
5
votes1
answer1694
viewsThe 'Oraoledb.Oracle' Provider is not Registered on the local machine
I have a problem that is limiting my work, it is the following, I created a Webservice with a connection string to an oracle database : OleDbConnection con = new…
-
5
votes2
answers5974
viewsHow to use ALIASES in Oracle correctly?
I’m trying to select several columns from a single table, and to facilitate the process of viewing the data and making it easier to separate the columns, I decided to use aliases. But the problem is…
-
5
votes1
answer9809
viewsOracle - Filter by date
I have a column dt_atualiza_log who’s with the guy DATE in the table (is saved in format 01/12/2011 10:10:48) I’m having trouble filtering through and of my query. I’ve tried several ways, the last…
-
5
votes1
answer9144
viewsUPDATE WITH CASE SQL
Is there any way I can use more than one column of the same table in a case statement in an update? for example, I have this table with these 3 lines create table produto2( codigo int primary key,…
-
4
votes4
answers2220
viewsHow to select "1" or "2" depending on the column value, in PL/SQL?
I have a column in my TIPOCLIENTE table. It shows CPF for Individuals and CNPJ for Legal Entities. I wish at the time of SELECT come "1" to CPF and "2" to CNPJ. How can I do this?…
-
4
votes1
answer934
viewsError: Registering ? instead of special character only using browser
I am having a problem at the time of saving the data in my ORACLE database. When using my application to fill in the fields and register a string, the special characters as accents for example are…
-
4
votes4
answers33983
viewsHow to copy column data from one table to another table
I have a table called UC which has an email column, and I have a backup table of it. I need to copy the data (emails) from the table’s email column backup for the column email table uc, but I don’t…
-
4
votes2
answers375
viewsJoin of SQL tables
I have a small problem when doing a Join between two tables in SQL, I wonder if you can help me. Are 2 tables GTM_ITEM_CLASSIFICATION and ITEM_REFNUM, both reference the table ITEM, but using…