Oracle Corporation is a multinational computer technology company mostly known for its "Oracle" RDBMS and - since the acquisition of Sun Microsystems - for Java and MySQL.
0
votes
0answers
19 views
Oracle SQL Query with Additional Summation Columns [migrated]
Suppose I have a table that has USER_ID and a AMOUNT columns. For each row, there could be a positive or negative amount in the AMOUNT column.
I'm looking for a way to select from this table such ...
3
votes
2answers
221 views
In what order are rows fetched absent ORDER BY clause?
One programmer is testing and comparing the same application which uses the same database structure, and the same data, only in two separate databases, one with Oracle 8 and one with Oracle 9.
The ...
3
votes
3answers
93 views
Real world analogy for a clustered index
A db index is analogous to a table of contents. This helps me understand db index in an easy way. My question is are tehre any real world analogies for a clustered index?
0
votes
1answer
161 views
How to justify efforts to make capitalization of class and property names uniform? [closed]
In this thread, an Oracle Product Manager (username "Alex Keh") refused to make Oracle's EF provider to conform with .NET's PascalCase coding standard for class names and property names, saying that ...
2
votes
1answer
209 views
Is this Java Compiler error message incorrect? (byte loss of precision)
The following IMHO valid java program doesn't compile because the Oracle 1.7 javac compiler thinks there's a possible loss of precision in lines 5 and 6. If you uncomment line 3 and comment out line ...
0
votes
0answers
40 views
What would be the best way to refactor/rewrite a large base of plsql packages?
Let's suppose I have a large set of Oracle plsql packages and functions written in a period of 10+ years.
They are really hard to debug and maintain, and as the application grows we find it harder ...
1
vote
1answer
235 views
How does MySQL blob actually work?
This is a question driven by curiosity. I am learning Oracle database and Oracle database handles Blob data in a separate tablespace, which I believe reduces overhead while trying to read large Blob ...
0
votes
1answer
639 views
Oracle Database Integration with Team Foundation Server?
So my company is using TFS and SQL to Manage their Database (MS SQL Server). It integrates with the nightly build servers to do builds and produce scripts to build the entire Database. Also the ...
1
vote
0answers
349 views
.NET software design and Oracle ODP.NET UDT
I'm working on a new common .NET software design (mainly) for WCF-based web service applications with related client frontends (all written in C#). As far I've chosen some frameworks ...
0
votes
2answers
214 views
What is the equivalent of Entity Framework in the world of Oracle shops? [closed]
Within the world of developers/firms specializing in building/deploying solutions built around software built/sold by Oracle (aka "Oracle houses"), what ORM middleware is considered as the "industry ...
2
votes
1answer
151 views
Sorting rows off an autoincrementing primary key
Is it a bad practice to rely on an auto-incrementing primary key to sort rows in a table? A coworker and I were having an argument about this subject. We need to be able to find the last-inserted row ...
2
votes
5answers
436 views
Should heavy binary files not be stored in database? [closed]
I was asked an interesting question: Should a database contains all data? Or heavy binary files should be stored in file system?
Example of heavy binary files : videos or heavy pdf files (+200 MB)
...
1
vote
1answer
231 views
For PL/SQL, do large companies prefer ANSI SQL joins or old Oracle joins? [closed]
I am interviewing for a PL/SQL position with a large corporation. I will have to write a multiple choice exam. I am wondering whether the exam will likely use old-style joins (joining happens in the ...
2
votes
1answer
65 views
Reporting and handling asynchronous process errors to a client
I have a product with two separate applications. The core of the product lives in the database (oracle) and runs according to a schedule. The other is a client application (currently ASP.NET MVC3) ...
1
vote
2answers
250 views
DB API for shell scripting (any shell)
I am faced with some legacy shell scripts that run batch data processing jobs in Oracle using SQL+. For the most part, the data tier does not have to communicate back to the script with retrieved ...
