More specifically I want to test whether Oracle ODP.Net is installed on a machine. I want to do this by testing for the HKLM\SOFTWARE\ORACLE\ODP.NET registry key. The actual values used by ODP.Net are stored in HKLM\SOFTWARE\ORACLE\ODP.NET\2.111.6.20 however I assume that this lower level key's name will change as updates are released b...
I have a table lnd_wkly_plan_rx_summary and columns pd_end_dt, nrx_cnt containing data PD_END_DT NRX_CNT 12/26/08 1,178.75 12/19/08 2,027.12 12/12/08 1,907.08 12/05/08 2,092.90 11/28/08 1,236.44 11/21/08 1,857.82 11/14/08 1,817.55 11/07/08 1,800.54 10/31/08 1,985.13 i need to put a join on same table lnd_...
i have a hibernate query that is dynamically put together using the criteria api. it generates queries that are unbearably slow, if executed as-is. but i have noted they are about 1000% faster if I prepend /*+ FIRST_ROWS(10) */ to the query. how can i do this with the criteria api? i tried criteria.setComment(..), but this seems to be ...
How do I index a foreign key in Oracle? ...
SELECT A.PD_END_DT Recent_PD_END_DT, B.PD_END_DT Last_PD_END_DT, A.NRX_CNT - B.NRX_CNT DELTA FROM wkly_lnd.lnd_wkly_plan_rx_summary A, wkly_lnd.lnd_wkly_plan_rx_summary B WHERE a.MKT_I D =b.MKT_ID; ...
I have two tables say (FCT_SALES_SUMMARY_A and FCT_SALES_SUMMARY_B). If we assume that table A has be generated on every monday than table B will be generated on next monday i.e after 1 week.like that there will be data for 104 weeks.But the as the weeks increase the previous data will be lost in FCT_SALES_SUMMARY_A as shown below i.e...
We have two databases, in two separate locations. One of the databases resides in a separate time zone than our users. The problem is that when the database that is located in a separate time zone is updated, with a Date value, the database automatically subtracts 1:00 hour from the Date it was passed. The issue is that, when passing ...
I just recently moved a SQL DB from SQL2005 32 bit --> 64 bit. I am having an issue connecting to Oracle using the OraOLEDB.Oracle Provider. I was able to install Oracle 10G Client , ODAC 64 bit. I was also able to add a linked server to the Oracle instance. I am able to run a query using the linked server name directly: SELECT top 1...
Hi I have a table that look like this : username | privilges user1 privilge1 user1 privilge2 user1 privilge3 user2 privilge1 user2 privilge5 user2 privilge3 etc ...... i would like to group privliges based on similarity in percentage to other user . for example in the table : user1 and user2 has...
I have this table which doesn't have a primary key. I'm going to insert some records in a new table to analyze them and I'm thinking in creating a new primary key with the values from all the available columns. If this were a programming language like Java I would: int hash = column1 * 31 + column2 * 31 + column3*31 Or something l...
I need to maintain state in a PL/SQL application. It needs to hold a small table during the session. As I understand it, this is accomplished via a package variable, but I don't know how to create a table as a package variable. Anyone explain how to do this or alternatives? Expansion of Problem I have a WHERE IN condition that I must ...
I have a table like this: create table foo ( a number, b number ) I want to update all the columns from a with the value that is in another table create table bar ( x number, y number ) So, if this would be a procedural programing language I would: foreach foo_item in foo foreach bar_item in bar if( foo_item.b =...
I have to get a list of limits for a the sub-parts of a level 1part. Limits for some parts are null, and for those null parts, I have to query the level 2 parts that are on that part and give the MIN of the limits of those level 2 parts. For some of the level 2 parts, I have to get the MIN of their sub-parts (the level 3 parts on that ...
I'm trying to connect to a local oracle database but I'm getting this cryptic error message: Invalid Oracle URL specified: OracleDataSource.makeURL. I'm pretty sure this is due to an error with the database connection parameters I'm passing, but really, this error message does not help me in any way. Any hints as to what I'm doing wron...
Hi all, could you point me to a good place to start with Oracle stored procedures syntax/usage? I can't seem to find any good place there. I'm fairly proficient in (java, C/C++) programming and I do know enough SQL for my needs right now, but I've been suggested to use stored procedures to do my business, which is: Take results from a q...
All my development life I have only worked with MySQL for extended periods of time, and for a client we now need to work with an Oracle database for some performance testing and tuning. Any obvious pitfalls in moving from working with MySQL to Oracle I should watch out for? The things I discovered so far: There is only one database W...
I know in Access there is a way I can visualize the relationship between tables in a diagram - kind of like an ER diagram. I am new to Oracle. I am wondering if I can do the same/similar thing with Oracle. Could someone give some suggestions? ...
I like to save different c# data types in a Oracle database (int, decimal, double, string, Guid, …). Does anyone have a table showing what oracle data types to use? I have found tables showing what c# data types to use for different oracle data types but not the other way around. ...
If I have table with a Date column called "myDate", with values like "2009-08-25 09:00:09.0". I want to select all rows for Aug 25, from 12:00:01 AM until 11:59:59PM and NOTHING for Aug 26. Is it sufficient to simply use the condition: where myDate between Date '2009-08-25' and Date '2009-08-26' And I want to select all rows BEFORE Au...
I was thinking of using AUTONOMOUS_TRANSACTION Pragma for some logging in a batch process. Does anyone have any experience with this ? If so any pros and cons would be appreciated. ...