Questions tagged as 'oracle-sqldeveloper'

Tagged questions
2
answers

Can different foreign keys be referenced for the same attribute field?

I'm working on a Oracle SQL Express 11g code. So far I have these two tables: CREATE TABLE EVENTOS ( OID_Proj INTEGER PRIMARY KEY NOT NULL, nombre VARCHAR2(50) NOT NULL, ubicacion VARCHAR2(50) NOT NULL ); CREATE TABLE PROGRAMASDEPORTI...
asked by 28.12.2018 / 03:12
3
answers

Foreign key table - oracle sql

I have a table in Oracle SQL, and a field, I want it to be a foreign key of the same table, but Oracle gives me an error. create table Empleado_almacen ( cod_empleado_almacen int, dni varchar2(9), dni_jefe varchar2(9), nombre varchar2(30), dir...
asked by 09.06.2017 / 12:03
0
answers

ORA-01927 privilege is not revoked: can not REVOKE privileges you did not grant

With the user SYS it is required to revoke the privilege EXECUTE of the table AWRRPT_HTML_TYPE however when executing the statement REVOKE EXECUTE ON AWRRPT_HTML_TYPE FROM PUBLIC; Displays the following message:   ...
asked by 21.02.2018 / 20:37
0
answers

Does not show dates from PHP when consulting Oracle

I have an Oracle database that I can access through PHP and visualize information about it, through SQL Developer I have a statement that executes and returns these results: But executing the same sentence in PHP: $tsql= "select orden...
asked by 04.09.2018 / 15:18
2
answers

Help JOINS ORACLE SQL query

Create a select where the name and last name of the employee, department where he works and the name and surname of the manager who coordinates it. SELECT EMPLOYEES.FIRST_NAME||' '||EMPLOYEES.LAST_NAME AS "NOMBRE COMPLETO DEL EMPLEADO",DEPARTM...
asked by 16.06.2018 / 08:08
1
answer

How can I know if a txt file exists from PLSQL

I have the following problem, I am creating a Trigger in Oracle so that I write information in a txt file, up to here everything is fine, I can write without dramas, the problem is when I need to add information to the file, apart from the one t...
asked by 27.05.2018 / 00:26
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
1
answer

Check if employee already exists

I am inserting data into a table in an Oracle sqldeveloper database and I want to check some things like (that the employee number already exists or that it is not entered correctly, that the boss does not exist, that the salary> 0, and that the...
asked by 22.06.2018 / 09:47
0
answers

Error with trigger with IF and UPDATE in ORACLE

executing this trigger in ORACLE I got the following error: Table,View Or Sequence reference 'OCEX_COMI.FECHA_ASIG_GT' not allowed in this context. This is my trigger: create or replace trigger ocex_comi_total before insert or update...
asked by 29.06.2018 / 02:46
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