Questions tagged as 'oracle'

Tagged questions
0
answers

UPDATE with INNER JOIN in Oracle 11G (Performance)

I am currently starting to work with Databases in Oracle and it is common to have to perform UPDATE from one table to another. Since the databases I have access to do not have many records, if I run an Update with inner join I can not evaluate t...
asked by 12.04.2018 / 23:25
1
answer

PHP does not return all the results of a query to Oracle when there are many records

I'm making queries from PHP to an Oracle database. The problem is that when the database has few records (5 for example), when I go through the oci_fetch_array function, it returns them without problem, but when it is 100 records it returns...
asked by 21.07.2017 / 12:24
2
answers

Is there a way to adapt an SQL statement when a null field arrives?

Hi, I hope you're ok, is there any way to adapt an SQL statement so that it reacts according to whether a parameter arrives nil or not, something like this: drop table if exists tabla; create table tabla ( id int primary key AUTO_INCREMENT...
asked by 21.08.2018 / 18:07
1
answer

Problem when verifying that my user is in the ORACLE database

Is there any kind of conflict with rowCount? The sentence I understand is fine, and I'm using PDO, which also did not give me problems before. The field in the database is VARCHAR2. I attach my code: $user = 'pepito' $con = conne...
asked by 13.02.2018 / 14:41
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
2
answers

Know if there is a number within a variable

In a variable I keep a number that is in my Oracle DB can be 236578898 but I just need to know if it brings the 2365 to perform an operation, account1 is where I keep the number if (int.Parse(cuenta1) == 2365) { //int valor1 = Int.Parse(TB...
asked by 10.08.2018 / 17:10
1
answer

How to consult data from parent tables using foreign keys. oracle

I have a Staff table with the following structure: create table PERSONAL ( personal_id NUMBER(8) not null, nombre VARCHAR2(50), apellido VARCHAR2(50), ) alter table PERSONAL add constraint PK_ID primary key (PERSONAL_ID); An...
asked by 03.02.2017 / 11:55
2
answers

Better performance in consultation with BD Oracle

I am interested in finding a way to have a better performance in this scenario:    I have N stored procedures that must return the result of queries ( Select * from ... ).    These stored procedures are mapped with the Entity Framewor...
asked by 10.10.2016 / 16:37
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
1
answer

Sqlfiddle with HR schema tables from Oracle DBMS Sample

On the site sqlfiddle I would like some way to quickly load all the tables in the example schema HR that is used in the management system of database Oracle , or failing that, change me to the scheme HR . Is there any
asked by 23.12.2015 / 20:29