I'm using ODP.NET to access Oracle DB from C# .NET. Please see following code: OracleConnection con = new OracleConnection(); con.ConnectionString = "User Id=user;Password=pass;Data Source=localhost/orcl"; con.Open(); /* create table */ DbCommand command = con.CreateCommand(); command.CommandType = CommandType.Text; try ...
Hi everyonoe, I have installed Oracle Client 10g 32 bit and ODAC 11g R2 on my Windows 7 machine, but I cannot see any Oracle Providers in MS ODBC Administration or when I try to created a linked server to Oralce in SQL Server Management Studio or in Visual Studio 2010. Can anyone please help me out as what to do? I can connect to Oracle...
Hi Guys, I'm still new to SQL (Oracle).. Basically on a table I'm selecting from, there is a time stamp, and some are valid stamps and some are not (stored on a time stamp table).. I have a function I can use in 'where' clauses to return only the valid or invalid ones. But sometimes I need to see all the records with an additional colu...
In the Oracle JDBC driver, there is an option to cache prepared statements. My understanding of this is that the prepared statements are precompiled by the driver, then cached, which improves performance for cached prepared statements. My question is, does this mean that the database never has to compile those prepared statements? Does ...
I'm trying to move data from an Oracle (10g) database to SQL-Server (2008). I also want the indexes to be re-created on the SQL-Server side. However, in Oracle, there is a primary key defined on the first two fields, and it has data like this: VALUE3 FOO4 VALUE4 FOO8 Value4 Foo8 When I get that data to SQL Server, it won't mak...
Hi all, Environment: 11g db server The "SQLNET.ENCRYPTION_SERVER" value is not taking from the configuration file it is taking the default value "ACCEPTED" instaead of "REQUIRED". After the changes done through net manager I have restarted the listener. Please advise where I need to make the changes. Trace file: 2010-09-22 19:11:13...
I am using Oracle SQL Developer. I am using parameters &TableName My query comes back to me in the results with an OLD: tag before it, and again with a New: tag (the variable is replaced with the value that I have typed in) and then my results follow this. How do I get rid of this annoying return and change it to just display my resul...
In my app, I handle numbers as BigDecimal and store them as NUMBER(15,5). Now I'd need to properly check on Java if the BigDecimal values would fit the column, so that I can generate proper error messages without executing the SQL, catching exceptions and verifying the vendor error code. My database is Oracle 10.3, and such errors cause ...
I have a connection leak in some older Java web applications which do not utilize connection pooling. Trying to find the leak is hard because IT will not grant me access to v$session SELECT Count(*) FROM v$session; So instead I am trying to debug with System.out statements. Even after closing the connection conn.close(); when I print c...
I have to load 46 tables with data using SQL Loader for Oracle. All the data files are CSV. The column order in the CSV matches the column order in the table. I need to create a control file for each table. What is the best way for me to mass produce these files? ...
How do find duplicate rows? If last_name is the duplicate field, I want to have to display last_name frst_name frst_name1 frst_name2 .... Any database will do, prefer oracle. ...
I have an Update query that recalculates -every- column value in exactly one row, each time. I've been seeing more row-level lock contention, due to these Update queries occurring on the same row. I'm thinking maybe one solution would be to have subsequent Updates simply preempt any Updates already in progress. Is this possible? Does ...
I am a PHP developer with little Oracle experience who is tasked to work with an Oracle database. The first thing I have noticed is that the tables don't seem to have an auto number index as I am used to seeing in MySQL. Instead they seem to create an index out of two fields. For example I noticed that one of the indexes is a combinati...
I have two select statements and make 'union all' for these two statements. Then, I use the PreparedStatement and when I setString to this preparedStatement, it shows "java.sql.SQLException: Missing IN or OUT parameter at index:: 2". After I toured around google, some people say that for each "?" in sql statment, I should write setStri...
Can someone explain how to see the results of a procedure, everything is working fine and the code is valid, executed and compiled with no errors. Now how can I see the results as Query or anything. The ex procedure is about sum of salary. CREATE OR REPLACE PROCEDURE HR.TOTAL_SALARY AS total_salary NUMBER(12,2); BEGIN ...
Hi, In my program I need to access the schema of an Oracle 11g database. I have been trying to get a list of tables using a query like this: SELECT t.TABLE_NAME, t.OWNER FROM ALL_TABLES t WHERE t.DROPPED = 'NO' ORDER BY t.TABLE_NAME The query works and I get back a list of tables. Unfortunately when querying some of the tables using ...
is view in database updatable ? if yes , how ? if no, why ? ...
As far as I know, when using JDBC, it is not possible to remotely call Oracle procedures that have records or booleans as arguments. I wonder if there is any, not necessarily Java-based, interface that does not have such limitations. I know about JBublisher, but I'd rather there was some way that would not require to install any wrappers...
I am using oracle database. If have a large transaction to make (700 tables, million rows , data size will be around 100G) what are the parameters to be fined tuned? The oracle server has disk space of 250G, 32G RAM. (Is this a question for superuser/serverfault? Please move) ...
I have a table table_a with a column containing data as follows: .aaa01932 .asd02343 .lkj03342 So it always starts with a period followed by 3 letters, followed by 2 number (01, 02 etc) followed by some extra numbers. I have another table table_b with data as follows: aaa01 asd02 lkj03 So it maps to the data in table_a but with th...