Stack Overflow
Stack Overflow

Questions tagged [oracle11gr1]

Oracle 11gR1, an RDBMS product, is the first release of the Oracle 11g database.

21 questions
5
votes
4 answers

Issue with Oracle bind variables not using index properly

In my scenario, the following query runs fast (0.5 seconds on a table with 70 million rows): select * from Purchases where (purchase_id = 1700656396) and, it even runs fast using bind variables: var purchase_id number := 1700656396 select * from…
Jay Sullivan
  • 17,332
  • 11
  • 62
  • 86
4
votes
3 answers

Parallelize oracle union query questions

I have an Oralce query like this: Sub_query1 Union Sub_query2; I want to parallelize the query. I searched on web and found some say UNION cannot be parallelized because the sub queries are running in serial and UNION will not run until two sub…
Gary
  • 4,495
  • 13
  • 36
  • 49
4
votes
3 answers

java.sql.SQLRecoverableException:Closed Connection

I am using jboss7.0.2 final with Oracle 11. Currently I am facing one issue which happens randomly. But during heavy load this error trace keeps growing. Tried so many approaches couldn't succeed. MyDatasource Config:
satish
  • 93
  • 1
  • 1
  • 7
2
votes
0 answers

ORA-12801: error signaled in parallel query server P011

I have stored procedure, which has parallel queries and hints. Frequently we are getting error details as below. An error occurred executing the stored procedure. TM_6159 [4294965496] [ ORA-12801: error signaled in parallel query server P011,…
user2601350
  • 207
  • 1
  • 3
  • 12
1
vote
1 answer

column values in a row

I have following table id count hour age range ------------------------------------- 0 5 10 61 10-200 1 6 20 61 10-200 2 7 15 61 10-200 5 9 5 …
Pramod
  • 657
  • 4
  • 18
  • 34
1
vote
1 answer

Apply OFFSET and LIMIT in ORACLE for complex Join Queries?

I'm using Oracle 11g and have a complex join query. In this query I really wanted to apply OFFSET and LIMIT in order to be get used in Spring Batch Framework effectively. I went through: How do I limit the number of rows returned by an Oracle query…
Jeff Cook
  • 7,956
  • 36
  • 115
  • 186
1
vote
1 answer

SQL DUMP missing information in a column

On Database A: I create test.dmp via oracle sql exp.exe command: exp.exe %CONNECT% FILE=test.dmp LOG=%LOGFILE% DIRECT=Y STATISTICS=NONE In the .log file it writes: . . export table TBL_TEST 7000 rows exported (no error!). Version: Oracle…
Luisa Bradusca
  • 88
  • 10
0
votes
0 answers

How to execute the oracle 11g SP which resides in the package using EntityFrameworkCore 5

We are trying to execute the SP which resides in the package of oracle 11g. As of now we don't have any issues by querying the tables directly but we are facing issues while executing the SP from the package. Error details:- "ORA-00900: invalid SQL…
annetcore7
  • 1
  • 1
0
votes
0 answers

I have created a trigger where data cannot be edited on Saturday and Sunday on emp table

Create or replace trigger trig_error before insert or update or delete on emp begin if to_char(sysdate,'DY') IN ('SAT','SUN') then raise_application_error(-20111,'No changes can be made on tuesday'); end…
Keerthi
  • 1
0
votes
2 answers

How to fetch merge data in Oracle

I have a table SALARY_MASTER which contains empid and salary. Below is the table structure. EMPID SALARY ------- ------ 10001 12000 10002 60000 10003 25000 10004 35000 10005 15000 10006 24000 10007 85000 10008 75000 10009 …
SwapnaSubham Das
  • 515
  • 5
  • 23
0
votes
2 answers

How to execute query when oracle starting up?

I have some question. I want to execute some SQL query when oracle starting up(initialization). for instance, Linux, Windows, and etc. OS are enable to run program, when computer start up. anyway, my purpose is executing some query in oracle 11g r1,…
신동평
  • 119
  • 2
  • 11
0
votes
0 answers

ORA-00923: FROM keyword not found where expected - LISTAGG

I have to comma separate all the values of a column and for this i am using LISTAGG function, but getting error "ORA-00923: FROM keyword not found where expected" Please find below code i am using. Kindly suggest why i am getting this…
PS078
  • 431
  • 1
  • 6
  • 18
0
votes
0 answers

Oracle: logical operator AND treated differentyl in 11.1 and 11.2

We face a very special behavior in one of our migration projects where we want to move from Oracle 11.1 to 11.2. The old query was in the following format: SELECT * FROM TABLE_A, TABLE_X WHERE (NVL(TO_NUMBER(COL_A), 0) > 0 OR NVL(TO_NUMBER(COL_B),…
Markus
  • 763
  • 7
  • 24
0
votes
1 answer

Oracle OSB gather messages with same id and send them to a JMS Queue

I have to implement an adapter that does not immediately routes messages to a JMS queue, but instead waits and gathers messages with the same id, concatenates them to a list and then sends the list as a single message to the queue. Is this…
Alex
  • 11
  • 3
0
votes
1 answer

In Oracle 11gR1 how can i include timestamped values just right outside of an where between timestamp clause

(Given this Database SQL Fiddle) How can I select the previous VALUE right outside my where between clause in the query below? If this is possible it would eliminate my other query needed to find this value in my VBA excel ADODB macro. As i…
ID10T_ERROR
  • 81
  • 9
1
2