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
-
1
votes1
answer3140
viewsGroup values of different columns into one, comma-separated
I got the following select: SELECT DISTINCT ORGAO, UNIDADE FROM TESTE Where the following result is generated: Órgao Unidade 1 2 1 3 1 4 1 5 Four records of the same organ are returned, but with…
-
1
votes1
answer798
views -
1
votes2
answers4728
viewsHow to do WHILE in PL/SQL
I need to make a WHILE in SQL. Follow the code I’ve tried DECLARE CONT INT; SET CONT=0; WHILE CONT < 3 BEGIN SELECT CONT SET CONT = CONT +1; END; The error that arises is as follows: Erro a…
oracleasked 8 years, 1 month ago Gustavo Freire 87 -
1
votes1
answer469
viewsInsert a select with more than one result
need to execute the following command on an ORACLE DB: Elaborate a select that returns more than one result and the result of this select needs to be used to make an Insert in multiple lines. Ex: my…
oracleasked 8 years, 9 months ago Fernando Kowacic 21 -
1
votes1
answer679
viewsConversion of Oracle to Sqlserver
Context: Currently I work in a system that uses the database oracle, but now I’m going to need the system to use sqlserver. My goal is to convert DDL and DML for sqlserver, I see there are some…
-
1
votes1
answer959
viewsHow I list the Packages in the oracle
How do I query(PL/SQL) to list a specific Package existing in the database(Oracle)?
-
1
votes1
answer447
viewsTable Analysis with Execution Log
I have a table in Oracle 11g with the following structure: CREATE TABLE USER.LOG_EXECUCAO ( ID NUMBER, DATA DATE, QTD_REGISTROS_INSERIDOS NUMBER, TEMPO_EXECUCAO VARCHAR2(50 BYTE) ) An example of…
-
1
votes1
answer645
viewsSUM STRING AS DATE - Oracle
I have the spine TEMPO like STRING and I need to add the values as hours. I used all kinds of query to make this sum, but I always fall into the field problem with DATATYPE DATE not accept values…
-
1
votes3
answers93
viewsJoin with two tables and a varchar2 field
Hello. I am using oracle 11 g. I’m trying to search a state table for a particular city. For example, the state of Bahia has several cities. If Salvador is informed, he must return to the state of…
oracleasked 7 years, 12 months ago André Nascimento 1,258 -
1
votes2
answers93
viewsGroup views in SQL Oracle
I’m having a little logical reasoning block. I have a table (Tabela1) organized this way, but I would need to return the query as the table2 below. Someone can help me?…
-
1
votes1
answer983
viewsException SQL Oracle - Update and Insert
I have a question regarding a precedent that I am making oracle bank. A small explanation for what I am doing: I am reading data from a table, and throwing them on a cursor, after playing on the…
-
1
votes1
answer54
viewsDoubt with "pivot" ORACLE
I would like to know how to put the fields CODIGO_PROCESSO, NOME_PRODUTO_PROCESSO and APROVADO_USO in the main select to show in my query SELECT CODIGO_PROCESSO, MAX (DECODE (tipo_arquivo, 'BT',…
-
1
votes2
answers3651
viewsThe 'Oracle.DataAccess.Client.Oracleconnection' type initializer triggered an exception with c#
My wpf program worked very well. They moved it to make some changes. Well, they asked me to change some folders in the application. Before I make any changes I went to run the application and is…
-
1
votes1
answer1031
viewsHow to set a maximum size for a BLOB field?
I want to insert images and I want each record to have at most 100M, if this value is exceeded should be returned an error in the database itself. For example illustration of the problem: (in the…
-
1
votes3
answers1184
viewsRead an Array or Bulk Collect as a table in an Oracle PLSQL
How to load an Array or Bulk into a PLSQL and then read this as a table. Example DECLARE VA_ARRAY ....DEFINIÇÃO DO ARRAY VN_QTD NUMBER; BEGIN -- TABELA01 É UMA TABELA FÍSICA EXISTENTE NO BANCO…
-
1
votes1
answer150
viewsTo display the day of the week of any date in the last 1,000 years
I used this command select to_char(to_date('18-apr-1972','dd-mon-yyyy'),'day') day from DUAL; but gave error in execution: ORA-01841: ano (completo) deve estar entre -4713 e +9999 e não pode ser…
-
1
votes1
answer285
viewsHow to use an Oracle database and Sql Server simultaneously with Entity Framework 6 in a single application?
I am developing an application where the information will be persisted in two databases, one MS SQL Server and one Oracle. I have no option to use both banks in the same DBMS, because the Oracle…
-
1
votes1
answer431
viewsQuery to turn columns into records
I have a query that involves several tables in Oracle, and returns a large number of columns. I wanted instead of returning the records of this query, return me the columns of select as records. An…
-
1
votes1
answer1799
viewsDuplicate records in SQL - Oracle
Good morning, I’m new here and I’ve got a boring problem. Distinct does not solve my problem because the duplication is due to the fact that I had to make the relationship with other tables to seek…
-
1
votes1
answer1291
viewsDynamic access column oracle cursor
I have a situation where I need to access the attributes of a cursor differently. I have a cursor that returns me a list of records, with columns like col_1, col_nova, col_teste (illustrative…
-
1
votes0
answers30
viewsThe parameter I use is not returning anything when running proc in test by package
I have a precedent that when I consult her I have the right results. However, when I pass parameters in plsql Debug it does not consider the field in question. The field is the same type of table…
-
1
votes4
answers541
viewsConcatenate 2 PHP variables into SQL statement
I am developing a PHP system with Oracle and to "optimize" an update, I would need to concatenate a variable (with values from 1 to 3) in the name of the variable that I will pass in the…
-
1
votes1
answer394
viewsIgnore group date/time field by
I have the following query: Select msi.segment1 codigo, msi.description descricao, pcn1.quantidade Qtde_Romaneio, nvl(SUM(pcn2.quantidade),0) Qtde_Coleta, (nvl(sum(pcn2.quantidade),0) -…
-
1
votes2
answers604
viewsWhat is the Connection String used to make the connection between Cobol and B.D. Oracle?
I can’t connect a Micro Focus program Cobol and the database Oracle. I’m using the remote: EXEC SQL CONNECT :USERNAME IDENTIFIED BY :PASSWD END-EXEC The error that returns me is: Please specify…
-
1
votes1
answer4141
viewsChecking that the value of the database column contains only numbers in select
I need to find out if the value of a given column of the database contains only numbers in the select itself, because if it is numerical, I need to display the value of another column. I use an…
-
1
votes2
answers282
viewsRegular Expressions in Oracle
'Select from CITIES tables only records with composite names separated by a single space' TABLE CIDADES ID CIDADE 01 SAO PAULO 02 RIO DE JANEIRO 03 SAO CARLOS 04 TAUBATÉ 05 SÃO JOSÉ DO RIO PRETO The…
-
1
votes1
answer340
viewsOracle End of file when running
I’m getting the following error message when running this trial *Encontrado simbolo "end of file" quando era esperado:* DECLARE -- LOCAL VARIABLES HERE I INTEGER; BEGIN FOR NCM IN (SELECT * FROM…
-
1
votes2
answers242
viewsHow to add several decodes in the same line?
I need to group the fields of the Code in the same line some hint follows SQL SELECT DISTINCT iTG.GUI_NUMERO " NUMERO GUIA ", DECODE(itg.pro_tipo_procedimento,'MAT',…
oracleasked 8 years, 1 month ago Alan Darold 33 -
1
votes2
answers796
viewsError Installing Weblogic Oracle
I am trying to install Oracle Weblogic, but in the installation process appears the message: C:>java -jar fmw_12.2.1.0.0_infrastructure. jar The driver log file is C: Users Wagner Appdata Local…
oracleasked 7 years, 7 months ago Wagner Dlugosz Donato 31 -
1
votes1
answer44
viewsEncountering Problem Bank Connection with Visual Studio
Hello, does anyone know if you have any way to find problematic c c# code related to opening and closing database connections? I have an application that after a few hours processing a load when…
-
1
votes1
answer96
viewsHow to delimit a phone field (Oracle Database)
Good morning, I am in need of a help to delimit the phone field in my database, being more specific, if today someone type a phone number with 4 digits (for example) that phone will be saved, I need…
-
1
votes2
answers718
viewsSELECT that brings products active in one company and that are not active in all others
I have a table that shows products that are Active (A) or Inactive (I) in 16 branches. IE, has 16 lines for each product. I want to select all products that are Active (A) in Enterprise 16 and at…
-
1
votes1
answer723
viewsGet Return of Procedure on Oracle
I need to run a database (Oracle) that returns me a character (S or N), I’m using the ODP.NET driver, I tried everything and could not do it, including I looked at several answers right here in S.O…
-
1
votes1
answer86
viewsCharacter difference enconding Charset Difference using JPA but not with Prepared statement
I have an application using spring boot + oracle (via Tomcat datasource). Using spring-data, a simple query in a table returns encoding problem characters. This same application, in a very specific…
-
1
votes1
answer45
viewsConversion of a Date to Character sub-query in Oracle
i have a sub-query returning dates this way: SELECT DISTINCT DT_EMISSAO_NF FROM DANFE ORDER BY DT_EMISSAO_NF DESC And, starting from this query, I need all dates returned to be converted to…
-
1
votes1
answer87
viewsMake a select according to an indexed table
I have a table, getSalas, that simplified is something like this: CREATE TABLE getSalas( ID_SALA NUMBER(4), NOME_CARATERISTICA VARCHAR2(20), VALOR_CARATERISTICA NUMBER(4) ); The contents of this…
-
1
votes0
answers195
viewsView button after Ubmit from oracle page Apex
I have a test page on https://apex.oracle.com/pls/apex/f?p=43921:2 user test password test, which already working ok, in general. It migrates employees using a shuttle object, and using Collections…
-
1
votes1
answer428
viewsAdd values and subtract values from another condition
Good afternoon I have a table named TITLE In it I have columns with name CODOPERACAO, VLROPERACAO, DTAOPERACAO I have 2 different records of CODOPERACAO that are: 16 = Inclusion of title 28 =…
-
1
votes1
answer13964
viewsIF condition inside an Oracle SELECT
There are other questions in this context, but I am a layman and do not understand. With this, I need help. I have a SELECT for searching data in a database ORACLE, but I must make a condition IF…
-
1
votes2
answers630
viewsRemove double quotes in codeigniter query Builder
I am using the Codeigniter framework and every time I create a select with their Builder query, it puts double quotes on all columns and tables. Ex: SELECT "ID", "NAME" FROM "STUDENT" This ends up…
-
1
votes1
answer152
viewsFirebird GEN_ID() function equivalence in ORACLE
Speak guys, I’m starting learning with BD Oracle, before I used Firebird. However I’m having a problem that I’m not able to solve. I can not include a new country by the system (java), if I insert…
-
1
votes1
answer1364
viewsOCI8 in PHP 7.0 with Xampp 32bit
I’m using xampp in windows 7, PHP version is 7.0.15. I installed the Oracle Instant Client (32bits tbm) and then extracted in the "ext" php folder version 2.1.3 of OCI8 according to this site…
-
1
votes0
answers40
viewsHow to make Linked server with Oracle database for SQL Server 2008 (and considering VPN connection)?
I need to create a Linked Server connection to my client’s SQL Server 2008 database. This Linked Server will be with an Oracle database. My SQL Server 2008 database is in a server of my client. The…
-
1
votes2
answers2803
viewsFile storage, database or disk?
I am developing an intranet system, with a file storage module (exclusively PDF). What you tell me about the storage location, save to disk on the server or in a database? Remembering that it is an…
-
1
votes2
answers872
viewsUpdate only in one column character - Oracle
I have a column, where this written R. TEST, I just need to make a correction leaving for STREET. TEST, how to make this change in the Oracle database.
-
1
votes1
answer78
viewsDifficulty assigning value in plsql
In a college exercise the following was requested: In a presidential election there are three candidates. Votes are by code. The data used for screening are codified as follows: 1, 2, 3 = votes for…
-
1
votes0
answers158
viewsOracle physical database file
I’m having the same problem with that question : Where SQL Developer saves the BD file? more like I have no points to comment on, and ask right there, start a new "topic". I tried to do the way the…
-
1
votes1
answer319
viewsError compiling function in oracle
When trying to compile the following Function: CREATE OR REPLACE FUNCTION f_id_fornecedor(Nomefornecedor in varchar(50)) RETURN integer IS codigoforncedor integer; BEGIN SELECT codfornecedor INTO…
-
1
votes1
answer1642
viewsDoubt in select with group by and Count?
I’m making a SQL in 2 tables in Oracle and would like to group the information according to the job code and also count how many people are in that position. I’m using the following SQL: select…
-
1
votes2
answers566
viewsSelect with re occurrences of a period record
I need to know if a record occurred again in a 7-day period. For this, I count with a table that saves the records and the occurrence date. For example: Registro: x | Data: 13/03/2017 Registro: y |…