Questions tagged [oracle]

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.

Filter by
Sorted by
Tagged with
169
votes
21answers
155k views

Stored Procedures a bad practice at one of worlds largest IT software consulting firms?

I'm working at a project in one of the world's top 3 IT consulting firms, and was told by a DBA that company best practice's state stored procedures are not a "best practice". This is so contrary to ...
48
votes
4answers
8k views

Why are there multiple different implementations of JVM?

While going over a java book I came across this phrase: Different JVMs can run threads in profoundly different ways. While it's completely understandable to me that code can behave differently ...
32
votes
7answers
9k views

What does this statement about C# and Java being half of a language mean? [closed]

In the article: Why POCO, there is this sentence: Maciej Sobczak puts it well: “I just don’t like when somebody gives me half of the language and tells me that it’s for my own protection”. I don't ...
18
votes
7answers
11k views

500 databases or 1 database with 500 tables or just 1 table with all the records? [duplicate]

I currently have an application that is used by a single end customer. For ease of discussion assume the application only needs a single database table for all records. I now need to support multi-...
15
votes
1answer
981 views

What is Oracle's commitment to Java? [closed]

We are investing heavily in Java, but after recent experiences and reading Joonas' response on that question: Had you used those flags in Java 6, you could have experienced not only crashes, but ...
13
votes
3answers
19k views

Oracle owns Java but Google is using Java?

Ok, I don't get it. What does "Oracle owns Java" mean? Google is definitely using Java in Google App Engine, does that mean that Google have to pay Oracle for doing so?
12
votes
2answers
25k views

Why are Oracle directories named /u01 /u02 etc...? [closed]

I've been working with the Oracle RDBMS for a few years and today, after installing one for the n-th time, I was left wondering, why do we install it in /u01, /u02, etc.? Of course you could install ...
11
votes
2answers
8k 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 ...
10
votes
9answers
25k views

Is there a large bank using Mysql or PostgreSQL? [closed]

I always thought the largest scale of banks use Oracle. However, there is no proof they really use Oracle instead of Mysql or PostgreSQL, nobody knows the secret. Any idea what they really use? Can ...
10
votes
3answers
2k views

How safe it is to do minor JVM upgrades?

I have been working on the JVM for years and I have very rarely experienced a JVM crash ... that is until approx 6 months ago. Since that I have experienced approximately 5 JVM crashes resulting ...
10
votes
1answer
2k views

Partial name matching in millions of records

We have developed a web based application for name matching. It operates by breaking names into parts and the Soundex value of each part is stored in a database. The Levenshtein distance metric is ...
7
votes
3answers
928 views

Who is responsible for the development of Java?

When I google about Java, the companies most mentioned are Sun, Oracle and IBM. I know that Oracle bought Sun, and the Java official website is Oracle domain, so I can assume that Oracle is the ...
7
votes
6answers
6k views

Database Table Prefixes

