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
1answer
105 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 ...
-4
votes
0answers
103 views
why do Oracle package up Java with the ask toolbar [closed]
The short answer is because they make money (I assume they get commission for every click?).
But it devalues the "brand" and annoys everyone who install its.
Is their any logical reason for Oracle ...
0
votes
0answers
20 views
Oracle Compilation Error [migrated]
I am a SQL Server guy trying to piece together a basic PL/SQL procedure, and I can't seem to get the thing to compile.
I am sure it is something small, any help is greatly appreciated!
CREATE OR ...
0
votes
1answer
106 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
205 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
171 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
126 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
361 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
195 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
49 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
203 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
1answer
552 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?
...
0
votes
2answers
205 views
Do I need to know databases like Oracle or SQL Server for a data analyst role? [closed]
I know only MySQL and do web application programming and Linux system administration. I have also started learning AI and machine learning.
I want to go into data analysis.
Do I need to know MS SQL ...
4
votes
4answers
426 views
Is there a recommended order to take the Oracle Java EE certification exams?
I recently passed the Oracle Certified Professional, Java SE 6 Programmer examination. Now, my boss would like me to take "the next step" to broaden my competence. I tried to explain that there is no ...
0
votes
1answer
432 views
How to check for null in most sql's - “column is null” or “column = null” [closed]
I'm not sure of the right syntax to use.
Is it
select * from tlb
where flag is NULL
or
select * from tlb
where flag = NULL
Is the answer the same for oracle, sqlserver and Postgres?
1
vote
1answer
201 views
Are any live online Oracle Instances available for learning PL/SQL? [closed]
I want to learn Pl/Sql but do not have Oracle installed in my system. Are there any live instances to which I can connect to?
3
votes
2answers
869 views
Fast extraction to text file from oracle database
I have to extract around 3 million records from two different databases for further processing. Currently, I execute the queries via SQL*Plus and spool the results to a plain text file.
This queries ...
7
votes
1answer
310 views
Are there tools that do automated validation of database standards?
I'm looking for something akin to FxCop, but for databases. Basically, I want to have a tool where I configure my database standards (naming conventions, field types, or more complex custom rules). ...
1
vote
2answers
231 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
363 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 ...
2
votes
2answers
619 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 ...
2
votes
4answers
159 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
225 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
228 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
2k 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 ...
-1
votes
2answers
239 views
Time Tracking app direction [closed]
I was recently handed this test by a recruiter. I have a week to complete it in order to get an interview. I already know HTML/CSS, Javascript, and PHP/MySQL. I'm a little overwhelmed. If I need to ...
4
votes
2answers
289 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 ...
1
vote
1answer
574 views
Oracle Project Ideas [closed]
I'm looking for project ideas to improve my skills on Oracle tools.I don't want to develop project just like an application which has connection a database.I already developed such projects.I'm ...
5
votes
6answers
502 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 ...
1
vote
2answers
641 views
Oracle Enterprise JavaBeans (EJB) Developer Certification
I would like to gain the "Oracle Enterprise JavaBeans (EJB) Developer" certification.
According to this page I have to take a number of classes each of which costs up to a couple of thousand GB£.
Is ...
-1
votes
2answers
581 views
How can I get vampire numbers [closed]
In class we have a big trouble, how can we get the first "n" vampire numbers, we're working on oracle SQL but in my case I am totally lost, how can i do a query to get it.
A "vampire number" is a ...
1
vote
2answers
187 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 ...
3
votes
2answers
196 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
430 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 ...
5
votes
6answers
484 views
Middle tier language for interfacing C/C++ with db and web app
I have a web application requiring a middle-tier language to communicate between an oracle database and math routines on a Linux server and a flex-based application on a client. I'm not a software ...
4
votes
2answers
140 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 ...
3
votes
0answers
70 views
BPEL migration project [closed]
We have ported a BPEL set of projects (22 composites), originally created from another provider, to our solution for a client. Currently we are planning to migrate all pending (running) instances from ...
3
votes
5answers
287 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 ...
5
votes
5answers
328 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 ...
3
votes
4answers
123 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 ...
15
votes
2answers
701 views
What is Oracle's commitment to Java?
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, ...
7
votes
3answers
495 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 ...
0
votes
2answers
445 views
Oracle Java SE Certification
Which exam(s) should be given for Java certification from Oracle.
is Oracle 1Z0-851 exam old SCJP ?
Recommend book which covers Oracle 1Z0-851 exam?
2
votes
2answers
2k 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 ...
4
votes
9answers
4k 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 ...
6
votes
2answers
2k views
Why are Oracle directories named /u01 /u02 etc…?
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 ...
5
votes
1answer
1k 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?
5
votes
3answers
2k 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?
2
votes
3answers
249 views
Free/low-cost online resources to study for certifications [closed]
So I am interested in working towards are few specific certs. Namely Oracle 11g, MySQL, and Java. I know there are tons of books out there, and I do plan to hit up my local library on these subjects ...
3
votes
2answers
377 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, ...
