MySQL has special table type MyISAM that does not support transactions. Does Oracle has something like this? I'd like to create write-only database(for logging) that needs to be very fast(will store a lot of data) and doesnt need transactions. ...
ResultSet rs=st.executeQuery( "select j.vc_jo_no, j.dt_jo_date, p.vc_product_name from mst_jobcard j, mst_prod p where j.vc_product_code=p.vc_product_code and j.dt_jo_date=to_char("+tdate+","+"'"+dd-mm-yy+"'"+") "); In my specified query it should display the records based o...
Hello, we have written a C# 3.5 client talking to an Oracle database (11g) using the ODP.NET. This application has a batch process where a long running task is performed making various calls to the database within a TransactionScope. On our development environment all goes well, but at the UAT environment of one of our clients (who ha...
To check the status of database servers, I use tnsping utility. Is there any similar utility for checking reports server? Thanks. ...
I have some database import and export ant scripts that run little java programs to import and export data to and from oracle 11g. The scripts used to work on Vista 32 bit, but stopped working with Windows 7 64 bit. There are two versions of ocijdbc11.dll that I can use. When I use the 64bit version the error message is: java.lang.Unsa...
I'm working on a table that has 3008698 rows exam_date is a DATE field. But queries I run want to match only the month part. So what I do is: select * from my_big_table where to_number(to_char(exam_date, 'MM')) = 5; which I believe takes long because of function on the column. Is there a way to avoid this and make it faster? other ...
SHORT VERSION: What is the best way of casting "5-" as a number for storing into a table as a number? LONG VERSION: Here is the issue, I have a table I am reading from primary made up of VARCHAR2s. I am grabbing the data from some fields and storing them in another table without modification. In one field I am getting "5-" and trying to...
I'd like to know how to archive a distributed (database) transaction between a java and a c++ application. Are there some frameworks/jdbc extensions to do this? What pitfalls may arise? The solution may be oracle-specific, but a more general approach (at least on the java side) would be prefered, if equal. ...
I have a procedure that is using a temp table. I want to get rid of the temp table and use a collection to remove I/O. it has about 5000 records. I want to insert data into this collection then I want to access the collection like: select * from table(my_type_for_gtt) I could not find an example of this. I'm confused, do I have to fi...
Table_a = 7022536 rows Table_b (GTT) = 5601 rows Query: SELECT COUNT (a.ssn_head) FROM table_a a, table_b b WHERE b.hoh = a.head AND a.flag = 'Y'; takes 20+ seconds to bring 17214 records. Explain plan is: Plan hash value: 1901401324 -------------------------------------------------------------------------------- | Id |...
I am researching the possibility of porting an application written in classic ASP with ADO record sets and an Oracle database to PHP5 and OCI8. We have lots of stored procedures and queries with bind variables for performance. My problem is that we have become lazy from using the ADO classes and the EOF and BOF indicators along with Mo...
I'm just wondering how to implement database views in Ruby on Rails. Can you guys put some working example? And thank you for every advises and examples. ...
Hello, Anyone please provide "Oracle Fusion Middleware comaprison with other leading middleware products in market" based on features, cost, etc. ...
i am running a query in oracle with CTE. When i execute the query it works fine in select statement but when i use insert statement it takes ample of time to execute.Any help here is the code INSERT INTO port_weeklydailypricesTest (co_code,start_dtm,end_dtm) SELECT * FROM ( WITH CTE(co_code, start_dtm, end_dtm) AS...
Hi, I want to store a short array of 64 bytes in Oracle database (a password hash). I thought char(64 byte) is what I need, but it seems like it doesn't work. In Microsoft SQL, I use binary and varbinary types. What type do I need to use in Oracle? Every example I've found uses blob to store binary data, but I suppose blob is intended ...
Hi, Are there any way to decompile or reverse engineer Oracle trigger? Any tools available, any free ones? Thanks! ...
I have an oracle table with nested tables in some of the columns. Now, I need to be able to update all the records in each nested table, in each of the records of the main table. How is this accomplished? Any of the ways that I've tried, I get errors about either not be able to perform updates on that view, or single row subquery returns...
Hi, I need to do a data migration from a data base and I'm not too familiar with databases so I would like some clarification. I have some documentation that could apply to either an Oracle or a SQL database and it has a column defined as NUMBER(10,5). I would like to know what this means. I think it means that the number has 10 digits ...
I am debugging an issue with a null ResultsMap returned from calling a stored procedure via iBatis for java. Here is a truncated copy of the exception I'm receiving. DataAccessException: Exception calling procedure Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in ibatis-map.xml. --- The error ...
I have just been bitten by issue described in SO question Binding int64 (SQL_BIGINT) as query parameter causes error during execution in Oracle 10g ODBC. I'm porting a C/C++ application using ODBC 2 from SQL Server to Oracle. For numeric fields exceeding NUMBER(9) it uses __int64 datatype which is bound to queries as SQL_C_SBIGINT. Appa...