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.

learn more… | top users | synonyms

0
votes
0answers
8 views

what should be in tnsnames.ora and sqlnet.ora for a local database? [migrated]

here is my tnsnames.ora file # Every line that begins with # is a comment line # # Create Oracle net service names, or aliases, for each database server # you need to connect to. # # ...
-2
votes
0answers
15 views

Linux variable inside string, using linux variables inside data pump query [migrated]

I am trying to use oracle data pump to export rows of table because the table contains CLOB column and import them to another db. I have linux shell which is used to run the expdp query. The only ...
0
votes
1answer
149 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 ...
2
votes
3answers
58 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
220 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
122 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 ...
2
votes
2answers
697 views

What are your thoughts on the Oracle Master (old Sun Certified Java Developer) Examination? [closed]

Has anyone done the Oracle Master (old SCJD) Examination? What are your thoughts on this examination? Is it worth taking it? Not really from the point of learning anything (as I doubt I will), but ...
5
votes
4answers
3k 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 ...
4
votes
2answers
1k views

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

As far as I know, Oracle's RDBMS is one of the few (the only?) SQL database products that doesn't support identity/autonumeric columns. The alternative offered by Oracle is database sequences, a ...
16
votes
10answers
2k views

Will Java be dead if the split into free/premium JVM happens? [closed]

According to http://www.theregister.co.uk/2010/11/06/oracle_dueling_jvms/ there is a possibility that Oracle really will kill Java split Java into Free and Premium JVMs. My Questions Do you think ...
4
votes
2answers
386 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
134 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
202 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
226 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 ...
3
votes
2answers
3k 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 ...
0
votes
0answers
67 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
444 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 ...
1
vote
3answers
589 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?
1
vote
2answers
993 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 ...
0
votes
1answer
1k 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 ...
7
votes
1answer
517 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
0answers
564 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 ...
1
vote
2answers
282 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
180 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
574 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
272 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
82 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
286 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
2k 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
282 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
2k views

Fast extraction to text file from oracle database [closed]

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 ...
0
votes
1answer
987 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?
4
votes
3answers
638 views

Middle tier language for interfacing C/C++ with db and web app [closed]

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 ...
6
votes
3answers
347 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
310 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 ...
1
vote
2answers
248 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
658 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
1k 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
186 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 ...
1
vote
1answer
3k 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
271 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 ...
5
votes
2answers
459 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
6answers
1k 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 ...
5
votes
9answers
6k 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 ...
-3
votes
2answers
651 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 ...
4
votes
2answers
313 views

Oracle Tutorial

I am a very experienced SQL Server developer who is being thrust into an Oracle heavy environment. I want very much to start being useful and productive and need to get up to speed. I can read the ...
2
votes
3answers
289 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
262 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
454 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 ...
4
votes
2answers
148 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 ...