Is there anything special I need to do when installing the oracle 10 client software on a windows cluster? The client is needed to provide access to an oracle db from a sql server as a linked server. Should it be installed to a shared disk, or is it ok to install on local storage? ...
I have a string from oracle table like this: SELECT col1 FROM MyTable; col1 part1;part2;part3 .... How can I get a substring from col1 such as part2? SELECT col1, INSTR(col1, ';', 1, ...) SubStrPart2 // string func? col1 SubStrPart2 .... part2 Not sure what string functions I can use here so that I can easily upd...
I'm SELECTing some aggregate data and grouping on the date and a particular field. I want to display all values in that field and a count for those values even if there was no data matching that field on that day. E.g. Date MyField Count 2009-09-25 A 2 2009-09-25 B 0 2009-09-24 A 1 2009-09-24 B ...
How do I build oracle pl/sql query dynamically from a java application? The user will be presented with a bunch of columns that are present in different tables in the database. The user can select any set of column and the application should build the complete select query using only the tables that contain the selected columns. For exam...
Hi all, Can you please give some tips or guidelines, best practices for MicroSoft SQL server to Oracle Data Migration? IMHO, it is something that comes best with experience. So I would like to benefit from your experience. Please share any insights that you have into design, modeling, testing or tuning for a data migration project. I wo...
I want to find the largest sale for each of my employees (and display the name of the employee). In MySQL, it's pretty straightforward: select * from employee, sale where employee.id = sale.employee_id group by employee_id order by sale.total desc This does pretty much what one would expect, it would return a list of emplo...
Hi all, I realise there are some similar questions on here already but I couldn't see one that matched my problem so I'm afraid I had to ask a new question. I have a webservice running on a server, which is throwing a ORA-12154: TNS:could not resolve the connect identifier specified" error. However when I log onto the said server i am ...
I've got an sql query that selects data from several tables, but I only want to match a single(randomly selected) row from another table. Easier to show some code, I guess ;) Table K is (k_id, selected) Table C is (c_id, image) Table S is (c_id, date) Table M is (c_id, k_id, score) All ID-columns are primary keys, with appropriate FK ...
Not sure if that makes sense, but say I have this code... $updateSql = oci_parse($conn, 'update "table" SET "column"=:column where "Unique_Record_Id" = :Unique_Record_Id'); OCIBindByName($updateSql, ":Unique_Record_Id", $absenceData['Unique_Record_Id']); OCIBindByName($updateSql, ":column", $column); if(oci_execute($updateSql)){ // np...
Is there a way to exclusively lock a table for reading in Oracle (10g) ? I am not very familiar with Oracle, so I asked the DBA and he said it's impossible to lock a table for reading in Oracle? I am actually looking for something like the SQL Server (TABLOCKX HOLDLOCK) hints. EDIT: In response to some of the answers: the reason I nee...
I have over 1.500.000 data entries and it's going to increase gradually over time. This huge amount of data would come from 150 regions. Now should I create 150 tables to manage this increasing huge data? Will this be efficient? I need fast operation. ASP.NET and Oracle will be used. ...
I have the following oracle statement which is giving compilation errors. v_percent_deceased_households := CASE WHEN NVL(v_total_households, 0) > 0 THEN (CAST(NVL(v_deceased_households_count, 0) AS FLOAT(53)) / CAST(NVL(v_total_households, 0) AS FLOAT(53))) * 100 ELSE 0 END; Errors are: Error: PLS-0010...
I would like to copy parts of an Oracle DB to a SQL Server DB. I need to move the data because the Oracle box is being decommissioned. I only need the data for reference purposes so don't need indexes or stored procedures or contstaints, etc. All I need is the data. I have a link to the Oracle DB in SQL Server. I have tested the f...
I have a column in a non-partitioned Oracle table defined as VARCHAR2(50); the column has a standard b-tree index. I was wondering if there is an optimal way to query this column to determine whether it contains a given value. Here is the current query: SELECT * FROM my_table m WHERE m.my_column LIKE '%'||v_value||'%'; I looked at Ora...
Hai all, I have a table tbl_1 with fields fl_1 (varchar2 type), contain Hexadecimal format. Now i want validate (query) where is in Hexa format and where is not. any idea in oracle script (SQL Syntax)? CREATE TABLE TBL_1 (HEX VARCHAR2(20)); INSERT INTO TBL_1 VALUES('9851010A'); INSERT INTO TBL_1 VALUES('9851010B'); INSERT INTO TBL_1...
I was trying to compile a PL/SQL package and I got the following error: ORA-04043: object SYS_PLSQL_77721_489_1 does not exist After this, I can no longer recompile or drop the package. Do you have any suggestions? ...
Is it possible to organize asynchronous data exchange with separate files (transportable tablespaces maybe) using Oracle Streams? I.e, is it possible to organize offline replication using files? ...
We are using System.Data.OracleClient and the abstract base classes DbConnection, DbCommand (etc) to connect to Oracle. The connection works fine in our development stages. During staging we encounter the error ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. Our goal was to connect without...
Hello, I have found this web site really helpful since everybody helps here with the best answers. Now, i need a suggestion. I hope you would help me as before. I need to develop an ASP.NET application with oracle database. Database server is physically separated from the application server. Now my question is which technology is prefer...
I'm running queries that look something like this: INSERT INTO foo (...) VALUES (...) RETURNING ROWID INTO :bind_var SELECT ... FROM foo WHERE ROWID = :bind_var Essentially, I'm inserting a row and getting its ROWID, then doing a select against that ROWID to get data back from that record. Very occasionally though, the ROWID won't b...