I have a passion for meta-queries, by which I mean queries that answer questions about data rather than answering with data. Before I get a lot of justified criticism, I do realize that the approach of meta-queries is not ideal, as eloquently described here for example. Nevertheless, I believe they do have their place. (So much so that ...
I am going on a job interview and have zero experience with MS SQL Server. However I have 1 year with Oracle. Is there such a huge difference between the two? What programming questions can I expect? ...
The sum of sm$ts_free.bytes and sm$ts_used.bytes is not equal to sm$ts_alloc.bytes. What can be the reason behind it? ...
Hi all, I am using BLOBs in my SPRING-Hibernate application its, giving "java.lang.ClassNotFoundException: oracle.sql.BLOB" in case of ORACLE as a database! Exactly I am getting following: Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: Couldn't initialize OracleLobHandler because Oracle driver classes are not ...
Whenever I load a java class, I will get this error on my open sessions when I call a member of the class. Is it possible to avoid this? ORA-29549: class MH.Tbs has changed, Java session state cleared ORA-06512: at "MH.TBS", line 2 ORA-06512: at line 4 29549. 00000 - "class %s.%s has changed, Java session state cleared" *Cause: A c...
I am trying to create an index in Oracle, my ddl : create index OMD_DOCTEXT2_CTX on table_name(col_name) indextype is ctxsys.context local parameters ('datastore CTXSYS.FILE_DATASTORE filter ctxsys.null_filter lexer E2LEX wordlist E2WORDLIST stoplist E2STOP section group E2GROUP') parallel 4; I am getting error : ORA-29855: error oc...
Lets say i have: create type address as object ( line1 varchar2(50), city varchar2(50), member procedure insert_address(line1 varchar2, city varchar2) ) / create table address_table of address; create type body address as member procedure insert_address(line1 varchar2, city varchar2) is begin insert into address_...
I'm running a program that creates a table and then inserts some data. This is the only program that accesses the database. I'm getting ORA-08177 randomly. Actual code is somewhat complex, but I've written a simple program that reproduces this behavior. using System; using System.Data; using Oracle.DataAccess.Client; namespace orabug...
I'm trying to export/import data in .csv format using SQLDeveloper. The source and destination databases are Oracle 11g. I'm having a hard time with the date formats. In the exported .csv, I see dates like: 31-AUG-09 11.54.00.000000000 AM I'm trying to figure out the appropriate format string, but I don't know what the last elemen...
I am experiencing a very strange problem This is a very simple use of JDBC connecting to an Oracle database OS: Ubuntu Java Version: 1.5.0_16-b02 1.6.0_17-b04 Database: Oracle 11g Release 11.1.0.6.0 When I make use of the jar file JODBC14.jar it connects to the database everytime When I make use of the jar file JODBC5.jar...
How does the data in a database in the field get upgraded because a new version of the software is being released? For an example, consider look up data. Usually the look up data associates an ID (number) to a name (string) and then this ID is referenced in other tables instead of the the ID directly (i.e. normalized). There are other ty...
Is there a good+easy way to convert an Oracle Timestamp to an NSDate object on the iPhone? I have asked my customer to give me a DB with timestamps as Unix Timestamp (doubles with 0 = start of 1970) but it seems to be a problem for them. Thanks. Note: You can easily convert a Unix Timestamp to an NSDate with [NSDate dateWithTimeInter...
I have two very large tables and I need to process a small resultset from these tables. However, processing is done in several functions each and function must do some joining in order to format the data in proper way. I would definitely need to cache the initial resultset somehow so it can be reused by the functions. What I would like ...
Hi all, at my work we are presently looking for a automated build tool. We have googled quite a bit, but there are so many possibilities we are not sure which tool is the best option, to be honest. We are not even sure there is one that fits our needs. It should have as many as possible from following features: Integration with Subv...
Has anyone able to successfully used NHibernate with Oracle Lite,If yes can you tell me what do we need to mention in hibernate.cfg.xml , I mean which dialect and how do we connect to it. Thanks. ...
I have tables Building and Address, where each Building is associated with 0..n Addresses. I'd like to list Buildings with an associated Address. If a Building has several entrances, and thus several Addresses, I don't care which one is displayed. If a Building has no known addresses, the address fields should be null. This is, I want ...
I have the following query in oracle that I want to use in hibernate but cannot work out how to use the rownum variable in an inner query. The query is as follows: select emp.prof_key, emp.prof_display_name from empinst.emp emp where emp.prof_key IN (select x.object_key from (select event.object_key as object_key ...
I have a query that joins two tables. One table has a column that is of type varchar, and the other table has type of number. I have executed my query on 3 oracle databases, and am seeing some strange results I hope can be explained. On two of the databases something like the following works. select a.col1, b.somecol from tableA a i...
If i have a type x_typ and subtype y_typ, is it possible to create a an object table of x_typ but put a constraint on one of the y_typ attributes i.e. create table x_table of x_typ ( constraint constr_y check (y_typ.attribute1 < 5); ); Thanks ...
hello, I've an Oracle database with two schemas. One is old and another is new. I would like to update the old schema with the new columns of the new schema. I get the tables which have changes with the following query. select distinct table_name from ( select table_name,column_name from all_tab_cols where owner = 'SCHEMA_1' minus s...