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
votes2
answers1515
viewsRemember user and password of an Oracle ODBC connection
I am connecting an Oracle database with an Access database through Oracle ODBC Driver 11.2. The problem is that every time I access the base in Access, the driver from Oracle requests…
-
0
votes1
answer1458
viewsOracle Store Procedure reading XML
I need to make a stored procedure read an XML file and write it to a table in my database, but I have no idea how to do this... Can someone help me? I have 2 hours to deliver this.…
-
0
votes2
answers336
viewsI’m having difficulty returning my ID using nextval, to later do the Insert in my table
I’m having difficulty returning my ID using nextval, to later do the Insert in my table OleDbConnection cnx = new OleDbConnection(new AdministradorDAO().conexao); cnx.Open(); string seq = ("select…
-
0
votes0
answers198
viewsTimeout for Oracleconnection
I have a function to open the connection of the banks in Oracle and in this function I want to put a time limit to the attempt to connect to the bank. I tried to use ConnectionString in this way…
-
0
votes1
answer58
viewsVoid Checkerror Oracle x IIS
Well, due to the exhaustion of my attempts to find the error, I’m going to try to get a light here with you. I apologize now if the error is too generic and does not have the necessary information.…
-
0
votes0
answers378
viewsCall Procedure sql server via JDBC which returns cursor
I am unable to call a Procedure SQL Server in java that returns a cursor. That’s possible, someone has some example ? Through Oracle, through the example:…
-
0
votes2
answers6568
viewsConnect PHP with Oracle
I am trying to connect PHP (WAMP) with Oracle but get the following error: Call to Undefined Function ora_logon() Code I am using: $db = "(description = (address = (protocol = tcp) (host =…
-
0
votes1
answer1166
viewsRun Instant with Break Lines Getting Invalid Package
I’m creating a package dynamically: DECLARE vpackageletras VARCHAR2(2000); vvalorpossuia VARCHAR2(10); vvalorpossuib VARCHAR2(10); BEGIN IF letras.possuia THEN vvalorpossuia := 'TRUE'; ELSE…
-
0
votes1
answer487
views -
0
votes1
answer335
viewsReverse engineering does not update new Oracle Data Modeler objects
I have a problem with Data Modeler. Etou using Oracle Data Modeler. I did reverse engineering to generate physical model. When I made the modifications in the database and wanted to update the…
oracleasked 9 years, 5 months ago Afonso Rodrigues 63 -
0
votes0
answers70
viewsError creating JOB on Oracle 11g
When I will create a job in oracle is appearing this error. ORA-01882: Timezone Region %s not found. How to solve this problem?
oracleasked 9 years, 5 months ago André Cabral 811 -
0
votes1
answer560
viewsHelp Dynamic Combo with javascript
I am doing some tests with PHP + Oracle and I have a doubt. I made a combo, which takes data from Oracle, and that controls a textfield. Only now I need to update one more textfield, but there is no…
-
0
votes1
answer1200
viewsHow to perform procedures within another?
I have this process where I save inside a cursor all the other procedures that need to be executed, then I go through the cursor by placing the names of the procedures inside a variable. How to…
-
0
votes1
answer3098
viewsHow to check the constraints in the bank
Hello, how do I check if my constraints are linked in the entire database? I need a query for Oracle and SQL Server.
-
0
votes1
answer4128
viewsHow to limit results on Oracle without reading the entire table?
How can I return the first 100 rows of a table without having to read all your records? My table has 4 million lines , and I’m having trouble trying to return only your first 100 lines, because…
oracleasked 9 years, 2 months ago deveduardo 11 -
0
votes1
answer222
viewsExtract value, Procedure
Initially I needed to create a precedent that would read an xml file and put the data in an oracle table, create the table, the directory, I have the following structure: create or replace package…
-
0
votes1
answer243
viewsOracle tnsping ok, spring Jdbctemplate TNS:Istener does not Currently know of SID Given in connect Descriptor
I’m facing a problem, I hope you can help me, I am developing a web application running on Tomcat using Spring-mvc and data access with Jdbctemplate, the database is Oracle 11g. Within this scenario…
-
0
votes0
answers578
viewsCreating a PHP network panel
I am with the following doubt I have an oracle database with all the names and ip of the users. I would like to use this database in this code instead of using this array? <!-- painel.php -->…
-
0
votes3
answers5145
viewsPick number after comma
Working with plsql I am dividing two numbers, and I would like to receive only what comes after the comma. Ex: 7,89111. I need only number 89111.
-
0
votes1
answer280
viewsCan I have procedures with the same name and number of parameters in the same package (ORACLE)?
I can have a package with two procedures of the same name, quantity and type of parameters just by diversifying the name of the parameters?
-
0
votes1
answer183
viewsDisplay the full list of tables on an Oracle connection with Entity
As I do in a connection to the Oracle database, show all tables. made a connection and I have over 500 tables in the bank and only shows 74, that the three I need to mount the POC that I’m doing,…
-
0
votes1
answer2545
viewsComparing data via Oracle Query
I have a table called Teste de aluno and a call Parametros I need to create a Query that compares if the test is in accordance with the Parameters The problem is that the tables are not 100% similar…
-
0
votes1
answer204
viewsMysql beginner with a lot of difficulty
Guys, I wanted to start learning MySQL, but I’m not getting started, I don’t understand the software or anything, the web tutorials don’t talk about MySQL in Mac, only in Windows. I downloaded the…
-
0
votes1
answer1939
viewsQuestions about functions and procedures within Packages(oracle)
I have a package in my bank and can’t see the source code of the procs and functions within it. Below packege code and Inside procs and functions: CREATE OR REPLACE PACKAGE…
-
0
votes2
answers670
viewsArrays in the clause 'NOT IN' WHERE
DECLARE string_valor VARCHAR2(100); lista_array dbms_utility.lname_array; contador binary_integer; BEGIN SELECT t.campo_a INTO string_valor FROM tabela t WHERE t.campo_cod = 1;…
-
0
votes1
answer71
viewsOracleexception is not fired!
Someone has already come across the following problem: When an error occurs that should be of the type Oracleexception, but in its place an exception is triggered, then the oracle treatment is not…
-
0
votes1
answer3466
viewsDisplay numerical values without scientific notation in Oracle select
I have to make several selects on Oracle using SQLPLUS displaying various information to be saved in text file. Some tables have numerical fields of type NUMBER(19). Some of these fields have values…
oracleasked 9 years, 8 months ago Izaac Silva 3 -
0
votes3
answers1649
viewsInserting column in Oracle table with conditional
I need to create a column in an existing table but need to do with a checking condition if this column already exists in the bank I did so but it throws an error: DECLARE col_count integer; BEGIN…
-
0
votes1
answer423
viewsObject in oracle giving as invalid(Invalid)
I gave one select * from all_objects where object_name = 'meu_objeto';. Well, that way, I got four lines. Two lines referring to SYNONYM and that doesn’t interest me and two more lines: PACKAGE and…
-
0
votes1
answer1155
viewsDebug Function within a package
I have a package with several functions and procs. How do I, using pl/sql Developer, debug? I would like to know how I go to the error and see what is being passed. Using the pl/sql Tests tool I…
-
0
votes3
answers476
viewsSelect Oracle returning numerous times the same result
My select works and returns the data I need, but it is returning more than 6000 times the same result. How do I get it to return the result in just 01 line. NOTE: There is only one result for this…
-
0
votes1
answer1561
viewsSelect except values (SQL / Oracle)
I need to improve this select that already exists here to perform a query where the ICCID initiated by 8995 are not returned, but I do not have much knowledge of database. How can I change this…
-
0
votes1
answer185
viewsWhen I pass date filter for the same day, query comes back empty and there is data
In my table/base there is data for the day 05/08/2015, happens that when I pass a date filter for the same day, it doesn’t work, it returns empty. If I pass like this: 04/08/2015 and 05/08/2015…
-
0
votes1
answer1963
viewsChange data from a column in the table
I need to change 1200 records only from one column in the table, generated the data in the generatedata, the rest of the columns must remain with the data, someone knows a quick way to this process?…
-
0
votes1
answer373
viewsTimezone error importing dump from Oracle 10g
My database server’s down and I need to restore a dump from a database. But when I try to run the Oracle imp tool 10g Xe it returns me the error 1882 - região de fuso horário não encontrada Follow…
-
0
votes2
answers84
viewsRunning the Procedure with date type argument on a dblink
when running the file below, via DBLINK on Oracle corporativo..UP_COP025_ASS_DMANDA_JURID_I 17444968, 1, "1", "20150806", "RJ", " ", " ", "000020" get the bug: error: Syntax error During implicit…
-
0
votes1
answer187
viewsAbout Trigger no postgres
Good guys, my problem is this, I want to make a table partitioning in postgres because a table has zillions of records and searching for it takes a lot (this table tends to grow considerably in the…
-
0
votes1
answer62
viewsDetermining value within a pivot
I have a query in which you are making a pivot and she’s bringing in the correct records per month, but I’d like to validate the amount of records per month that show only employees who have >=…
-
0
votes2
answers170
viewsUndefined Index with Oracle connection
For some reason, my code is resulting in error Notice: Undefined Index IRRAD when trying to perform a query in the Oracle database. The PHP code I am using: set_time_limit( 600 );…
-
0
votes1
answer7043
viewsSqlexception: Parameter IN or OUT absent from index:: 10
It’s the first time I’m working with connections, we’re doing a job for college on a social network, now we’re doing the method insert. My doubt, when I run the test class it returns me an error.…
-
0
votes2
answers319
viewsLike passing a Char to the bank?
How do I pass one Char to the Bank? Error Exception in thread "main" java.sql.SQLException: ORA-12899: valor muito grande para a coluna "SYSTEM"."USUARIO"."TP_SEXO" (real: 2, máximo: 1) at…
-
0
votes2
answers375
viewsHow to insert and execute parameters in a precedent in oracle 11g in vb6
PROCEDURE pr_consulta_rg_site ( p_rg_cidadao in varchar2, p_dt_nascimento in varchar2, p_rg_cidadao_o out varchar2, p_no_cidadao_o out varchar2, p_dt_nascimento_o out varchar2, p_dt_expedicao_o out…
-
0
votes0
answers43
viewsSelecting sets of JPA values
I have the following problem: I have a table with a list of values for a composite key. Following example: ID | ItemCode | Localidade | Preco ---+----------+------------+------- 01 | 001 | 001 | 3.5…
-
0
votes1
answer275
viewsCompare all records in table "A" with each record in table "B"
I am a programmer and rarely use database, I came across an unusual situation of converting multiple files . DBF and save everything in the bank on their respective tables, however some files exceed…
-
0
votes1
answer468
viewsOCI8 in PHP 7 on Linux
I’m in a bit of a pickle.. I have a server running Debian and installed Apache and PHP 7, but I am having problems activating the Oracle Oci8 connection, I followed this tutorial Installing until…
-
0
votes1
answer62
viewscreate php/oracle view
I intend to generate a view through php to an oracle database where select is done through the result of another query. This query mounts select to view: $sql1 = "SELECT TESTE FROM VIEW_TESTE";…
-
0
votes1
answer144
viewsSelf Relationship
I have a schedule of medications. In it I have: code of the medicinal product (PK) description code ans There is the possibility that we have more than one drug code for the same ans code. I need to…
-
0
votes1
answer58
viewsGroup function does not work
I have two tables. Table: Pedido Columns: IDPEDIDO, CLIENTE, DT_PEDIDO, FORMA_PGMT, CLIENTE_ID. Table: Itens_Pedido Columns: PEDIDO_ID, QT_MERCADORIAS, MERCADORIA, MERCADORIA_ID. I need to create a…
-
0
votes0
answers230
viewsPass xml as parameter to a proc is returning null
My xml may be wrong, of course. but since I’m not sure, I say: I need to pass a parameter via programming to a proc. As in my program is coming null, I decided to run directly manually first in…
-
0
votes2
answers4255
viewsTables are not shown in Oracle SQL Developer
I have several connections configured on TNSNAMES.ORA, and for some I cannot see any table if I expand the folder. The user I am connecting has access, because I do the queries and insertions…