Questions tagged as 'oracle11g'

Tagged questions
0
answers

Visual Attribute in Oracle Forms Personalization

I'm having a problem with Forms Personalization , I'm new to Oracle EBS and Forms Personalization . I need to change the background color of my item, but when I use the background-color property, it changes the entire column, I want...
asked by 19.06.2018 / 16:05
0
answers

Missing Task SrcSet0 (Loading) in source MICROSOFT_EXCEL ODBC

Hello, I'm trying to set up oracle data integrator to read an excel spreadsheet in xls and xlsx formats, but I'm having problems and I can not find a solution! it returns me the following error: IconfiguredODBCinthisway: Andtestingthesepara...
asked by 27.12.2017 / 12:48
2
answers

I can not connect jsp page to Oracle database

   This my Web project worked in school, but in my pc will not ..   It was to return "connected in the oracle database" and it returns   "oracle.jdbc.driver.OracleDriver"       Connection class: package classeConexao; import java.sql.Connec...
asked by 04.11.2017 / 20:29
2
answers

Use IF function in SQL as if it were excel [closed]

Is there a function in SQL equivalent to IF ( SE ) of excel? I need to do a logical test that in excel I would write =SE(B1_UM = "UN"; D2_QUANT / B5_QE1;D2_QUANT) . Here is my query: SELECT D2_FILIAL, // Um monte de...
asked by 16.05.2018 / 20:43
2
answers

How to migrate data from a Postgres table to Oracle? [closed]

NOTE: In short, the database that was in postgres was migrated to oracle, but a table that is not automatically migrated by the system was missing. I want to know what is the best way to do this if you can do it manually or use some tool betw...
asked by 26.01.2017 / 20:21
1
answer

ORACLE USERS

Good afternoon. I have two owners on my oracle example Owner "X" and the other owner "Y". Where each one has its own tables, but I want the owner "X" to be able to update, insert and delete some tables of the owner "Y". Is it possible?     
asked by 14.08.2018 / 21:48
1
answer

Oracle - Cursor

I am studying PL / SQL and testing the use of CURSOR, but I am not able to test an example: SET SERVEROUTPUT ON DECLARE V_NAME VARCHAR2(50); CURSOR CUR_CURSOR IS SELECT FIRST_NAME FROM EMPLOYEES; TEMP CUR_CURSOR%ROWTYPE; BEGIN IF N...
asked by 29.03.2018 / 16:31
2
answers

Function MAX only 1 (one) record in Oracle

Can anyone help me with 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 that record - > Id, Ticket_id and Queue_id, but if I use the query as be...
asked by 19.03.2018 / 23:32
1
answer

Loop in pl / sql oracle

I want to know how to go through all the tuples that are stored in a table; how do I do this in PL / SQL Oracle ? Thank you in advance!     
asked by 28.04.2017 / 21:02
2
answers

Search and persons having the same name, surname and date of birth [closed]

How can I make a select in Oracle that brings all people who have the same name, surname and date of birth but have different ID's.     
asked by 31.03.2017 / 15:58