oracle vs sql

Ads
 

oracle vs sql

what is the difference between oracle and sql

View Answers

July 4, 2011 at 4:12 PM

1)SQL stands for Structured Query Language while Oracle is one type of database software sql.

2)Sql is a common language for DBMS,RDBMS,ORDBMS.It is a language used to query( insert/retrieve/delete/update) the records in database while Oracle is a software package, that is used to handle or to maintain the database.

3)Transaction control. In Oracle, everything is a transaction and it is not permanent until you commit.In SQL Server, there is (by default) no transaction control. An error half way through a stored procedure will not rollback the ddl in previous steps.

4)MVCC. SQL Server will allow dirty reads, and writes can block reads in MS SQL (Again, it's configurable but the default in SQL Server is for performance and not read consistency, while in Oracle, read consistency is default and unbendable.

Ads









Related Tutorials/Questions & Answers:
oracle vs sql
oracle vs sql  what is the difference between oracle and sql
Derby vs MySQL - SQL
Derby vs MySQL  Hi, I want to know what are the advantages using Derby Database over MySQL.  http://www.roseindia.net/eclipse/plugins/database/index.shtml
Advertisements
Pagination in jsp using oracle and not sql
Pagination in jsp using oracle and not sql  I need the code for pagination in jsp using oracle. I already tried it with rownum between instead... query1="SELECT SQL_CALC_FOUND_ROWS * FROM student limit "+iPageNo+","+showRows
sql
difference between sql and oracle  what is the difference between sql and oracle
oracle
oracle   sir now am doing one project , my frond end is vb and backend is oracle. so 1> how can i store the image in my field 2> how can i back up the table into .txt file
getResourceAsStream() vs FileInputStream
getResourceAsStream() vs FileInputStream  getResourceAsStream() vs FileInputStream
oracle conditions
oracle conditions  can you briefly explain about the "EXISTS" condition in SQL with examples
websphere vs weblogic
websphere vs weblogic  websphere vs weblogic Why you are using websphere instead of weblogic
SQL
SQL   1)How to Store 1000 records in Oracle object. 2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble. 3)What is Sequence. 4)How to use rowid in Sql. 5)What is Views. 6)How
encapsulation vs abstraction
encapsulation vs abstraction  what is the difference between encapsulation and abstraction
compiler vs interpreter
compiler vs interpreter  "compiled program executes faster especially if the program contains loop" Why
Interface vs abstract class
Interface vs abstract class  Hai, Is there any possible to defining abstract methods in Interface
JETM vs Jprofiler
JETM vs Jprofiler  Can anyone explain the difference between Java Execution Time Measurement(JETM) and Jprofiler
Oracle Tutorial
. Oracle SQL Statements SQL statement is a string that contains the SQL text. SQL...Oracle Tutorial In this section we will discuss about the Oracle Database. This tutorial will describe you about the Oracle Database. This section
auto sql script - SQL
auto sql script  Is there a way of generating inserts scripts using the table structure for oracle database
sql
sql  how to get first row in sql with using where condition in sql? how to get last row in sql with using where condition in sql
inheritence Vs inheritence
inheritence Vs inheritence  what are difference b/w c++ inheritence and java inheritence   Hi Friend, C++ supports Multiple Inheritance while Java does not. Thanks
java vs vb
java vs vb  history of java and advanced products as well as vb? compared with java and vb? finalize list out the table of java and vb products? viewers i want more soon
portability vs platform independent
portability vs platform independent  sir, pls tell me 1.the differences between platform independent and portability related to java technology 2.how java provides security 3.how can i prove servlet is a single instance
sql
sql  I want interview sql questions   Please visit the following link: SQL Tutorials
SQL
SQL  How u did one to many & many to many mapping in oracle
ModuleNotFoundError: No module named 'conan_vs'
ModuleNotFoundError: No module named 'conan_vs'  Hi, My Python... 'conan_vs' How to remove the ModuleNotFoundError: No module named 'conan_vs... to install padas library. You can install conan_vs python with following
ModuleNotFoundError: No module named 'conan_vs'
ModuleNotFoundError: No module named 'conan_vs'  Hi, My Python... 'conan_vs' How to remove the ModuleNotFoundError: No module named 'conan_vs... to install padas library. You can install conan_vs python with following
ModuleNotFoundError: No module named 'vs-emr'
ModuleNotFoundError: No module named 'vs-emr'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'vs-emr' How to remove the ModuleNotFoundError: No module named 'vs-emr'
ModuleNotFoundError: No module named 'vs-ip'
ModuleNotFoundError: No module named 'vs-ip'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'vs-ip' How to remove the ModuleNotFoundError: No module named 'vs-ip'
Sql
Sql  how to find maximum of a101,a102,a103 from a table in sql
Scanner vs. BufferedReader
Scanner vs. BufferedReader  I have to decide from these two classes to read a file. File is of .txt type and its size is around 4.5 GB. There other text files also which is around 7 to 10 GB. So, which class is to be used to read
sql
sql  returning value from a store procedure in sql with example   Please visit the following links: http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml http://www.roseindia.net/sql/create
doGet() Vs doPost()
doGet() Vs doPost()  plz explain the differences between both of these methods used in a servlet. also give an example of both the methods. thanks.   A doGet() method is limited with 2k of data to be sent, and doPost
java with Oracle Database
java with Oracle Database  Hello I have been encountering a problem regarding creating a table with Oracle.When i am creating new table in the Database using Oracle , it is giving error saying an errror occured incursive sql
SQL
SQL  In my computer i have microsoft sql 2008.how can i set that in the cmd.i want to use that in cmd.what is the default username and password

Ads