I have the following routine: For j = 1 To NumItems dbValueLookup.Load(j) Using scope As New TransactionScope() For i = firstIndex To lastIndex 'dbValueLookup is basically just a Dictionary of items already in the DB If dbValueLookup.ContainsKey(i) Then 'updateData is a subroutine that updates this row w...
I'm trying to find an integer number of days between two dates in Oracle 11g. I can get close by doing select sysdate - to_date('2009-10-01', 'yyyy-mm-dd') from dual but this returns an interval, and I haven't been successful casting this to an integer. Edit: Apparently in 10g, this returns the number of days as an integer. ...
I have 3 tables, one which represents a "supertype", with an ID column. Two other tables are each subtypes, with an ID column that is a foreign key to the supertype table, plus a subtype-specific column. I want a query that returns all the data, as well as a column I can use as a discriminator that tells me what table the row came from...
Working with Oracle 11g here. I'm trying to figure out how to write a specific query against a sample table below: ID TYPE PRIORITY STATUS DATE ---------------------------------------------------- 1 Q A NEW 01-OCT-2009 1 Q A NEW 01-OCT-2009 1 Q A NEW 01-OCT-2009...
I'm using Oracle 11g. Also using the spool command to get the output of a query to a file. The problem is that sqlexec is wrapping the characters and making my life miserable. Now under normal circumstances this might be fine however the spool file is on average a 100,000 lines and more so because sqlexec keeps giving me line breaks .......
What is the best way to handle connection pooling with Oracle 11g and asp.net, I'm having issues where Oracle refuses to open up any new connections for the web app after a while. This causes the request to time out and queue up.! EDIT: Is there anything that I need to do in Oracle to fine tune this? ...
Hello there. I am using Hibernate 3.2.5 and Hibernate Annotations 3.3.1.GA as the JPA provider in a data loading application. I have configured Hibernate to use C3P0 for connection pooling. My database is: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production As there is no built in hibernate dialect for 11g, ...
I need help tracking something down, I'm getting several connections where in Enterprise Manager it says: OS User Name: Example$ <-- Example is the machine name. Terminal: Example Machine: Domain\Example There is NO user named Example$, where is this coming from?.... I'm using Oracle 11g. Edit: The problem I'm tracking is with an a...
We're trying to identify the locations of certain information stored across our enterprise in order to bring it into compliance with our data policies. On the file end, we're using Nessus to search through differing files, but I'm wondering about on the database end. Using Nessus would seem largely pointless because it would output the...
I have two select statements joined by "union". While executing that statement I've got: Error report: SQL Error: ORA-01790: expression must have same datatype as corresponding expression 01790. 00000 - "expression must have same datatype as corresponding expression" Maybe you can give me an advise on how to diagnose this problem? ...
I'm getting some strange behaviour from an Oracle instance I'm working on. This is 11gR1 on Itanium, no RAC, nothing fancy. Ultimately I'm moving data from one Oracle instance to another in a data warehouse scenario. I have a semi-complex view running over a DB link; 4 inner joins over large-ish tables and 5 left joins over mid-size tab...
We have a CRM solution where all metadata stored in Oracle table (don't ask me why). I am issuing an update statement but when get the data from database I see on front end '\n' as part of the text and not new line (like HTML's <br/>). I was trying to put directly in description but it shows as br/ on front end. What escape charact...
I have quite a few lines of PL/SQL code in Oracle 10g, and we are going to move to 11g. I expect my code to work there too, but: Are there any pitfalls to expect, any problems you encountered? What new features are you using? ...
Hello, I need remove the quotes from the names of the columns in many tables in my schema. there is any way to automate this process?, any function in oracle or some tool that allows me to change the names of the columns removing the quotes. I am using oracle 11g. UPDATE I'm sorry, I had to rephrase my question. thanks in advance. ...
I have a large (multi-GB) data file exported from an Oracle table. I want to import this data into another Oracle instance, but I want the table name to be different from the original table. Is this possible? How? Both importing and exporting systems are Oracle 11g. The table includes a BLOB column, if this makes any difference. Th...
hi I have build C# program that work with Oracle 11g - all work's excellent. now i want to make some report's with crystal report, and i looking for good manual (free) from the beginner thank's in advance ...
I have an Oracle Weblogic server set up using a mutual authentication SSL configuration. I'm trying to create a client stub in eclipse from a wsdl under the https protocol. Problem is, when I copy in the URL to the service definition, eclipse complains that the service definition is invalid. My guess is that eclipse isn't passing its cer...
How to generate custom classes with ODP .Net 11g ...
Hi all, I found in this article, that since ORACLE 10g, there is a way to make a particular connection-session compare strings case-insensitive, without needing any crazy SQL functions, using an ALTER SESSION. Does anyone know if, in 11g, there might be a way to make the database to always operate in this mode by default for all new co...
I have a compound trigger and in the after statement I have an update to other table that has also a compound trigger, like in the code below: create or replace trigger TRIGGER for insert or update on TABLE COMPOUND trigger after STATEMENT is begin update THEOTHERTABLE set VALUE = VALUE + 1 where COD = 1; end after STATEMENT; end; ...