details to send this oracle jobs
and its profit
and difference between oracle and Sql
2007-01-08 19:44:44 · 4 answers · asked by raj 1 in Computers & Internet ➔ Software
Oracle is a database management system software that is one of the most powerful database programs in the world.
SQL stands for Structured Query Language, and Oracle IS a SQL. You may be referring to Transaction-SQL, or TSQL though. The differences are noticable but either works. Some differences include different query commands. Oracle is more powerful in what it can perform, and it's one reason most business prefer Oracle over TSQL; however, Oracle is quite expensive over TSQL.
2007-01-08 19:54:02 · answer #1 · answered by Scott B 2 · 0⤊ 1⤋
Comparing Oracle to SQL is comparing apples to oranges.
Oracle is a RDBMS (relational data base management system) and SQL is Structured Query Language. SQL is used by many RDBMS for accessing and manipulating data and not just Oracle. INGRES, SYBASE, MSSqlserver and DB2 all use SQL.
Oracle architecture requires more than an answer here to cover. It is a course on its own.
If I get your meaning, I wouldn't advise trying to understand the architecture from he replies here and then apply for an Oracle position.
2007-01-10 15:34:13 · answer #2 · answered by Elizabeth Howard 6 · 0⤊ 0⤋
The Oracle Database Management System (DBMS) consists of several components (loosely similar to UNIX's implementation of the multitasking operating system):
* “Databases” have two parts:
o data files, and
o Instances (the “brain" of the system) provide the capability of accessing stored data. Each instance consists of:
+ memory areas in RAM used by
+ system processes (software servicing requests) and user applications
* Interfaces, such as the SQL*Net driver connecting to the DBMS to begin a transaction.
* Development and Query Tools managing the DBMS (such as the Enterprise Manager and The Database configuration Assistant); and
* user applications making use of the whole thing.
* Oracle core software and scripts in the folder specified by the $ORACLE_HOME environment variableanother page on this site and in Windows Registry key HKEY_LOCAL_MACHINE /SOFTWARE /ORACLE.
For Detail information see
http://72.14.235.104/search?q=cache:nKKB8tLaam0J:www.oracle.com/technology/tech/migration/isv/docs/OracleArchitectureOverview.pdf+Oracle+Architecture&hl=en&gl=in&ct=clnk&cd=7
2007-01-09 12:02:15 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Oracle is database which holds information of customers, people or any other things which you feed them. Take example of vote bank of a country. Thousands of people & their information needs to get store somewhere. Oracle helps to manage that data efficiently. Oracle architure is the way it manages that data internally & how it manipulates that efficiently.
2007-01-09 04:27:40 · answer #4 · answered by Anonymous · 0⤊ 0⤋