Questions tagged as 'oracle'

Tagged questions
0
answers

ORACLE Stored procedure to avoid records of dates included in a range of dates

My Training table is this: CREATE TABLE training( id_training NUMBER, id_user NUMBER, start_training DATE, end_training DATE ); The problem that arises is when I have a user (any user) with a date of...
asked by 02.08.2018 / 16:37
0
answers

I get this error when connecting to the database "I / O error: Invalid number format for port number"

This is what I have inside the properties file: hostname=localhost port=1521 database=xe username=xxxxxxx password=xxxxxxx jndi =dbp_props And here the code package ConexionBD; import java.io.IOException; import java.io.InputStre...
asked by 13.09.2018 / 02:59
0
answers

Problems connecting Node.js with Oracle database

How about? colleagues, I ask for your support to be able to connect JavaScript or Node.js to an Oracle database, I have read several docs for example ( link ) which has helped a lot but not enough, I am currently in the following problem....
asked by 25.07.2018 / 08:07
0
answers

oracle database connection 12.0g with XAMPP and PHP 7

Good afternoon I need help with an error when running the Xampp. No se encuentra el punto de entrada del procedimiento OCImemoryAlloc en la biblioteca de vinculos dinámicos OCI.dll I'm trying to connect to an Oracle database with php.  ...
asked by 25.07.2018 / 00:12
0
answers

Transactions per second in oracle?

I'm trying to perform an sql query in Oracle 11g to know the transactions per second of an instance, and manipulate the time it gives me the TPS average, for example find the average TPS per day or see the TPS each 15 min of the day: 00:15 ##...
asked by 02.08.2018 / 22:03
0
answers

Java multithreading using JDBC

I am trying to make an application with threads consult a database with millions of records and basically these threads divide the database to make the query faster. The error that I am having is that in my code only one thread is executed, only...
asked by 20.07.2018 / 21:50
0
answers

Help Error ORA-01422 ORACLE

I created a trigger so as not to insert the same user with the same chat two or more times, but I miss this error exact fetch returns more than one requested number of rows tips This is my trigger: CREATE OR REPLACE TRIGGER OCEX_VER...
asked by 07.08.2018 / 20:22
1
answer

How to format a date and place decimal points in Oracle?

I have a query which gets Date fields and fields type number The result of this query is placed in an excel file and what it does is that it does NOT show the date fields in DD / MM / YYYY format and it does not show the number type fields wi...
asked by 24.07.2018 / 21:00
0
answers

Pass type BLOB in trigger

I have a trigger where based on the current status of a column, I make an insert in another table. Everything seems to work correctly, except the passage of the data of an attribute that is BLOB. This attribute is passed NULL. I have this pro...
asked by 16.07.2018 / 20:22
0
answers

Problem when displaying data from a database in an HTML tag select

This is my HTML code: <select> <% ConectaDB con=new ConectaDB(); try{ con.conectar(); String sql="select unique(n_dep) from ocex_uea order by n_dep asc"; con.st=con.conexion.createStatement(); con.rt=con.st.executeQu...
asked by 12.07.2018 / 20:29