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 |
Do View contain Data ?
Explain the use of constraints option in exp command.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to connect to a remote server?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
does the query needs a hint to access a materialized view?
8. Display the client name and order date for all orders using the natural join keywords.
How to pass a cursor variable to a procedure?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How is it different from a normal table?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3