A bit about me: I entered the workforce in 2006. I have a Bachelor degree in computer science from a reputable university in Canada. I am currently working as Java and PHP developer. I have worked with MSSQL, MySQL, DB2 and Oracle dbms on a development level. Haven't done too much database administration work. Reading Oracle websit...
I need to check if an exception is caused by some database problem. I receive an Exception and check if its cause contains the "ORA" string and return that (something like "ORA-00001"). The problem here is that the exception I receive is nested inside other exceptions so if I don't find if it's an oracle exception I have to check into th...
So I've recently been vexed by problems similar to this one: Oracle .NET error - Wrong number or type of arguments. I know oracle is famous for its terrible error reporting, but this is a giant pain to debug -- if you have ten parameters, that's twenty things to check by hand (types and names,) not to mention the actual number of paramet...
I have an account, password and the URL. ...
I've got an application being put together with cake/php. It's pretty nice, but their data pager does this: SELECT COUNT(*) AS COUNT FROM foo f LEFT JOIN bar b ON (f.asset_group_id = b.asset_group_id) WHERE 1 = 1 Any way possible to speed this up? update: table definitions (extra columns removed): create table b...
Hi, can anyone give a simple example of a db transaction using an Intentional Shared lock, and (if can) one using an intentional exclusive lock. I'm studying them and trying to understand. Thanks ...
How do I format a data in SQL to read like this: Monday, November, 23 2009 ...
Even though It has a performance issue, may I know what is the use of correlated subquery? ...
When I run the following SQL statement: SELECT MAX(SUM(TIME)) FROM downloads GROUP BY SSN It returns the maximum sum value of downloads by a customer, however if I try to find the social security number that that max value belongs to by adding it to the select statement: SELECT SSN, MAX(SUM(TIME)) FROM downloads GROUP BY SSN I get ...
I would like to be able to connect to Oracle 10.1.0.2.0 (which is installed on different machine) via python. My comp is running on Ubuntu 9.04 Jaunty with Python 2.6 installed. I have downloaded and unpacked instantclient-basic-linux32-10.1.0.5-20060511.zip , set LD_LIBRARY_PATH and ORACLE_HOME to point to the directory where I unpack...
There is some trigger: CREATE OR REPLACE TRIGGER `before_insert_trigger` BEFORE INSERT ON `my_table` FOR EACH ROW DECLARE `condition` INTEGER:=0; BEGIN IF **** THEN condition=1; END IF; IF condition <> 0 THEN --Here I need to break trigger or event or smth to prevent --INSERT to be done ...
I am loading / inserting data into oracle table , in case of special characters like chinese language characters, i am getting an error like row rejected because maximum size of column was exceeded, i am not getting this error for rows which have english characters which appear to be of same length for same column. I am using SUBSTR and ...
Is a cursor created with oopen (from the Oracle 7.x OCI api) forward-only and read-only? Thanks, Eric ...
Hi, i m having a little syntax problem in my query (simplified) : select * from table1 t1 inner join table2 t2 using (pk1) inner join table3 t3 using (pk2) where not exists (select1 from table4 t4 where t4.pk1 = t1.pk1) By using the "using" keyword, oracle doesnt allow table identifier in front of the column name (eg : t1.pk1, only p...
We have some Materialized views in our Oracle 9i database that were created a long time ago, by a guy no longer working here. Is there an easy (or any) method to determine whether Oracle is using these views to serve queries? If they aren't being used any more, we'd like to get rid of them. But we don't want to discover after the fact...
I'm writing some migration scripts for an Oracle database, and was hoping Oracle had something similar to MySQL's IF EXISTS construct. Specifically, whenever I want to drop a table in MySQL, I do something like DROP TABLE IF EXISTS `table_name`; This way, if the table doesn't exist, the DROP doesn't produce and error, and the script ...
What are the means to schedule automatic "analyze tables". Is it possible to request an automatic "analyze tables" when a lot of data change througt insert and deletes? What are the means to parametrize the automatic analyze tables process, i.e. to set rules when it should be triggered. ...
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 to export urf-8 data to a text file in form of insert statement. I've tried Oracle SQL developer's export data tool. But it use ansi encoding to export data to txt file so utf-8 characters turn to "?" mark. I wonder how whether it's possible to use utf-8 encoding to export data ? Thank you. ...
I'm building a J2EE web apps with Oracle database. The app server uses JDBC connection pooling to Oracle database A (e.g. 20 connections max), and some of the queries performed use tables in remote Oracle database B via database link. If the App Server creates 20 connections to database A, and all queries are looking up data in datab...