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
answers44
viewsOracle.DataAccess.Client.Oracleconnection is not defined
I need help because I can’t go on because of the message Oracle.DataAccess.Client.Oracleconnection is not defined. How can I solve this problem? I’m using Visual Studio 2015.…
-
0
votes1
answer50
viewsCreation of multiple dynamic lines in an oracle table
I need to create a new table with multiple rows using data from a previous table as parameter. For example _______________________ | nome | quantidade | |--------|------------| | xyz | 2 | | abc | 1…
-
0
votes1
answer257
viewsHow do you set the order by command?
I typed the following command in the oracle; select * from emp where ndep in(10,30); and had it as a result; he’s all right, the problem is I wanted to put him in the descending order of the…
-
0
votes1
answer266
viewsSELECT of 2 FK in the same table
In view of this scenario: Imagine a scenario in the field of oceanography, where the table_A , in addition to the primary key, also needs to keep the direction of the wind (dir_wind) and the…
-
0
votes0
answers419
viewsPHP and Oracle error - oci_execute
I have a packcage with the following SP: procedure sp_WEB_PECAS_OBJTV_LOJA( pPECAS_OBJTV_LOJA_ID in WEB_PECAS_OBJTV_LOJA.PECAS_OBJTV_LOJA_ID%type, pPECAS_OBJTV_LOJA_COD_EMP in…
-
0
votes1
answer82
viewsCheck for UK before creating a
I have the following query: alter table FINALIDADE_OPERACAO_MODAL add constraint UK_t127pwh154arjh5whq0g4dlrm unique (NOME); As I create a function that checks if it exists before, and if it does…
-
0
votes1
answer48
viewsSelect turning different records into single
I need to make a select by unifying two different rows into one, with two new columns. I am using bd oracle and there is no possibility to update the tables. Example:…
-
0
votes2
answers2429
viewsSelect on Oracle - Java
I’m trying to run a connection test in the database and extract some information, just Sfor study even, but I’m bumping into the following error: Exception in thread "main" java.sql.SQLException:…
-
0
votes2
answers1756
views -
0
votes2
answers282
viewsError entering in batch using Oraclecommand
I need to optimize a load application that runs through a database and writes to another database, but this has to be done through an application Windows Forms. I’m doing using the ArrayBindCount of…
-
0
votes1
answer819
viewsPHP function returning query in oracle database
I’m trying to create a Function in php that brings information from my Oracle database, but Function does not return any value. This Function aims to return some user data. The function is as…
-
0
votes1
answer131
viewsFilter last 3 ratings Oracle sql
I am making a report and need to filter the 3 latest supplier evaluations in case that supplier is with the negative review on the date requested in the report. Each evaluation has several questions…
-
0
votes1
answer53
viewsDisplay a list of fields, reporting movies and associates using CROSS JOIN
I have three tables, the tb_film table, the tb_actor and the tb_ator_film, I need a script that displays the list of all the actors and films with them associated, follow images to clarify And I…
-
0
votes0
answers291
viewsORA-00922 error in table creation in Apex 5
I am trying to create a table in apex5 with reference, possessing foreign key from another table and that this foreign key column is populated. But creating is returning the error: ORA-00922:…
-
0
votes1
answer202
viewsMy oracle BD search does not fetch result
I have a method, using Ado.Net to bring information from BD(Oracle 11g). There is information in table(6 records) and when run by C# no record. See the code below: public class ConexaoBanco { string…
-
0
votes0
answers78
viewsOracle Subquery (bring the 6 smallest ones)
Hi someone can give me a hand? I have the structure below, it returns 4 columns, I need to keep 6, but I got lost in "beat <>" SELECT DATA, NVL( (SELECT MIN(MINTOTIME(BATIDA,':')) FROM ABATFUN…
-
0
votes1
answer309
viewsHow to create a sub-select in oracle in a composite key table?
The table has a composite primary key, and the fields are a date (ID_DEPURACAO) and a number(SEQ_DEPURACAO). What I want to do is a sub-select that takes only data greater than a given date and that…
-
0
votes3
answers7469
viewsConnect to oracle database by command line after installation
I installed the Oracle database, but I can’t remember how I connect at the bank prompt. I think it’s System connect "password". Someone fix me, please.
oracleasked 8 years ago André Nascimento 1,258 -
0
votes1
answer65
viewsSQL in propagated data
I need to hit the SQL below for the database Oracle. The idea is to retrieve the code from the table Produto associated with the table code Matriz. In this structure, the Matriz is related to at…
-
0
votes1
answer316
viewsEmpty string return - Oracle
I have a table with a string and several fields separated by | (pipe) I need to bring each field in a column. I even got a way, the problem is that when a record does not have the field filled the…
-
0
votes2
answers48
viewsInsert error ... Values using oracle error 00936
I’m trying to make an Insert on a table and it’s always giving me error 00936 that says Missing Expression when you arrive at the command line cmd.executenonquery. Can anyone help me? Code I have:…
-
0
votes1
answer574
viewsORA-1691: Unable to extend lob segment
I am loading from one oracle bank to another bank and at the time of transferring the files from an Attachment table this error occurred after some time: ORA-1691. Reading a little I saw that it has…
-
0
votes0
answers235
viewsMultiple Database Connections - Multi-task c# executable
I have an executable that I need to run a database giant. How the processing time would be unviable if I did it in a single Thread.... Following the idea of this question, I decided to create an…
-
0
votes2
answers2379
viewsMerge 2 selects into one, showing fields
The 1st select shows the following fields: CONCAT - FILIAL - COD. PRODUTO - DESCRICAO - QNTD. VENDAS PUB. 11 - 1 - 1 - PRODUTO 1 - 10 12 - 1 - 2 - PRODUTO 2 - 20 13 - 1 - 3 - PRODUTO 3 - 30 2nd…
-
0
votes1
answer84
viewsCreate user using a Function
someone could help me, she keeps giving error when saved '-' Error(19,5): PLS-00103: Encountered the Symbol "CREATE" when expecting one of the following: ( start case declare quit for goto if loop…
-
0
votes0
answers88
viewsList only the largest age group?
I am trying to do an age comparison to list only the age corresponding to your age range. Ex: 20 years age range from 0 to 43. SELECT DISTINCT U.USS_CODIGO, t.con_codigo, t.CON_SEQUENCIA,…
-
0
votes1
answer1375
viewsHow to upload data to CSV in oracle SEM SQL Loader?
Data from a table was exported in a CSV file and I would like to import it into a table in the Oracle database. But I need it to be without the sqlldr command. Because this load will be done in…
-
0
votes0
answers36
viewsSQL DATE EXECUTION - ODBC
I am doubtful in the date format that ODBC performs. I tried every way and nothing. This Query performs normal if I insert only the code, but when I want to enter dates it does not execute. I…
-
0
votes1
answer4240
viewsInsert Oracle column after an existing column
I need help. I have the table USUARIO, where I have the columns LOGIN, SENHA but need to include the column called DATACRIACAO, but I would like to know how to insert this column DATACRIACAO after…
-
0
votes1
answer147
viewsHow to Save Radiobutton to Oracle
How do I save only the marked Radiobutton? Images below what I did. He’s saving one value, even though I marked the other.In my database I have to create a single field to save any of the…
-
0
votes2
answers2106
viewsFilter date by hour intervals to the last possible time within the same day
The rule All records that are within a 1 hour interval should be counted as 1 records only. Dice ID DATA 1 06/07/2017 09:20:35 2 06/07/2017 10:20:35 3 06/07/2017 10:25:30 4 06/07/2017 10:40:35 5…
-
0
votes2
answers158
viewsQuery to return specific values
On my table IDENTIFICACAO_PESSOA I have a column called IDENTIFICADOR. This column receives CPF values. However, there are values there that do not correspond to CPF, that is, they are outside the…
-
0
votes0
answers87
viewsHow to create a link variable in Oracle with php
I need to create a link variable to use at runtime with PHP on Oracle, how can I do this?
-
0
votes1
answer241
viewsReduce character size with PHP
I need to decrease the character size from 17000 to 4000 with php, how to do this compression, and then be able to decode again to the normal string size, I cannot lose characters after decoding…
-
0
votes0
answers320
viewsHow to save an image base64_encode with more than 4000 characters in Oracle using php
I am trying to insert a base64_encode image with php in Oracle, but at the time of the Insert it returns me the following error: ORA-01704: too long string literal. The reason to return this error…
-
0
votes1
answer97
viewsHow to Import Dump with 2 Schemas for Different Dataspaces
I have a Dump with which it was made expdp with 2 schemas. I’d like to do the impdp remapping the tablespace for 2 new tablespaces. Man parfile current: userid=dba/dba@streetfight…
-
0
votes1
answer392
viewsAccess permission for a PHP + AD + Oracle system
Good morning, I’m new to PHP and I’m starting a system for the company I work for, generating reports. Currently my PHP code authenticates with an Active Directory normally, and when connecting, it…
-
0
votes1
answer46
viewsHow to add many customers at once in a database table?
I need to add Name, Phone and Address of many clients who are in excel and pass this to the database. What would be the fastest way to do that ?
-
0
votes1
answer805
viewsHow can I apply Unpivot to a simple select, I want to leave a query upright
According to the code below: SELECT 1 DADO1 ,2 DADO2 FROM DUAL I would like to leave the search results vertically, I am beginner in Oracle, I saw that to do with unpivot but I did not find a simple…
-
0
votes1
answer99
viewsSerialize the result of a JSON query?
I am adding the result of a query to an array and am trying to serialize to Json. I’m not getting my printing right JSON, could help me? My code: <?php ini_set('max_execution_time', 123456);…
-
0
votes1
answer193
viewsSplit List with more than a thousand lines - . NET
I’m getting an error while performing this select sb = New StringBuilder sb.Append(" SELECT ") sb.Append(" SE.NU_SERIE_NF, ") sb.Append(" SE.NU_NF, ") sb.Append(" SE.DH_ENTREGA, ") sb.Append("…
-
0
votes0
answers80
viewsWhen I run Update the eclipse for execution
When arriving at the part that executes the following query the system stops and does not proceed to the next line. @Query(value = " UPDATE COOBILING_NUMBER SET CONDITION='Used' WHERE NUMBER_PHONE=…
-
0
votes1
answer823
viewsI can’t start the oracle system
I’m trying to install Oracle on a linux machine to be accessed on Cobol. sqlplus is working, I can execute sql commands. While trying to start the Oracle System, I am getting the error: Message 1070…
-
0
votes1
answer235
viewsIs it possible to use the same column name as a parameter name on a cursor?
I have the following cursor: -- CÓDIGO OMITIDO DECLARE CURSOR CUR_AULAS(IDTURMA NUMBER) IS SELECT ID, IDCLIENTE FROM AULAS WHERE ATIVO = 1 AND IDTURMA = IDTURMA; It will always return true because…
-
0
votes1
answer204
viewsSelect two hour fields where one of them goes past midnight
I have two tables with the following scheme: data | hora ini | hora fim -----------|------------|--------- 16/08/2016 | 1115 | 1319 16/08/2016 | 1320 | 1419 16/08/2016 | 1420 | 90 Being that in the…
-
0
votes1
answer1114
viewsError creating a simple table in Oracle SQL Developer
I’m having trouble creating the following table: CREATE TABLE T_AM_OME_ADVOGADO ( cd_pessoa NUMBER (8) NOT NULL , nr_oab NUMBER (8) NOT NULL , nr_cpf NUMBER (11) NOT NULL , nr_rg CHAR (10) NOT NULL…
-
0
votes1
answer1446
viewsWhere does SQL Developer save the BD file?
Where are the banks I create in SQL Developer saved ? I wish I could choose the location/folder to save the Bank, but I don’t know where it is saving.
-
0
votes1
answer249
views -
0
votes1
answer202
viewsORACLE RANK() function
Could someone explain me what is wrong with my syntax/use of the RANK function? Problem situation: "Rank songs by band so that songs of higher duration occupy the first places. Present band name and…
-
0
votes2
answers717
viewsSearch and people who have the same name, surname and date of birth
How can I perform a select on Oracle that brings all people who have the same name, surname and date of birth however, have different ID’s.