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



Home Answers Viewqa IoC oracle vs sql

Have Programming Question? Ask it here!
 
 
 


asok kumar
oracle vs sql
1 Answer(s)      2 years and 10 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
Oracle - SQL
Oracle  Oracle Begginers , if Downloadable Notes are there Please mention the site
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  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
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
encapsulation vs abstraction
encapsulation vs abstraction  what is the difference between encapsulation and abstraction
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
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
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
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
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
java vs .net - Java Beginners
java vs .net  which language is powerful now java or .net
sql server - SQL
sql server  what is SQL server? & what is oracle? are they same
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
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
why to use hibernet vs jdbc
why to use hibernet vs jdbc  plz send me the reply   Hi... specific 2) Hibernate is a set of Objects so there is no use of sql whereas in JDBC there is a use of SQL. 3) As Hibernate Supports two level of cache, you
Oracle - JDBC
Oracle fetch variables  i wanted to fetch variables from database using Oracle
Order of list in java Vs Haskell.
Order of list in java Vs Haskell.  How to order of [1,2,3] to [1,2,3,2,1]in java
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
oracle 18/04/2013
oracle 18/04/2013   Why it is called as structured query language
Oracle BLOB
Oracle BLOB  Can anyone send me the code for inserting an image or audio into the oracle database using BLOB datatype. Plz...it's useful for my project
PHP Comma vs Period - PHP
PHP Comma vs Period  Explain PHP Comma vs Period. And also how can one show a comma within a comma separated file.   Hi Friend, Please visit the following link: http://www.roseindia.net/tutorial/php/phpbasics/PHP
oracle - JDBC
oracle  sir iam hari iam doing the project using oracle with jdbc in xp when iam inserting the data it is giving error like ora-01034:oracle not available sir plz.......give me the solution it is urgent sir thanku
oracle problem
oracle problem  Hi I have installed oracleXE on my system and for reasons i've uninstalled them and am not able to stop oracle xe services and i could'nt reinstall it. I couldnt reinstall my os for this as it is in my office
return 0 vs exit 0
return 0 vs exit 0  what is the difference between return 0 and exit 0 in c? i could not find any difference in their behaviour (both terminates the process execution) in a program
Hibernate Native vs Hibernate JPA
Hibernate Native vs Hibernate JPA  What is the difference between Hibernate Native vs Hibernate JPA?   Hibernate is ORM framework which you can use in your application. You can also use Hibernate as Persistence
oracle - JDBC
to store these two fields into oracle database for that i have given one jsp page... it is giving error like java.sql.SQLException:[MICROSOFT][ODBC Driver for oracle][oracle
oracle connectivity
oracle connectivity  con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr"); i have error on above line when i tried...=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr
oracle - JDBC
oracle  How to collect the backup of tables in oracle? plz,, i want some tables in oracle of one system to be shifted to the another system...;There are two .exe files in ORACLE, with the FOLLOWING names,generally
 

 

 

DMCA.com