Questions tagged as 'oracle10g'

4
answers

Subtract two TIMESTAMP and receive the value in minutes in Oracle

How to subtrair two fields TIMESTAMP and receive the value in minutos in oracle ? DATAFIM - DATAINICIO = 2880 minutos (ou dois dias)     
asked by 29.04.2014 / 15:10
1
answer

Is it possible to use timestamp without having to convert to String in Oracle?

I have a query that one of your filters is a date, is it possible to filter in Oracle with something like this? SELECT * FROM tabela WHERE campoData = '2014-02-10 15:56:00.000' Or do we always have to convert to String as below? SELECT *...
asked by 10.02.2014 / 18:57
1
answer

Unique key violated when I am doing a delete. Because?

I have a problem that seems silly but I'm skating and I can not solve it. I have a legal application made in Java using JPA 2 with Spring, Spring Data, JSF, etc ... It works very well. The base I'm using is Oracle 10g. Well now comes the prob...
asked by 06.06.2014 / 00:39
1
answer

Code to generate the 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 for running an Oracle Forms application, and we would like to keep the same password on both systems (Single Sign-On )....
asked by 05.12.2017 / 04:58
2
answers

Format CPF column with regular expression

In a table containing the CPF column I would like to format it to display the content appropriately. By proper means I mean the format 999.999.999-99 . Is it possible to format this content using regular expression? SQLFiddle for testing...
asked by 27.07.2015 / 19:57
1
answer

How to export data from an Oracle 11 database and import into an Oracle 10?

I'm having trouble exporting data from one Oracle 11 to another Oracle in version 10. I tried copying the exp binary from the old machine to the new but as they are distinct architectures (32/64 bits) it did not work. I read that Da...
asked by 10.03.2014 / 22:40
2
answers

My dbms output is not displayed

I'm testing a simple output of DBMS in SQLDeveloper. I created the connection, I executed set serveroutput on to enable the DBMS outputs, but when I run my anonymous code block, in Saída do Script it displays the mess...
asked by 27.11.2017 / 17:56
1
answer

Changing a data type across the schema in oracle

Good afternoon! I need to change a data type of my entire schema, I have varchar2 80, and I would like to change it to 100, but this all at once ... is it possible?     
asked by 07.09.2017 / 22:06
1
answer

ORA-00907: right parenthesis not found - Help

I'm trying to create the following table in SQL create table Compra ( CodCompra number(3) primary key, DataCompra date, DataEntrega date, Fornecedor foreign key Fornecedor REFERENCES (codfornecedor)Fornecedor )    ORA-009...
asked by 08.09.2018 / 00:29
1
answer

Insert 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 consider only the department IDs (F...
asked by 03.05.2014 / 03:12