Not sure what causes that problem, but when I run query select to_char(sysdate, 'HH24:MM') from dual; I constantly get the same time 15:08. I even check a different Oracle DBMS on different machine (also Windows) and got the same result. ...
Hi everyone, This seems like such a bonehead question, but I've been chasing my tail around a tree all day. I have a Struts 2 + Spring3/JPA/Hibernate application that inserts a large set into the DB. In the set is a Java util date. I've checked the date just before the Dao inserts the rows and all the dates have the correct times. After...
I am trying to import into oracle using imp command and the output of the command is as below. invincible:/home/invincible# imp Import: Release 10.2.0.1.0 - Production on Thu Aug 12 22:19:00 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: n_data Password: IMP-00058: ORACLE error 1034 encountered ORA-01034: OR...
Hi everyone, I have an Oracle 10g table that contains a # of log records. This table collects data from an environmental recording device that creates a log record every 15 seconds when it is running. I want to add all of the seconds together from the reading dates of the log file entries to ensure that the logger ran > 24 hours (84...
We have a non normalized table that contains foreign key infomration as free text inside a column. I would like to create a view that will transform and normalize that table. E.g. a column that contains the following text: "REFID:12345, REFID2:67890" I want to create a view that will have REFID1 and REFID2 as 2 separate integer colu...
Synopsis - a windows console application extracting data from Excel spreadsheet then find match on oracle database if a record is found then update else create a record based on Excel's data. (Written in VB.net/.Net 3.5, use open source FileHelper library to process Excel and Oracle 10 as backend) Problem - a file with 983 records but o...
Here's my query: select * from test n WHERE lower(process_name) like 'test%' AND ( test_id is NULL OR TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE),-6),'YYYYMM') > TO_CHAR(n.process_date,'YYYYMM') I want check whether date field process_date is greater than 6 months in the query. ...
Hello, I'm having trouble trying to define the SQL query for this table: There's a table of patients and their weight readings recorded on visits with the following columns: patient ID weight reading visit ID (one per visit) In other words, if in two records two visit IDs are the same, then two weight readings have been taken on ...
Hi I am making an ATM console application in C++. I am planning to use a database, my friend suggested to use files. However, I want to use a database like mySql, Oracle or sqlServer express. Q: Which one of the databases would be more applicable for a C++ application ? I am also making a second application in java. This is a large li...
Hello everyone, I would like to know if there is any tool able to extract the design from an existing Oracle database. I have a read access to it and I would like to have the design. Or simply export it to a *.sql and then read it with any tool able to create the design with the links between the tables. Something like that Thank you...
Hi I am using sqlalchemy for connection pooling only (need to call existing procs) and want to return a REF CURSOR which is an out parameter. There seems to be no cursor in sqlalchemy to do this. Any advice greatly appreciated. ...
We have a JPA -> Hibernate -> Oracle setup, where we are only able to crank up to 22 transactions per seconds (two reads and one write per transaction). The CPU and disk and network are not bottlenecking. Is there something I am missing? I wonder if there could be some sort of oracle imposed limit that the DBA's have applied? Network...
Hi all, I am using JBoss 5.1.0.GA on Red Hat Linux 4. We have only webservices deployed on this application server as .war files (servlets only, no stateful applications present). As a part of our architecture change for improving scalability, we are planning to have multiple JBoss servers running (may or may not be on different IP's an...
Hi! While using JDBC, we can work with oracle ref cursors using CallableStatement. Can I have such functionality using iBatis? ...
I have a table T1, it contains a NAME value (not unique), and a date range (D1 and D2 which are dates) When NAME are the same, we make a union of the date ranges (e.g. B). But as a result (X), we need to make intersection of all the date ranges Edit: Table T1 NAME | D1 | D2 A | 20100101 | 20101211 B | 20100120 | 20100415 ...
Can you see anything that might have been left out for a simple bug tracking system? Here's an updated version with new changes ...
Hi everyone, I'm trying to connect to an oracle db from an odbc connection, the odbc connection is set and works properly when we test it. However when I try to connect to through ASP classic I keep getting that msg. I'm also able to connect to it through SQLPLUS and able to ping it with tnsping <% Dim connection : Set connection = Ser...
We are trying to create reports in SQL Server Reporting Services 2005 from Oracle. The problem is many values do not display correctly, they show up as an empty square (depedning on the font, sometimes it will show as a black diamond with a question mark) The field is stored in a varchar2 in Oracle. For example what "appears" to be ...
I have this table view UserName Product NumberPurchaces -------- ------- --------------- 'John Doe' 'Chair' 4 'John Doe' 'Table' 1 'Jane Doe' 'Table' 2 'Jane Doe' 'Bed' 1 How can I create a query that will provide this pivot view in Oracle 10g ? UserName Chair Table Bed --------...
I've got a table like this: ID | Val1 | Val2 --------------------- 1 | 1 | 2 2 | 1 | 3 3 | 2 | 1 4 | 2 | 3 5 | 3 | 1 6 | 3 | 2 now my problem is, that 1 - 2 means the same like 2 - 1 (look @ ID 1 and ID 3 for example) and I want to eliminate all entries where value 1 - value 2 ...