Questions tagged as 'oracle'

Tagged questions
1
answer

ORA-00980: synonym translation is no longer valid

What does this error mean? What actions can be taken to remedy it?     
asked by 10.02.2015 / 21:21
2
answers

Oracle - How to force a field size on a function return

I hope to be clear on this issue, I will define it in a generic way but I think it's enough 1) I create a FUNCTION any that returns a VARCHAR, does not matter much what is returned 2) I create a VIEW that uses this FUNCTION Result: The...
asked by 11.09.2015 / 16:19
1
answer

Calculate DUMP import time

I would like to know, if possible, how to calculate approximate the import time of a Dump . It could be something considering the following items: DUMP size in GB. Tables Amount. Number of records and (or) rows / columns per table....
asked by 27.01.2016 / 14:31
1
answer

Can I invoke the function in a Trigger?

My function made in Sql-Server: CREATE FUNCTION dbo.getQuantidade(@idProd char) RETURNS float AS BEGIN DECLARE @QTD float SET @QTD = (SELECT (prod.Quantidade) FROM Produto prod where @id_prod = IdProduto) return @Q...
asked by 29.06.2016 / 16:58
1
answer

JPA - Error of record not found soon after insertion of same

A question regarding JPA procedures, due to an error that has happened and I can not understand. I'm taking care of a part of the system that feeds a card order table. It looks up if the user that the request references has the card, and it i...
asked by 24.04.2015 / 22:04
1
answer

Problems using Java classes in Oracle Database

I'm having trouble using Java classes a little "complex " in Oracle . When I use a simple class, as an example below: CREATE JAVA SOURCE NAMED "Welcome" AS public class Welcome { public static String welcome() { return "W...
asked by 14.08.2014 / 18:47
4
answers

month / year SELECT in DATES

I need the select to return all rows that were entered in July 2010, as shown in the example, regardless of the day. How do I return this query? SELECT * FROM FRCAST WHERE DATA_ID = TO_CHAR('07-2010', 'mm-yyyy');     
asked by 17.03.2017 / 18:10
2
answers

Oracle SQL result ordering

I've done the following query, which was ordered by the product batch creation date. With the migration from version 11 to Oracle R12, the batch field became the migration date, that is, yesterday. As a workaround, we'll use the lote fiel...
asked by 13.06.2016 / 16:14
1
answer

How to calculate the age of a person in Oracle SQL?

I need an sql command that returns the person's age. I have the date of birth of the person in the bank, I need to calculate their age by SQL.     
asked by 12.06.2017 / 19:59
2
answers

Returning a case sensitive record

I have a constraint in the bank that is all with its capitalized name. How do I count find it using UPPER ? Because I want to pass where a lowercase name to return. This my query is not working. select count(*) fr...
asked by 31.08.2017 / 20:17