what is the difference between sql& oracle?
Answers were Sorted based on User's Feedback
Answer / hitesh thakur
1)sql is language used to interact with database
WHILE oracle is database system/platform uses sql to
interact with it's object
| Is This Answer Correct ? | 28 Yes | 1 No |
Answer / ravi
SQL is Stuctured Query Language.Oracle is a Database.SQL is
used to write queries against Oracle DB.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / crash_overload
SQL is a language which is used in all RDBMS(oracle,my
sql,ms-sql server)
and oracle is an RDBMS
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
oracle is a database.
sql is the mediator between the oracle and the user for data transaction.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / somu.kattikar
1.MS SQL SERVER is the MICROSOFT product , ORACLE is oracle
product.
2.SQL SERVER is platform dependent, but oracle is not .
3.In oracle we are using PL/SQL , but in SQL SERVER we
called as a batch
| Is This Answer Correct ? | 4 Yes | 3 No |
Oracle is a company and it is a database,SQL is an
structured Query Language having DDL,DML&TCL
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dsr
sql means structred query language.In oracle,sql and pl/sql
are available.
In sql->only dml,ddl,etc..
in pl/sql-->procedure,triggers,functions,etc...
| Is This Answer Correct ? | 7 Yes | 8 No |
Answer / gitanjali
sql is a structured query languagel, used to communicate
with oracle server
WHILE oracle is a Corporation ,and sql is a language
used by oracle products.
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / muniaraja m
SQL Server2000 is the product of microsoft but oracle is
the product of oracle corporation.
Plainly if you say sql means structured query language
is available in both sql server and oracle.
| Is This Answer Correct ? | 4 Yes | 7 No |
Answer / chandiran
SQL
***
1)It is a Language
2)It is Not case sensitive
Oracle
*******
1)It is a Database
2)It is case sensitive
| Is This Answer Correct ? | 2 Yes | 5 No |
In oracle there is column command, how will you explain that?
difference between imlicit cursor and explicit cursor ?
How to view the data files in the current database?
What is system tablespace?
Is oracle the best database?
What is concurrency in oracle?
what is the use of rank function?
What are the roles of dba?
What is materialized view in Oracle?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How would you extract DDL of a table without using a GUI tool?