Questions tagged as 'oracle'

Tagged questions
1
answer

SQL Server Syntax to Oracle [Create User]

Hello, I was looking for how to change this syntax from sql server to oracle and I still do not understand the structure that oracle has in its bd. The sql server syntax: USE [BD] GO /****** Object: User [pepe] Script Date: 06/05/2017 1...
asked by 05.06.2017 / 17:08
2
answers

Result Set empty with Prepared Statement in java against Oracle

Good! I have the following code that is not returning any data to the ResultSet defined: Connection _con = null; PreparedStatement _ps = null; ResultSet _rs = null; UsuarioBean _Ret = null; _con = (new ConEvaluacionProveedores()).ge...
asked by 05.06.2017 / 16:31
2
answers

Display the current date each time a command is executed

Is there a command or function that shows the date when a command is executed? Use SQL Developer, and for example if I run: select sysdate from dual Set the system date, and I want the date to be with hours, minutes and seconds. How cou...
asked by 06.10.2016 / 19:04
3
answers

Problem connecting from .net to Oracle with EF

I explain a little about the problem of my scenario, in my development machine I have ODAC 12 installed and can develop normal connections against Oracle, in my production server install the same Oracle but when trying to run my application.exe...
asked by 14.09.2016 / 19:57
1
answer

AUTI INCREMENT in an oracle table

Good I want to create a table in an oracle scheme called CA: CREATE TABLE PDT_CONCEPTOS( ID INT(8) NOT NULL, NOMBRE VARCHAR(250) NOT NULL, CODIGO_PDT VARCHAR(8) NOT NULL, CODIGO_DB VARCHAR(100) NOT NULL, DESCRIPCION VARCHAR(250)NOT NULL,...
asked by 28.12.2018 / 22:45
2
answers

I must make a query to a code but in the BD is the code with zeros on the left

Example I must consult this code 2365 but in the BD is this 00000002365 how can I make the query just by writing the code 2365 without the zeros? I am working on visual studio 2015 with BD Oracle. "SELECT * FROM MOVIMIENTOCONTABLE WHERE CTE...
asked by 09.08.2018 / 22:46
1
answer

Obtain data with the lowest sequence number

I'm IN ORACLE SQL I do not know how to make the next query, to see if you can help me. I have the following table, in which there are 2 different products, inserted in different dates and times, and with different quantities: Producto1 1/12/17...
asked by 03.08.2018 / 00:39
1
answer

Help with data management in Oracle, how to use the TO_CHAR for a NUMBER data type?

I have a query which obtains data of type NUMBER in the BD, what I do is show the result of the query in a .csv file and at the time of showing that data the fields of type NUMBER which are (IMPORTE_UNO, IMPORTE_DOS) it does not show deci...
asked by 26.07.2018 / 06:29
1
answer

Help ORACLE Queries

List the department, the total salary of the departments that the sum of their salary is greater than 20000. SELECT D.DEPARTMENT_NAME,SUM(E.SALARY) FROM DEPARTMENTS DINNER JOIN EMPLOYEES E ON D.DEPARTMENT_ID=E.DEPARTMENT_ID GROUP BY D.DEPART...
asked by 20.06.2018 / 16:35
1
answer

Error in PL / SQL with a procedure with cursors

I try to solve the following question: Ask the User for nationality, and show the clients with that nationality, for this I used an anonymous block and a procedure that is as follows: Procedure: CREATE OR REPLACE PROCEDURE mostrarNacio...
asked by 30.05.2018 / 20:50