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
57 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 ...
-4
votes
0answers
60 views
Is it advisable for a beginner to choose Oracle Database 10g/PL-SQL as his first RDBMS & query language to learn? [closed]
I am new to the subject of databases and after some theoretical knowledge about RDBMS,SQL,ER Model,transactions,indexing & hashing,concurrency etc I needed a RDBMS to practice the SQL commands.I ...
1
vote
0answers
141 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 ...
-5
votes
0answers
83 views
What is the assignment and essay for the Java exam? [closed]
Is the Oracle Java exam the same as taking the CompTia exams?
0
votes
2answers
161 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
111 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 ...
1
vote
5answers
340 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
171 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
43 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
195 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
482 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
190 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 ...
6
votes
2answers
334 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
361 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
199 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?
