Probably about 300K rows. Using SQL and/or PL/SQL. Would it be best to copy/convert into an interim format in a temporary table, work on it and then import it back in? The updated data would need to remain as a 'long' datatype because we don't have the resources (or inclination) to fix the DB. Thanks. ...
From what I understand, the best way to deal with dates in the Zend Framework is to select them as a Unix timestamp from the database. Quick Creation of Dates from Database Date Values // SELECT UNIX_TIMESTAMP(my_datetime_column) FROM my_table $date = new Zend_Date($unixtimestamp, Zend_Date::TIMESTAMP); I think it's a pain that there...
Okay, I have reached a sort of an impasse. In my open source project, a .NET-based Oracle database browser, I've implemented a bunch of refactoring tools. So far, so good. The one feature I was really hoping to implement was a big "Global Reformat" that would make the code (scripts, functions, procedures, packages, views, etc.) standard...
So I was reading up on indexes and their implementation, and I stumbled upon this website that has a brief explanation of b-tree indexes: http://20bits.com/articles/interview-questions-database-indexes/ The b-tree index makes perfect sense for indexes that are only on a single column, but let's say I create an index with multiple colum...
How many maximum number of connections can oracle handle ? The following is a summary for my sql, i need similar stats for oracle : The maximum number of connections MySQL can support depends on the quality of the thread library on a given platform, the amount of RAM available, how much RAM is used for each connection, the workload fro...
I'm currently looking for a good (free) tool to do some PL/SQL development on Windows against an Oracle XE database. I'm looking to develop some stored procedures, functions and packages, and need decent debugging capabilities (breakpoints, variable inspection etc.). For the SQL side of database stuff, I've been using the TOADfree tool,...
The only thing I don't have an automated tool for when working with Oracle is a program that can create INSERT INTO scripts. I don't desperately need it so I'm not going to spend money on it. I'm just wondering if there is anything out there that can be used to generate INSERT INTO scripts given an existing database without spending lo...
I have an Oracle 10g database with about 11,000,000 rows of data. It's good for our usually performance tests, but I now have to test our app for a customer that will have an estimated 350,000,000 rows of data. Is there a tool or technique that I can use to "bulk up" the tables in my database to this size? Ideally, I'd like to use the e...
I have a DB table in which each row has a randomly generated primary key, a message and a user. Each user has about 10-100 messages but there are 10k-50k users. I write the messages daily for each user in one go. I want to throw away the old messages for each user before writing the new ones to keep the table as small as possible. Righ...
I want to migrate schema from Oracle to MySQl, so are the any free tools that would be useful for this task ? I have only Create tables in Oracle SQL Script but it contains unique constraints, foreign key and MySQL has MyISAM storage engine and so foreign key is not supported, how to go about this issue ? Sample Oracle create statments...
Here is my situation: I have one table that contains a list of drugs sold containing the NDC (an identifier), quantity sold, and whether the drug is a brand name or generic. I have another table that contains the prescription numbers, dates, and NDCs. I need to generate a list of the most recent 4 prescription numbers for the top 50...
how do we execute an Oracle Stored Procedure from SQL Server 2005? As part of a SQL Server scripts we need to execute an Oracle 10g Stored Procedure and download data to SQL Server 2005 ...
How to make procedure that update 5 table's ? for ex: ....update table1 set field1 = ....... ....update table2 set field2 = ....... ....update table3 set field3 = ....... in oracle 10g - pl/sql ...
Can you confirm if you have successfully executed an oracle stored procedure from sql server using the open query function. If yes, How? because I am having problems executing stored procedures with arguments using the OPENQUERY Function. ...
i have field X that contain text with spaces in the end of the text how i can remove them ? i need it in any sql query for oracle 10g ...
In Oracle, is it possible to INSERT or UPDATE a record (a row) through a view? ...
I'm coming up against an unexpected daylight savings time problem in code I thought was purely UTC. I'm using Java 1.6, the iBatis SQL mapper (2.3.3), and Oracle XE (an eval version of Oracle 10.2) with the Oracle thin driver. The database contains a table that represents a television broadcast schedule. Each "Asset" (program) has a s...
I have table A in Oracle that has a primary key (id). I need to insert data into this table. How do I prevent duplicate rows? ...
I have the following iBatis mapping for an Oracle Stored Procedure that returns a true/false value. <resultMap id="isAuthorizedResult" class="java.lang.Boolean"> <result property="isAuthorized" column="isAuthorized"/> </resultMap> <parameterMap id="isAuthorizedCall" class="map"> <parameter property="prgType" jdbcType="Str...
syntax: EXECUTE ( begin (LUMD_REP_APPGRC.peopledb_T2t.collect_all(SYSDATE - 40, SYSDATE ); end;) AT LUMD; error: Incorrect syntax near the keyword 'begin'. ...