oracle vs sql


oracle vs sql

asok kumar
oracle vs sql
1 Answer(s)      7 years ago
Posted in : IoC

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.


Related Tutorials/Questions & Answers:
oracle vs sql
oracle vs sql  what is the difference between oracle and sql
Java vs Oracle Connectivity - JDBC
Java vs Oracle Connectivity  Write a java program to establish connection with oracle database?  Hi Friend, Use Oracle with Java... are using oracle oci driver,you have to use: Connection conn
oracle - SQL
oracle  what is meant by redo log file?  Hi Friend, In Oracle, a redo log file is used with each database. It records all changes made... to replay SQL statements. Thanks
Oracle - SQL
Oracle  Oracle Begginers , if Downloadable Notes are there Please mention the site
oracle - SQL
oracle  what is the difference between sql *plus and isql *plus
Oracle - SQL
Oracle  I have one .dmp file. I want to import this file into oracle 9i and oracle 10g. wat is procedure and stepts. thanks u  Open... D:\oracle\ora90\BIN\imp type this command if your are using oracle 9i
Derby vs MySQL - SQL
Derby vs MySQL  Hi, I want to know what are the advantages using Derby Database over MySQL.
oracle - SQL
oracle  can you suggest me a book regarding oracle and java even..  Hi friend, For more information on Oracle and Java Books visit to : http
oracle - SQL
) from employee)); In Oracle, you can use the following query: select max
Sql query from oracle
Sql query from oracle  Please help me that I want to get the table names form the existing database who does it having eid coloumn plz provide me query in oracle database
Data types in Oracle 9i - SQL
Data types in Oracle 9i  Cn anyone tell me the difference between timestamp wih time zone and timestamp with local timezone datatypes in oracle 9i.  Hi Friend, On Using TIMESTAMP WITH TIME ZONE, oracle store timezone
jsp page connectivity with oracle - SQL
connectivity jsp with oracle. Please send the code for solving problem. thanks  Hi Friend, 1)Import the packages: 2)Load the oracle driver...: a) If you are using oracle oci driver,you have to use: Connection connection
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
java oracle connection problem - SQL
java oracle connection problem  I have successfully made connection with the oracle10g database that i am using and also able to put in data using JSP. But the codes that i have tried for fetching the data are not working even
difference between sql and oracle  what is the difference between sql and 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 Books
;    Advanced Oracle PL/SQL Programming Steven Feuerstein's first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL
oracle conditions
oracle conditions  can you briefly explain about the "EXISTS" condition in SQL with examples
sql server - SQL
sql server  what is SQL server? & what is oracle? are they same
websphere vs weblogic
websphere vs weblogic  websphere vs weblogic Why you are using websphere instead of weblogic
encapsulation vs abstraction
encapsulation vs abstraction  what is the difference between encapsulation and abstraction
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
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
Accept command in Oracle
Accept command in Oracle In this section we will see how to use the Accept command in SQL Plus. The ACCEPT command in SQL Plus is used to take the input from... to substitute some value in the sql command. Usage of the ACCEPT command:  ACCEPT
ejb vs hibernate - EJB
ejb vs hibernate  1>>> If we have ejb entity bean why we need hibernate? 2>>> Is hibernate distributed
ejbSelect() vs ejbHome() - EJB
ejbSelect vs ejbHome  Hi, 1) What are the differences between ejbSelect() and ejbHome...() business methods in CMP bean? 2) In Ed Romans Mastering EJB 3rd edition, it is mentioned that ejb finder methods