Questions tagged as 'oracle-11g'

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
1
answer

0 ^ 0 = 1 in Oracle?

Why the oracle power function returns a 1 in the following statement: SELECT POWER(0, 0) FROM dual; As I understand this it should be an indeterminacy since 0 ^ 0 is equivalent to saying 0 ^ (nn) , assuming n an integer positive...
asked by 29.06.2017 / 02:15
1
answer

Help with PL / SQL insert in Oracle

What happens is that I am trying to do a search in two tables and through cursors with parameters do the calculation of a tax and insert the data in a new table called taxes. I have three tables, AUTOMOVIL , AVALUOS e IMPUESTOS...
asked by 04.10.2018 / 16:48
1
answer

Alternative to SQLFiddle

The page link currently does not allow creating tables, who knows any alternative to this page? The issue has already been reported to the developer team of sqlfiddle, but it still has not been solved, for that reason I am now asking for an...
asked by 04.01.2016 / 17:44
1
answer

Procedure to give permissions to an Oracle 11g user?

I am trying to create a procedure that receives as a parameter the user to whom they wish to grant the tables permission directly, I know that it would be better with a role and simply grant it, but it is an exercise, to create a procedure that...
asked by 04.04.2017 / 03:58
1
answer

How to make an autoincrementable field in oracle 11g?

The table is as follows. create table ventas( id_venta number(5) primary key, id_articulo number(5) references articulos, id_empleado number(6) references empleado, id_cliente number(5) references cliente, cantidad numbe...
asked by 30.12.2017 / 00:36
1
answer

Stored procedure with UPDATE

I have this procedure where I want to add 1 to the "CONSECUTIVE" numeric field but it gives me an error how could I do it? The error says: Syntax error, a NAME or EXPR was expected create or replace PROCEDURE get_secuencia(consec OUT NUMBER...
asked by 21.08.2018 / 18:25
1
answer

How to recover the last id generated in oracle 11g

I'm trying to capture the last id registered in a table (USE ORACLE 11G) and searching the internet I found this post . I did not find much information in Spanish that's why I'm only using this post as a reference, but it does not wor...
asked by 29.06.2018 / 20:20
2
answers

Does Oracle 11g save the date of the inserts made?

I have a table like the following in oracle: SELECT * FROM ESTUDIANTES; ID NOMBRE EDAD -- ------ ---- 1 Pepe 23 2 Maria 35 ... Can I find out in some way what date the insert was made in that table?     
asked by 14.12.2017 / 12:13
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