Questions tagged as 'sqldeveloper'

Tagged questions
2
answers

Insert records with select in insert

I am trying to insert records in a TB_DET_SUSCRIPCION_DOC table but the SELECT returns more than one record. the error is as follows.    Error Report: SQL Error: ORA-01427: single-row subquery returns   more than one row   01...
asked by 27.09.2016 / 22:31
1
answer

Error connecting Oracle SQL Developer 4.1.2.20 to Oracle XE 11.2 in UBUNTU

I have the following error when trying to connect to Oracle XE from SQL Developer Se ha producido un error al realizar la operación solicitada: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files...
asked by 12.04.2016 / 03:37
2
answers

Oracle SQL SubConsulta

I'm doing a table query / modification exercise. I have two tables: CREATE TABLE CURSOS ( Codigo NUMBER, Nombre VARCHAR2(20), Cod_Profe NUMBER, Max_Alumn NUMBER, Fecha_Inic DATE, Fecha_Fin DATE, Num_Horas NUMBER, CONSTRAINT...
asked by 24.04.2017 / 11:47
3
answers

Help with this sql query

I have a question with the following exercise: Aware of the extra expenses that employees must face in the month of March, it is desired to reward the employee or employees with the highest sales amount for the month of March. To do this, we...
asked by 06.04.2017 / 00:38
1
answer

Migrate SQL Server database to Oracle

I'm trying to migrate a database from SQL Server to Oracle , for this I'm using Oracle SQL Developer as suggested by the following Oracle Tutorial , which has the following sections: Connection: 1. Install Oracle SQL D...
asked by 02.06.2016 / 00:37
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
1
answer

View the tables of an Oracle user

I'm working on a database in SQL Developer, create a user named Nagato2 and with it create a connection called test2, in which I put all my tables. However, I was asked to create a new user within this connection that I called Nagato3....
asked by 12.05.2018 / 01:52
0
answers

Problem with sql developer

I have installed the Oracle 11g express database and intends to access it from the sql developer but at the time to establish the connection I get the following error, I have been searching the internet but I do not clarify. Status: Failure:...
asked by 02.12.2017 / 20:42
1
answer

TRIGGER to prevent deleting record with a specific identifier

I'm doing a job with PL / SQL, oracle and sqldeveloper and I have a table to which I want to create a trigger that prevents me from deleting a record that has an id in the field 1. I do not know how to do it.     
asked by 19.05.2016 / 22:54
2
answers

Request user data conditionally in PL / SQL

Problem Using the Oracle SQL Developer version 4.1.0.19 I am asking the user for data but the program asks me for more data than necessary, skipping the statements if and elsif . Code declare v_nombre varchar2(500);...
asked by 23.01.2016 / 17:24