We're having a few discussions at work around the naming of our database tables. We're working on a large application with approx 100 database tables (ok, so it isn't that large), most of which can be ...
7
votes
3answers
1k views

Hudson or Jenkins

We have been using Hudson for quite a while and we loved it. Now many Hudson-developers have "left the building" to create their own: Jenkins (which means the project has been forked). As Hudson/...
6
votes
3answers
1k views

Materialized View vs POJO View based on Objects representing Oracle tables

I have about 12 Oracle tables that represent data that's being integrated from an external system into my web application. This data is going to be used in an informational and comparative manner for ...
5
votes
5answers
500 views

What is a good way to reset the Primary Key?

We've hit an application issue with an Oracle table Primary Key exceeding the limits used by a Java Integer (2 ^ 32) and one of the suggestions is to reset this to 1000 and let it start again. OR ...
5
votes
2answers
1k views

How can large data handling be a special requirement for job?

I chanced to see some job requirements of Oracle SQL programmer or C# developer jobs, who want a person who can handle terabytes of data in ETL or data migration. I have worked on data migration to ...
5
votes
4answers
2k views

What's stopping Oracle from supporting identity (auto-numeric) columns? [closed]

EDIT: As gavenkoa's answer points out, Oracle Database 12c (released a couple of years after this question was asked) has support for Identity Columns. As far as I know, Oracle's RDBMS is one of the ...
5
votes
2answers
245 views

What is the equivalent of functions and methods in SQL?

In language like C or Java, there are things like functions/methods to modularize and abstract stuff. What is there in SQL, specifically for Oracle? I've seen people talking about using views to ...
5
votes
1answer
260 views

Solving file system dependency with database storage

I have a software project A which makes API calls to a third-party software B that is heavily based on data stored on the file system. Also, those software and file systems are distributed on servers ...
5
votes
5answers
2k views

Alternatives for comparing data from different databases

I have two huge tables on separate databases. One of them has the information of all the SMS that passed through the company's servers while the other one has the information of the actual billing of ...
5
votes
2answers
1k views

License of current JDK

I am wondering which license the current JDK 7 (NOT the OpenJDK) is using as I know it was once under GNU GPL but with the change of the Distributor License for Java I would like to know whether they ...
5
votes
1answer
3k views

Is "VS Lightswitch" the "Oracle APEX" from Microsoft?

What do you think? Is "Visual Studio Lightswitch" becoming the "Oracle APEX" for SQL Server in the futrure? Are these two technologies comparable?
4
votes
2answers
1k views

What are the licensing issues involved in the Oracle/Apache java dispute?

I've just started following with interest the soap opera involving Oracle's acquisition of Java and the detriment of goodwill it seems to have generated in the open source community. Specifically, I'...
4
votes
3answers
664 views

two approaches to database modeling - which one to use when

recently I have noticed a new approach to data modeling vs what I have used so far. This seems to be a way to address modeling of an entity that has a very large set of fields and quite often many of ...
4
votes
2answers
5k views

Java stored procedures in Oracle, a good idea?

I'm considering using a Java stored procedure as a very small shim to allow UDP communication from a PL/SQL package. Oracle does not provide a UTL_UDP to match its UTL_TCP. There is a 3rd party ...
3
votes
5answers
331 views

Should we rewrite it from scratch

At work, we have a software written in PL/SQL - Oracle Forms 10g, which runs the software as a Java Applet. My Company bought the software and we have to develop the software, but we feel that ...
3
votes
3answers
1k 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?
3
votes
2answers
4k views

Development environment to manage multiple Oracle databases

I am in an enterprise environment where we have applications that need to run against multiple Oracle databases. Developers may need to manage multiple vintages of these databases to support ...
3
votes
4answers
135 views

DB centric iPhone app question

The iPhone app i have an idea for deals with processing of the data stored as part of Oracle database at work. It'll be an interface to a dynamic set of data that is updated tens of thousands of time ...
3
votes
4answers
264 views

.NET app - Should we use SQL Server and duplicate some reference data from an external Oracle DB? Or use Oracle and have a DB link?

We're looking to migrate some existing Excel/Access processes into a new system which will provide the users with a Silverlight frontend to run and view the reports instead of using MS Access. The ...
3
votes
2answers
2k views

Designing a system to archive databases with referential integrity

I have a very large Oracle database, with many many tables and millions of rows. I need to delete some of the rows end-to-end. By end-to-end, I mean, if I want to delete a row from a table then I must ...
3
votes
1answer
275 views

All images on a single table. Is a good idea?

I'm making the tables for an application, and I need many tables with images. Instead of storing the BLOBS on each table, I'm thinking on storing all the images (BLOB) on a single table, to unify the ...
3
votes
2answers
328 views

Designing database job monitoring

I have several Oracle database where my in-house applications are running. Those applications use both dba_jobs and dba_scheduler_jobs. I want to write monitoring function: check_my_jobs which will ...
2
votes
5answers
1k 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) ...
2
votes
1answer
427 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 4,...
2
votes
3answers
2k views

Database view performance - good practice?

Often times at work we opt to create views in the database to expose the data that we want to work with instead of building some monster query in our code. Being somewhat new to this field my ...
2
votes
1answer
338 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
2answers
456 views

Concurrent Data Processing by Multiple People

Let's say I have a page, accessible by several people concurrently, that lists information that must be processed in some way by the user, after which it is either marked as "completed" and ...
2
votes
1answer
3k views

is Oracle ADF Mobile free? and what is it's usage scope? [closed]

I would like to know whether Oracle ADF Mobile is free to use for someone who doesn't have the (expensive) ADF license, and what if I want to talk to a backend (web service), do I need Weblogic? ...
2
votes
1answer
1k views

From Oracle to Apache Parquet : how to handle eventual consistency?

I have an existing production Oracle Database. However, there are performance issues for certain kind of operations, because of the volume of the data, or the complexity of queries. That's why I ...
2
votes
1answer
62 views

How does client connect to replication server in oracle?

I have read couple of articles on google but not sure how DB client for example java application connect to clustered DB. All the articles I read says client will write at master node but will use ...
2
votes
1answer
173 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
1answer
260 views

Who is responsible for updating the Java API and how can other individuals contribute?

I made a search on google to find out who are the people in Oracle responsible for updating the Java API in other words who are those responsible for adding new classes and methods to the API and ...
1
vote
2answers
5k views

Working with two different database types for one application [duplicate]

Software: Java J2EE Application hosted on Tomcat Server. UPDATE The current software is JAVA Web application containing just JSP and Servlets no frameworks or anything. Simple JSP and ...
1
vote
2answers
71 views

migrating data in oracle DB

I am doing data migration from DB1 to DB2. First step in that is extracting data from base tables (6 tables with one big master table which has one million records and other 5 being detail tables) in ...
1
vote
3answers
793 views

Select custom output formats from database with SQL

I am planning to make a simple rest service application, and I am currently deciding the architecture. I have decided that I want to write the middle layer in multiple languages, so that it is easy to ...
1
vote
2answers
2k 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 ...
1
vote
2answers
619 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 ...
1
vote
2answers
311 views

Oracle has some very helpful and free code...I think

I found that some of the code that Oracle uses is very useful so I don't have to re-invent the wheel. Given this is at the top of the file where the code in question is: /* * Copyright (c) 1997, ...