Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
41 views

Approach to work with large XML - Oracle - Java - File

We have got a client that wants a large amount of data in XML format. The Xml is roughly like so : Employee |- Emp Criminal History |- Emp Address |- Address history |- Emp Partner |- ...
1
vote
2answers
68 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
1answer
245 views

Strategies for managing legacy data for a medium sized enterprise

I work for a mid market manufacturing company with around 1700 internal employees and about 7000 external users (employees of our customers). We grew through acquisition which means we have many ...
1
vote
0answers
150 views

How to Investigate the difference between query execution times?

I have a simple query, when executed directly in SQL Developer Studio (It's an Oracle Database) takes around 4 seconds. But when executed via my Java code it takes around 20 seconds. I'm using ...
2
votes
1answer
161 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
1answer
40 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 ...
1
vote
1answer
129 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 ...
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 ...
-2
votes
1answer
169 views

Upgrading CLASSIC ASP application to PHP

I have an application built on ASP Classic & Microsoft Access (for the Database) which I have been maintining for a long time, but now I want to upgrade it to PHP for the betterment. Maintainence ...
1
vote
0answers
358 views

Is Java for server runtimes like JBoss EAP / Wildfly still free to use? [closed]

With Oracle starting to collect license fees from different customers for using Java SE I've asked myself if the usage with a server runtime is still free. I'm no lawyer and all these licenses are ...
-2
votes
1answer
130 views

If a type is defined as not instantiable in Oracle, can a table of that type be created?

If so, what is meant by not instantiable? If not, what other restrictions apply? What is the advantage of declaring a method as not instantiable in a supertype? When is this useful?
10
votes
1answer
932 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 ...
0
votes
2answers
44 views

what is a better approach in replicating data from table to another? triggers or a third party ETL tool?

We have multiple tables which we need to retrieve data from and dump to one centralized table. Currently what we are doing is running an ETL job made from Pentaho, retrieve the records from the source ...
0
votes
1answer
318 views

A large Oracle database with no foreign keys [closed]

I am struggling to understand the design of an Oracle database that I have been working with for the past 9 months. The database is for our business management system and I work with it mostly for ...
2
votes
3answers
1k 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 ...
1
vote
2answers
4k 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
0answers
56 views

Database data Bucketing Report Design

Here's the scenario: I have item x (item_id, customer_number, cost) which can be submitted to another system multiple times over months which may or may not reject item x before finally accepting it ...
3
votes
2answers
1k 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 ...
15
votes
7answers
6k 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-...
1
vote
1answer
2k views

Using JDBC to asynchronously read large Oracle table

What strategies can be used to read every row in a large Oracle table, only once, but as fast as possible with JDBC & Java ? Consider that each row has non-trivial amounts of data (30 columns, ...
0
votes
1answer
1k views

What happens if computer crashes after giving commit command

If we are updating a field in SQL and ALTER the row also. After giving the COMMIT command, the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table ...
1
vote
3answers
652 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
1answer
249 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 ...
0
votes
1answer
1k views

How would you create useful tests for Oracle BI Publisher reports?

I'm curious about how to test reports that seem rather straightforward. I'm supposed to create test cases for an Oracle report(XML Publisher/BI Publisher). So for example, a report is supposed to just ...
10
votes
2answers
6k 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
858 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
432 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
408 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,...
0
votes
1answer
1k 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
7k 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
1answer
2k 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 (NUnit,Autofac/...
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 ...
2
votes
1answer
333 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
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) ...
0
votes
1answer
501 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
159 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
603 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 ...
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? ...
1
vote
2answers
294 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, ...
1
vote
1answer
2k views

Modular Database Structures

I have been examining the code base we use in work and I am worried about the size the packages have grown to. The actual code is modular, procedures have been broken down into small functional (and ...
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
252 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 ...
5
votes
5answers
1k 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 ...
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 ...
0
votes
1answer
9k views

how to compare two large sets of data using PL/SQL?

I have two different tables in two separate databases with around 1.5 million records each. (BTW: im working on oracle databases) The objective is to check if every record present in table A is ...
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 ...
6
votes
6answers
5k 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 ...
2
votes
2answers
437 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 ...
4
votes
3answers
615 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 ...
7
votes
3answers
663 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 ...