Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa IoC oracle vs sql
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


asok kumar
oracle vs sql
1 Answer(s)      3 years and 6 months ago
Posted in : IoC


what is the difference between oracle and sql


Advertisement
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
Advertisements
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
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
Oracle - SQL
Oracle  Oracle Begginers , if Downloadable Notes are there Please mention the site
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
oracle - SQL
oracle  what is the difference between sql *plus and isql *plus
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://www.roseindia.net/programming/books/Freejavabooks.shtml 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
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
sql
difference between sql and oracle  what is the difference between sql and oracle
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
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
oracle conditions
oracle conditions  can you briefly explain about the "EXISTS" condition in SQL with examples
JETM vs Jprofiler
JETM vs Jprofiler  Can anyone explain the difference between Java Execution Time Measurement(JETM) and Jprofiler
Interface vs abstract class
Interface vs abstract class  Hai, Is there any possible to defining abstract methods in Interface
compiler vs interpreter
compiler vs interpreter  "compiled program executes faster especially if the program contains loop" Why
ejb vs hibernate - EJB
ejb vs hibernate  1>>> If we have ejb entity bean why we need hibernate? 2>>> Is hibernate distributed
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
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
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
sql server - SQL
sql server  what is SQL server? & what is oracle? are they same
 

 

 

DMCA.com