Questions tagged as 'oracle'

Tagged questions
1
answer

Problems with Perl script that connects to Oracle database

I'm trying to run a script that connects to an Oracle database, and I get the following error: DBI connect('...,...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions I'm...
asked by 27.07.2017 / 11:52
2
answers

Efficient way to empty tables in ORACLE

I have a procedure that empties an auxiliary table and reloads it every time it is invoked. The command used to delete all records is: DELETE FROM T1; To my surprise, removing 500.000 records with this command had a cost of approxima...
asked by 22.07.2017 / 17:22
1
answer

Queries in several tables only one column, FK, PK

For the query for example of the activity in the calendar table, we can also do it in the table Participant no? to be dragging from calendar to activity and then participant     
asked by 19.06.2017 / 04:38
1
answer

Error bd Oracle and C # [closed]

When trying to connect an Oracle database to Visual Studio 2015 I get the following error:    BadImageFormatException. This will occur when running in 64 bit mode   with the 32 bit Oracle client components installed. check the versions bu...
asked by 01.06.2017 / 04:14
1
answer

decimals oracle sql

I have a question, I have in database a data of type number(5,2) but I have values with 1 1.1 3.18 The question is, in the query I can have the zeros added to the right so that the data comes out 1.00 1.10 3.18 the base is oracl...
asked by 10.03.2017 / 00:46
1
answer

Convert a date to decimal

I have this cast in my Oracle SP, but at the time of grouping it, it tells me that it can not be done for the same topic, but if I can run it out with a simple select, does anyone know if there is any alternate way to do this? SELECT case...
asked by 21.10.2016 / 16:11
1
answer

Error creating trigger as SYS in Sql Developer

Well that's the problem, I'm going to create triggers in Sql devleoper as SYS, and when I run the script, it does not leave me, any advice on how to fix it?     
asked by 01.11.2016 / 17:16
1
answer

How to install Microsoft OLE DB Provider for Oracle in Windows Server 2012R2x64

Someone knows how I can install Microsoft OLE DB Provider for Oracle in Windows Server 2012R2x64, I read everywhere that this can not be done because:    This provider is already obsolete and without support       There is no version for x64...
asked by 20.09.2016 / 15:53
1
answer

Use of Bind variables in Oracle when there are no variables

Is it useful to use bind variables when there are no variables? For example SELECT count(1) as cantidad FROM MYTABLA WHERE CAMPO1=5 This query will always be executed the same, 5 will always be 5 and will not change. As far as Oracle...
asked by 27.07.2016 / 14:35
1
answer

UPDATE oracle in java

I have a problem with an UPDATE in java, this one receives a parameter, it does not run, my syntax will put it here, maybe there is something that I forget, from what I've seen on the net, it's fine but I do not know pass: c public void Collec...
asked by 25.05.2016 / 17:50