Most voted "oracle11g" questions
None
Learn more…102 questions
Sort by count of
-
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
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
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.
-
0
votes1
answer478
viewsOracle plsql email attachment file will empty
I have the PLSQL block listed below, the email is sent but the file that should be attached arrives empty in the destination email. Send an existing file, no ? What am I doing wrong ? Grateful…
-
0
votes1
answer14
viewsAuthenticated users
as add (authenticated users) back to GROUP OR USER NAMES in tab security guard in a certain folder?
-
0
votes1
answer401
viewsFloat variable with 2 digit accuracy after the comma in sql oracle
How do I create a float variable with 2 digit accuracy after the comma in a table in SQL/Oracle. From now on, thank you.
-
0
votes0
answers327
viewsHow to create a new database in ORACLE?
I installed oracle database, oracle client e sql Developer num windows 8.1 64 bits. With the installation of the oracle database, a database was created at localhost:1521 But now I would like to…
-
0
votes1
answer100
viewsUse conditional to check dates if not in a search column with null value
I have the following tables in BD Oracle 11g irrigation ---------------- militet_applied, close_date rainfall --------------- rain_index, reading_date And I would like to make a select similar to…
-
0
votes0
answers104
viewsFailed to update to registry
I am having the following problem, when I try to change a registry made by my application, it creates a new record instead of changing. My question is, if when I do the trigger of insertion of the…
-
0
votes1
answer44
viewsFailed to update field of all records with the file path using JDBC
I am migrating pdf files stored in the database to file systems. In the code as can be seen below, I use an algorithm that generates the name of the files and saves them in a directory generated…
-
0
votes0
answers52
viewsTransform the rows of a column - SQL
Someone help me with the following question. Generate ".sql" extension file with script that transforms the lines of a column in a variable string, with its values separated by commas, for example:…
-
0
votes1
answer569
viewsHow to create a JOB in ORACLE for backup?
Good afternoon, you guys! I am still novice in the subject when it comes to sql, I would like to know how to create a JOB (or other operation that does the same) that performs a data extraction from…
-
0
votes1
answer44
viewsWhy can’t I create a tablespace?
I’m trying to create a tablespace on oracle 11g but I can’t get it to point out the error that is in this image: I wanted to understand why I can’t create!…
-
0
votes2
answers46
viewsBinary Replication with Java
I’m trying to replicate a binary field that represents an image on the Oracle. Could you tell me the best way to take this data and insert it again? The field in Oracle is LONG RAW. What kind of…
-
0
votes0
answers31
viewsProblem installing Oracle XE and PHP 7 on Windows 10
I’m having trouble solving this installation. Does it relate to oracle support for Win10? I tried several forums and I couldn’t. I’m using the Dlls directly from the pecl. But I always have the same…
-
0
votes1
answer105
viewsHibernate + JPA 5 - Java Web
I’m in need of some help in the following problem. When running my web java project on Glassfish Hibernate on every run try to recreate my tables. Minha Entity. @Entity @Table(name = "Estados")…
-
0
votes2
answers4216
viewsFunction MAX only 1 (one) record on Oracle
Could someone give me a hand in using Oracle’s Function MAX()??? I need to do a query that returns only the last record of a history table, but I need to return 3 (three) columns of this record…
-
0
votes1
answer70
viewsORACLE USERS
Good afternoon. I have two Owners on my oracle example Owner "X" and other Owner "Y". Where each has its own tables, but I want Owner "X" to be able to update, Insert and delete some Owner "Y"…
-
0
votes1
answer503
viewsRun stored Procedure in oracle database in PHP
I have the procedure "exemplo1" which receives 3 input parameters and no output parameters, as I do to execute it in PHP. In case it would be so. EXEC "exemplo1"('para1','para1','para3'); How does…
-
0
votes1
answer225
viewsOracle - Cursor
I’m studying PL/SQL and testing the use of CURSOR, but I’m not able to test an example: SET SERVEROUTPUT ON DECLARE V_NAME VARCHAR2(50); CURSOR CUR_CURSOR IS SELECT FIRST_NAME FROM EMPLOYEES; TEMP…
-
0
votes0
answers237
viewsOracle 11G XE change size tablespace system
I have following script: DECLARE countTablespaceFile integer; BEGIN SELECT count(*) INTO countTablespaceFile FROM DBA_DATA_FILES where file_name in ('/oracle/bdond/cbiep01/bdrgt/system01.dbf',…
-
0
votes0
answers440
viewsError executing a Trigger ORA-04092: not possible on a trigger
I have the following problem: - I’m not able to perform a job (Scheduling) after an Insert rescued by Trigger. Row 2: ORA-04092: not possible on an ORA-06512 trigger: in "SYS.DBMS_ISCHED", line 135…
-
0
votes2
answers292
viewsHow to use @Mappedsuperclass @Id with @Sequence Individual - Hibernate oracle
I need to solve a question of using inheritance and sequences with Hibernate and Oracle. I’m using Maven with: hibernate-core 5.1.5.Final hibernate-entitymanager 5.1.5.Final hibernate-validator…
-
0
votes1
answer203
viewsFind shift based on a given date time in ORACLE/sql
In a table X I have a date column that also returns the time, I wonder if, based on this time, I have how to create a column with the name of the turn. ex( if you have a die 20-02-2002 06:00:00 I…
-
0
votes2
answers729
viewsPower BI - Oracle SQL Query
Hello, I am trying to get data in Power BI via Query on an Oracle DB and is showing the following error. Cannot establish connection Details: "Oracle: ORA-01843: not a Valid Month" SELECT DISTINCT…
-
0
votes0
answers38
viewsDoubt Query Line - Oracle
In the query below is leaving this way. Unidade Ordem_Compra CNPJ Aprovador Sim Boavista 29021 155454878787 Ivan Sim Boavista 29021 155454878787 Romel The question is: How do I leave on a line just…
-
0
votes1
answer101
viewsSelect to join two Father and Son tables one below the other
I would like to know how to get the result according to the image, I have a column with id that links the father and son records, I know that the join joins the tables side by side, however, needed…
-
0
votes0
answers21
viewsAlternative method for OR condition
I would like to know if you have any alternative means to improve the performance of a select without using the expression OR. Running only with an equal operator I get the result in 30min but…
-
0
votes1
answer2559
viewsSet value for an oracle variable and use as parameter
What’s wrong when I try to set a value to an oracle11g variable and use it as parameter ? I found a post with the same doubt and adopted one of the solutions but the error continues: DECLARE ID…
-
0
votes1
answer252
viewsSQL Error: ORA-29855: Error in executing ODCIINDEXCREATE routine
I’m trying to create an index on Oracle where it will be automated and run every hour. Query: CREATE INDEX IX_TXT_NOME ON TBL_PESSOA ("TXT_PESSOA") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS…
-
0
votes0
answers36
viewsKnow the last schema that was changed synonym
I have an Oracle server that has several schema, for the purpose of explanation, understand the metaphor: There are schema classified as LETTERS, and schema classified as NUMERIC, and several times…
-
0
votes1
answer60
viewsORA-01461 error when trying to save a CLOB text field generated by a template. What do I do to fix this?
Error trying to save a record in Lotemail class. table: lotemail LOTEMAILID NOT NULL NUMBER(18) LOTEMAILCORPO CLOB Class: class Lotemail(models.Model): lotemailid = models.BigIntegerField(…
-
0
votes1
answer52
viewsOracle character count trigger
Hello, I need to know how to create a trigger in the Oracle database for you to monitor a insert or update in an NCM field of a product so that it is not less than 8 characters, follows example…
-
0
votes1
answer253
viewsHelp with Trigger Mutating
I am creating a Rigger that needs to be fired through a table, even creating a COMPOUND TRIGGER it accuses error of mutating, I am aware that I cannot perform a SELECT of the table I am firing to…
-
0
votes2
answers39
viewsOracle - Regular expressions
Dear, I need to find out which users have the login pattern "E012345", that is, it begins with the letter E and proceeds with a string of numbers. I tried the query below on the did not roll: SELECT…
-
0
votes0
answers32
viewsReturn all results in a grouped query even if the sum is zero or null
I have the following consultation grouped: SELECT SUM(SUC.PESO), EXTRACT(DAY FROM HU.FIM), CASE WHEN (ACO.COLUNA_2 IN ('L','C') AND HU.ESP_MM_UNMET<=3) THEN 'Carb' WHEN (ACO.COLUNA_2 IN ('L','C')…
-
0
votes1
answer102
viewsProblems in Object Reference not defined for an object instance
I have a problem with the result of the method SaveChanges(). I am trying to save a record, and it is persisted in the database, however the application is returning the message from exception:…
-
0
votes0
answers51
viewsOracle DDL trigger , identify a "drop column"
In Oracle it is possible to create DDL triggers (Data Definition Language) something like create or replace trigger trg_ddl before ddl on database declare begin ... end; My , doubt , how to…
-
0
votes2
answers67
viewsHow to calculate the value of two subquery in Oracle SQL
How to calculate two subquery on Oracle? Could you explain to me how I sum up VALOR_1 + VALOR_2? SELECT COL1 , (SELECT SUM(TAB1.VLRTOTAL) FROM TABELA TAB1 WHERE TAB1.ID = TAB3.ID) AS VALOR_1 ,…
-
0
votes1
answer110
viewsOracle SMTP does not send hidden copy (BCC)
I’m trying to send a "Blind Copy" by our Email Sending Procedure by documentation would be ok , but is not sending or generating any error , the code is below , the sensitive items were exchanged…
-
0
votes0
answers32
viewsThere is a table in which the column is called DATE and when trying to select this column the oracle does not let. Does anyone have an idea what to do?
SELECT A.DATE FROM TESTE A; ORA-01747: invalid specification for user.table.column, table.column or column 01747. 00000 - "invalid user.table.column, table.column, or column Specification" After I…
-
-1
votes1
answer2206
viewsHow to Identify and Fix 00302 Error in Oracle?
How can I fix an error of this nature (ERROR 00302) and how to know which line is the error in oracle SQL Developer? Error(16,6): PL/SQL: Statement ignored Error(16,52): PLS-00302: component…
-
-1
votes1
answer314
viewsAccess oracle database remotely
Is there any way to access, or at least import/create my database in some workspace, or oracle server (free)? So it can be accessed remotely. If yes, how could I do this "access" ?
-
-1
votes2
answers849
viewsCondition within the WHERE clause
Good afternoon ! I have a task to perform a select, but the parameters are passed as variables and I need to treat the input of one of these variables with the following logic: if &CT is not…
-
-1
votes1
answer229
viewsWhich SQL command to use to change a character of the vehicle plate - Mercosur Standard
I use a system that works with the Oracle 11g database and 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…
-
-1
votes1
answer40
views -
-1
votes1
answer77
viewsInvalid n Index for this Oracleparametercollection with Count=n
I’m racking my brain trying to figure out why I was wrong. Mapping of my table: <class name="AtaReuniao" table="EPN.ATA_REUNIAO" lazy="true" where=" ARUN_IN_EXCLUIDO = 'N' "> <id name="Id"…
-
-1
votes1
answer21
viewsYou can do a PIVOT using SUBSTR
Hello everybody all good? I’m trying to do a PIVOT on oracle 11 by only getting the first character of a STRING. CREATE TABLE T_ESTOQUE( CD_ENDERECO VARCHAR(15), CD_PRODUTO VARCHAR(20), QT_ESTOQUE…
-
-2
votes1
answer996
viewsAdd and split columns to oracle
I have 4 columns. I want to do the subtraction process in 3 and divide by the fourth. How do I do this operation in BD Oracle? COLUNA1 - COLUNA2 - COLUNA3 = RESULTADO; RESULTADO / COLUNA4 = COLUNA5…