GeekInterview.com
Series: Subject: Topic:
Question: 67 of 74

What is the major differences between Oracle & Sybase

Asked by: Interview Candidate | Asked on: Dec 24th, 2006
Showing Answers 1 - 3 of 3 Answers
sapthami_guru

Answered On : Jan 4th, 2007

View all answers by sapthami_guru

The dialect of SQL supported by Microsoft Sybase ASE is called Transact-SQL (T-SQL). The dialect of SQL supported by Oracle 9i Database is called PL/SQL. PL/SQL is more powerful language than T-SQL. This is the brief comparison of PL/SQL and T-SQL:Feature PL/SQL T-SQL Indexes B-Tree indexes,Bitmap indexes,Partitioned indexes,Function-based indexes,Domain indexes B-Tree indexes Tables Relational tables,Object tables,Temporary tables,Partitioned tables,External tables,Index organized tables Relational tables,Temporary tables Triggers BEFORE triggers,AFTER triggers,INSTEAD OF triggers,Database Event triggers AFTER triggers,INSTEAD OF triggers Procedures PL/SQL statements,Java methods,third-generation language(3GL) routines T-SQL statements , Java methods,third-generation language(3GL) routinesArrays Supported Not Supported  

Yes  1 User has rated as useful.
  
Login to rate this answer.
tuliothx

Answered On : Jul 5th, 2008

View all answers by tuliothx

Let me clarify that while Sybase does not have "Object Tables" it can hold BLOBS in columns in tables. These can be of datatype TEXT or IMAGE.Sybase has the concept of Temporary tables in the form of #temp_tables or tables residing in the tempdb database.A table in Sybase can be partitioned and external tables are handled thru "proxy" table setup.
But most importantly, the main difference between Sybase and Oracle is that
in Oracle, it manages all of the data and database related functions within ONE
big Oracle Instance. Sybase manages all of the data and database related
functions thru a collection of system databases and user databases all in ONE
Sybase server. Each database within a Sybase server can communicate with one
another, but they are compartmentalized. Where as in Oracle they are all mingle
together in one space.

Yes  1 User has rated as useful.
  
Login to rate this answer.
chrisjej

Answered On : Jun 23rd, 2010

View all answers by chrisjej

I would point out that the above answers are point in time - and any answer should mention the versions involved. Sybase is a company - not a database server, by the way. The question should be asking about Sybase ASE (or Sybase IQ or Sybase Anywhere).A question of this nature could easily merit a book.The two database servers are so ideologically different that doing feature comparisons of this nature are fairly meaningless. Oracle is, no doubt, dripping in functionality compared to Sybase ASE - however that doesn't make it the inevitable choice. Sybase ASE makes handling of multiple databases on a single server much more transparent, it requires much less in terms of support, and it's also markedly cheaper than Oracle.Sybase ASE is built around the concept of temporary tables - whereas Oracle is built around cursors and both have features that tend to support these core concepts. Sybase is fast and loose with checking things: Oracle is completely obsessive. This means Sybase is easier to change, test, and whip things up with - whereas it's also more likely to miss hidden problems.

Yes  2 Users have rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.