Most voted "oracle10g" questions
23 questions
Sort by count of
-
6
votes1
answer401
viewsIs it possible to use timestamp without having to convert to String on Oracle?
I have a query that one of your filters is a date, it is possible to filter in Oracle with something like below? SELECT * FROM tabela WHERE campoData = '2014-02-10 15:56:00.000' Or we always have to…
-
6
votes4
answers22316
viewsSubtract two TIMESTAMP and receive the value in minutes on Oracle
Like subtrair two fields TIMESTAMP and receive the value in minutos in the oracle? DATAFIM - DATAINICIO = 2880 minutos (ou dois dias)…
-
6
votes1
answer624
viewsUnique key violated when I’m doing a delete. Why?
I have a problem that seems silly but I’m skating and I can’t solve it. I have a nice application made in Java using JPA 2 with Spring, Spring Data, JSF, etc... It works great. The basis I’m using…
-
4
votes1
answer474
viewsCode to generate user password hash in Oracle 10G with C#?
I need to authenticate users in a web application in the Oracle 10g database, but the credentials are native to the database by running an Oracle Forms application already, and we would like to keep…
-
3
votes1
answer1710
viewsHow to export data from an Oracle 11 database and import into an Oracle 10?
I am having trouble exporting data from an Oracle 11 to another Oracle in version 10. I tried to copy the binary exp from old machine to new but as they are different architectures (32/64 bits) did…
-
3
votes2
answers3054
viewsFormat CPF column with regular expression
In a table containing the column CPF I would like to format it in order to present the content properly. By appropriate way I refer to the format 999.999.999-99. It is possible to format this…
-
3
votes1
answer2370
viewsMy dbms output is not displayed
I’m testing a simple exit from DBMS in Sqldeveloper. I created the connection, ran the set serveroutput on to enable the exits DBMS, but when I run my anonymous code pad, on Saída do Script he…
-
2
votes1
answer208
viewsChanging a data type across the schema in the oracle
Good afternoon ! I need to alter some kind of data from all my schema, I have the varchar2 size 80, and I’d like to change it to 100, but this all at once... it’s possible ?
-
1
votes2
answers263
viewsHibernate Warning HHH000444 using Oracle 10g with Wildfly 8.0.0 - follow-on Locking
When making some queries in a view using JPA (2.1) with hibernate, I’m having this Warning. Though it’s working and it’s only one Warning, It bothers me a little bit. WARN…
-
1
votes1
answer2201
viewsInsert random data into a table that has foreign keys (Oracle)
I have a table "usuario" (idUsuario, nome, departamentoId) and another table "departamento" (idDepartamento, nome). I would like to enter random data in the user table, but for this, I need to…
-
1
votes1
answer9353
viewsORA-12154 TNS: could not resolve the connect Identifier specified
I’m having trouble when an application tries to connect with the database, I get error ORA-12154 TNS: could not resolve the connect Identifier specified. When I give a tnsping or try to connect by…
-
1
votes1
answer91
viewsBitand in the Where clause
I need to do the following Query, but it is generating some syntax or logic errors. SELECT campo_X, campo_Y FROM tabela_Z WHERE( ( BITAND(1, 1) > 0 AND campo_A NOT IN (2,4,8,9) ) OR ( BITAND(2,…
-
1
votes1
answer300
views -
0
votes1
answer2768
viewsHow do I connect a java program with oracle 10g?
I tried to make the code below but it didn’t work, I’m using Oracle 10g. import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet;…
-
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
votes0
answers51
views -
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
votes1
answer121
viewsBring record of each ID with the latest change date
I am working with Oracle database and PHP, need to return only one product each with the latest change date, the tables are as follows. product price I have tried several types of query, but I…
-
0
votes1
answer291
viewsCreate an Oracle Agent/Job for Postgresql
I wonder if it is possible to create an agent/job in Oracle to query the data of a given table and insert the data from this table to another table that is in Postgresql. Or if I can through…
-
0
votes0
answers40
viewsIs it possible to select periods from a table in a select without subquery?
Greetings, I wonder if it is possible to select a table period without using a subquery as an example below: Select Usuario, Divida.Janeiro , Divida.Fevereiro, Divida.Marco ... from Usuarios a left…
-
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
answers25
viewsQuestion about filter with dates
I’m a beginner in SQL, and I’m working on a project on Oracle. I got stuck in a situation that theoretically would be simple to solve, but I don’t succeed. They can help me? Below follows the code…
-
-1
votes1
answer1899
viewsCall Procedure inside another
I need to create a precedent enviar_email_servidores call in another pr_envia_email. The term to be called (pr_envia_email) has the function of sending email, and I need the message sent to this…