Most voted "oracle11g" questions
None
Learn more…102 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…
-
4
votes1
answer334
viewsProblems importing cx_oracle in python 3.4 64 bits
I have a problem with cx_oracle in 64 bit python. I installed this version of cx_oracle: cx_Oracle-5.2.1-11g. win-amd64-py3.4. But when importing in python import cx_Oracle, the following error…
-
4
votes0
answers148
views -
3
votes1
answer1901
viewsBackup oracle tables 11g
Use oracle 11g in the free version. According to the database lessons with oracle, the free version does not allow creating database. One can create user and create tables. Based on this, how do I…
-
3
votes1
answer258
viewsWhy using a column of a virtual table makes an SQL in Oracle slow
Good. Without wanting to leave the subject too "gassy" but wanted only tips of things to investigate in the environment. I have an SQL that uses a virtual table, for a number of reasons that are not…
-
3
votes1
answer552
viewsUpdate command does not work
I have three tables in a database, and I have a method called alteraLinhaTabela where I try to update one of the three tables at a time by identifying it by the variable tabela. I also pass two more…
-
2
votes1
answer924
viewsDelete all objects from a schema
I have a database on oracle where I need delete all objects of a particular Schema, I cannot exclude the Schema, because the validation of the system is based on an algorithm that takes into account…
-
2
votes1
answer407
viewsSolution . Net with Membership does not connect to oracle base
I am trying to run a project on my computer but it accuses error in string: Oracleconnection.Connectionstring is invalid The same project works normally on the computer where it was started. The…
-
2
votes2
answers1443
viewsORA-22922: nonexistent LOB value in SELECT
I am facing a problem with two different consultations on oracle. Both have the sql snippet REPLACE(dbms_lob.substr(wm_concat(disctinct <COLUNA>)), ',', ', ') The error that returns is the…
-
2
votes3
answers124
viewsReturn only the time in Select
How do I return only the time in Select? I declared the time as TIMESTAMP, in this case returned the date and time, but I want to return only the time. So I declared only DATE and now the time does…
oracle11gasked 7 years, 10 months ago Elaine Xavier 41 -
2
votes1
answer3406
viewsTNS-03505 - ORACLE tnsping
While trying to drip, using the tnsping. ex: tnsping UMEXEMPLO The following error appears to me TNS-03505: Failed to resolve name Which solution usually applies? EDIT: From other machines we…
-
2
votes1
answer4598
viewsexport oracle database 11g sqldeveloper
The point is, I have a local database, where I already have the structure and data in the respective tables that I need. I want to export this database to another machine, with exactly the same…
-
2
votes1
answer209
viewsHow to create a query with a non-existent and error-free table
I have a query that runs in several different schemas in the database, and there is a specific table that only some schemas have, and if there is the value returns. SELECT t.coluna1 ,t.coluna2…
-
2
votes1
answer448
viewsDecrease SQL database size [Oracle] - ORA-12953
I am working on a local Oracle XE database. But it has reached the 11 GB limit. ORA-12953: The request exceeds the maximum size allowed for the database, which is 11 GB. It turns out I deleted…
-
2
votes1
answer342
views -
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
votes2
answers62
viewslast table record change using MAX function
I’m trying to bring all the records of a table by taking the last change so I used the MAX() function but it’s not returning any results. These are my terms: SELECT DISTINCT U.USS_CODIGO,…
oracle11gasked 8 years, 5 months ago Alan Darold 33 -
1
votes1
answer73
viewsHave I enabled a PHP extension and a Warning appears?
I enabled the extension php_oci8_11g.dll but I get the following warning. PHP Warning: PHP Startup: Unable to load Dynamic library 'C: php ext php_oci8_11g.dll' - %1. I’ve reinstalled the PHP…
-
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
answers4867
views -
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
answer6120
viewsRun script file directly in PLSQL
I have a arquivo.sql, which has thousands of lines of scripts, containing, creations, changes, etc. I need to run this file directly in PLSQL at SQL Window, and nay can be via Command Window. Via…
-
1
votes1
answer96
viewsOracle , parameters of procedures of an Owner
On Oracle which table or view of metadata I have the parameters of a Procedure. My question is , that procedures HAS parameters with the name similar to "XPTO" ? I tried for the "Dict" but I…
-
1
votes2
answers579
viewsPermissions for an Oracle USER
I am creating an Oracle user for my database, after setting the basics I tried to run my script to create the tabelas and sequences, however, the tool returned me an error saying missing…
-
1
votes1
answer127
viewsConstrait Oracle Garden
I have a question, when I create a CONSTRAINT UNIQUE , she measures all the columns together? For example, I want a country not to have names or acronyms equal, in which case I must create…
-
1
votes1
answer2196
viewsHow to call a "Stored Procedure" oracle c#
I have the following Procedure in my bank: I’m trying to call my store Procedure in the .net in this way: public int CountEvent(int resourceId, int eventCounterDefinitionId, DateTime startDate,…
-
1
votes2
answers189
viewsI cannot connect jsp page to Oracle bank
This Web project of mine worked at school, but on my computer it won’t.. It was to return "connected in the oracle database" and returns "oracle.jdbc.driver.Oracledriver " Code class connection:…
-
1
votes1
answer1397
viewsUser permission in Oracle tables
There is a way to know which tables a particular Oracle database user is allowed to select?
-
1
votes2
answers2342
views -
1
votes1
answer574
viewsDropper my schema tables on Oracle
I am using a Schema in Oracle (sql Developer) and within my schema there are already several tables created that I was using earlier. Now running a new script in this scheme it shows the following…
-
1
votes0
answers28
viewsSrcset0 task failure (Loading) on MICROSOFT_EXCEL ODBC source
Good morning, I’m trying to configure oracle data Tegrator to read an excel spreadsheet in xls and xlsx formats, but I’m having problems and I can’t find a solution! it returns me the following…
-
1
votes0
answers206
viewsOracle - Lock preventing SELECT
Lock preventing SELECT The situation is as follows : An ERP application (Totvs) with multiple tables All these tables use as primary key a standard field R_E_C_N_O_ The application (I believe)…
-
1
votes0
answers42
viewsDifferent results 'Count(*) from V$ASM_DISK'
I have a script that connects on an Oracle basis and makes the following select: select count(*) from V$ASM_DISK; This script is in a . sql file, then I make the following call in the OS:…
-
1
votes1
answer106
viewsHow to convert JSON to XML in ORACLE 11g?
Good afternoon, I have a problem at work. Need to create a Function in oracle that performs the conversion of json to xml and show the result as table. I know version 12 of oracle does this easily,…
-
1
votes0
answers54
viewsVisual Attribute in Oracle Forms Personalization
I’m having a problem with the Forms Personalization, I am a beginner in Oracle EBS and Forms Personalization. I need to change the background color of my item, but when I use the property…
-
1
votes1
answer33
viewsPerform schema import by changing Grant and synonym
In one environment I have 5 schemas that make grant and synonym among themselves, of which they are already working. Now I need to duplicate that default environment for the customer environment,…
-
1
votes1
answer287
viewsWhat exactly is the UTL_HTTP (ORACLE) SET_PROXY Proxy
utl_http.set_proxy(http://pgau:abcd@[email protected]:5678'); In this example what exactly this Proxy address ? I tried the internal IP and it didn’t work , the below my company said not to have…
-
1
votes1
answer40
viewsRecover from Oracle Dump
I received an Oracle 11g database for analysis, but the dump file is in format .datp . I couldn’t find any reference anywhere on the internet about this type of file. The client’s instructions are…
-
1
votes0
answers99
viewsHow to list a group of coordinates(latitude, longitude) in an Oracle 11g SQL table in a radius
I need to list a group of coordinates in a radius of 500m. I have a name table TB_COORDENADAS, with the columns LATITUDE and LONGITUDE. I wish to point out a coordinate (lat, lng) and list all…
-
1
votes0
answers61
viewsCode problem - SQL Developer
The following tables present error: CREATE TABLE REQ_ROB_EQP ( REQ_PER_ROB_ID NUMBER, REQ_EQU_NOME VARCHAR(100), CONSTRAINT REQ_ID_NOME_PK PRIMARY KEY (REQ_PER_ROB_ID, REQ_EQU_NOME) --CONSTRAINT…
-
1
votes1
answer63
viewsValues of the IN clause as a parameter for in a column subselect
I need to pass all the values of a clause IN, for a subselect one-column. Ex: SELECT distinct 'Atendimentos' Tipo, to_char(A.DT_ATENDIMENTO, 'mm/yyyy') Competencia, pre.cd_prestador, se.cd_setor,…
-
1
votes1
answer194
viewsChanging the character of the vehicle registration plate - Mercosur standard
In the Oracle database, I have the table (Tab_plavei) with the string field (Plavei), format UU9999. I need to adjust this field to the new standard of Mercosur boards, format UU9U99. I’d like to…
-
1
votes1
answer28
viewsInclusion of First Record using a select SUM
In certain routine I have a Trigger that runs a code similar to the one below. I’m having trouble in the first record, as in the first record does not have any code, the sum of + 1 is not being…
-
1
votes0
answers38
viewsError running Oracledatareader.Hasrows with cursor without values
I am using Oracledatareader to insert elements of a cursor into a list. The cursor is returned from an oracle db procedure. The problem is that when I have no elements returned on the cursor, the…
-
1
votes1
answer69
viewsGENERATE A SELECT WITHIN A PROCEDURE
Good evening, everyone, I’m trying to make a select within an ORACLE database, only I’m not getting it. Below is an example of code I’m trying to generate. CREATE OR REPLACE PROCEDURE TRAZNOMES IS…
-
1
votes3
answers249
viewsDOUBT IN SQL -TURN ROWS INTO COLUMNS
I got this one query, it brings to the same product 3 rows of result, wanted these results to be returned in columns, how to do? SELECT CODPROD, EMB FROM TABELA WHERE PRODUTO = 2 this research…
-
1
votes1
answer411
viewsWhat is the solution to the error below?
I am doing a test with some tables, and I decided to do a test with the following command : select 1 from dual where sysdate between trunc(:dt-inicio,'dd') and trunc(:dt-fim,'dd'); select 1 from…
-
1
votes1
answer53
viewsHow to Migrate Oracle 11G Long Raw Columns
I need to migrate information from a column of type long raw oracle 11g. CREATE TABLE PROD_IMAGEM ( ID NUMERIC(8), IMAGEM LONG RAW ); CREATE TABLE BKP_TAB_IMAGEM ( ID NUMERIC(8), IMAGEM LONG RAW );…
-
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…