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....

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 ...

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 as part of the text ...

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 ...

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. ...

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 ...

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 ...

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 ----------------------------------------------...