Questions tagged as 'oracle-11g'

Tagged questions
1
answer

Error "SQLException: The flow has already been closed" when reading a field of type LONG

I make the following request from Java with JDBC to user_tab_columns : SELECT column_name, data_type, nullable, data_default, char_length, char_used FROM user_tab_columns WHERE table_name = 'mi_tabla' ORDER...
asked by 30.01.2017 / 17:43
2
answers

consult 360,000 codes quickly java

I have 1 main Query whose response time is optimal, the problem arises when after executing my query inside the while I execute a second query that reads the code field and queries 1 by one, here my code: $_Query ="select * from remesas"; Resu...
asked by 30.11.2016 / 17:26
2
answers

How to search with several columns in one table until finding the value in another table ?, ORACLE

Very good, someone knows how to perform a search between two tables, where the first has several columns and search with all those columns until finding a result in another table, I explain: Table1 | nombre | telefono1 | telefono2 | telefon...
asked by 28.02.2018 / 16:48
1
answer

ORACLE 11g Execute Trigger

How do I assign privileges to a user to execute a trigger ?, I need to know if a trigger can be executed and how to assign privileges if possible     
asked by 25.07.2017 / 22:01
4
answers

What is the best way to make a current contract selection and an employee's previous contract in the same row?

Hi, I'm scheduling queries in Oracle 11g and PostgreSQL 9.4, and I have been asked to perform a query whose output is shown in the following image. Employee_ID belongs to the employee table; Current_Contract_ID and Previous_Contract_Id...
asked by 08.11.2016 / 18:21
1
answer

SQL query to see user with more confirmed friend requests

In a database exercise I get a DB with which I must take 2 tables TBL_AMIGOS and TBL_ESTATUS_SOLICITUDES to make a query to know the user with the largest number of confirmed requests. I've tried with HAVING and COUNT...
asked by 16.10.2016 / 09:13
2
answers

Concatenate several VARCHAR2 + 4000 characters

I request your collaboration to indicate how I can concatenate more than one VARCHAR2 in a SELECT , this VARCHAR2 has a more than 4000 characters therefore this error comes out: [Error] Execution (31: 64): ORA-01489: el res...
asked by 26.09.2018 / 16:49
1
answer

ORACLE SQL STATEMENT IGNORED missing parentheses right [closed]

I can not find any missing parentheses in the line set project.activity.full_in = TO_NUMBER, I have reviewed it 20 times and the parentheses close well, I have 2 errors: ORA 00907 missing parentheses right and in the previous line to that it say...
asked by 04.10.2018 / 22:33
2
answers

FOR loop with hops in PLSQL

I have to do an exercise that is a for loop but delimiting the minimum the maximum and the jump, the thing is that both the minimum and the maximum is done but the jump is not how to define it, I hope someone helps me. I leave you my exercise...
asked by 08.05.2018 / 11:31
1
answer

Oracle Sql XE - Error entering sqlplus [Linux deepin (based on debian)]

I have a problem trying to login to sqlplus from the terminal. I run the sqlplus command, and then it asks for username and password. When trying to put system and the password that I put during the installation, I find the following error...
asked by 29.04.2018 / 02:23