what is oracle?

Question

what is the meaning of oracle and what is the difference between oracle and sql ?

Answer 1

1.) Oracle is made up of a set of processes running in your operating system. These processes manage how data is stored and how it is accessed. I will cover these processes in detail in the future; but for now we just need to understand that Oracle is a program that is running in the background, maintaining your data for you and figuring out where it should go on your hard drive.



In almost all relational databases, data is accessed through SQL, or Structured Query Language, and Oracle is no exception. SQL allows you to SELECT your data, INSERT new records, UPDATE existing records and DELETE records you want to get rid of. SQL can be embedded in other languages or you can run scripts of SQL directly against the database.



2. ) Based in Redwood, California, Oracle Corporation is the largest software company whose primary business is database products. Historically, Oracle has targeted high-end workstations and minicomputers as the server platforms to run its database systems. Its relational database was the first to support the SQL language, which has since become the industry standard.

Along with Sun Microsystems, Oracle has been one of the leading champions of network computers.





Some of Oracle's tools to access the database and create programs are:



SQL*Plus

It has a command line interface. With it, you can access the database and write stored procedures, you can run SQL commands to retrieve data and you can run scripts of either SQL, PL/SQL or built-in SQL*Plus commands, or a mixture of those three things.



Oracle Developer

It is a 4GL GUI application Builder. With Developer, you can create forms, reports, and graphics. Oracle*Forms and Oracle*Reports are two components of Oracle Developer. Earlier versions created client-server applications, but the more recent versions create web applications that run under the Oracle Application Server (OAS). OAS is a web-based application server sold by Oracle. OAS is licensed separately and is very expensive (as are its closed source competitors). The current version is OAS 10g.

Answer 2

Oracle is a company which makes database mangement systems , and one of the products of the company is oracle .

Sql stands for structured query language which is a part of Oracle

Sql together with so many other things like PL/SQL , dbInitializer,etc etc make up the entire Oracle Package !



Oracle in English means forteller or a place where u can see ur future ! :)

any further doubts or questions just call up Larry Ellison

Answer 3

Oracle or Oracle Corporation is one of the largest IT companies based in Redwood, California that delivers wide range of software and hardware products. Often by Oracle people mean Oracle database that is a core software product of Oracle Corporation. In fact Oracle as a company started only with Oracle RDBMS. Oracle database is a proven leading Relational Database Management System that cavers around 50% of that market.



--Kirill Loifman, http://www.dadbm.com

Answer 4

Oracle (in ancient Greece, someone in touch with the deities; from Latin, oraculum or divine announcement) says it is the world's leading supplier of software for information management but it is best known for its sophisticated relational database products (notably Oracle9i), which are used in Fortune 1000 corporations and by many of the largest Web sites. Oracle's relational database was the world's first to support the Structured Query Language (SQL), now an industry standard.

Answer 5

a depiction of THE Oracle? i think of you may suited ask for some rationalization. probability is they mean the Oracle at Delphi. Granted this grow to be nevertheless a guy or woman, yet they have been housed interior a small temple-like shape. An Oracle is in simple terms a fortune teller. somebody by way of whom the fates could desire to be divined and the decide on of the gods stumbled on.

Answer 6

In the context you are using it oracle is actually Oracle, as the name of a company. This company is the number one maker of databases. SQL is a language to form a query of databases, so that is why you might hear about them together.

Answer 7

An Oracle database is collection of data treated as unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Oracle Database 10g,released in 2003 and the current release, enables grid (the g in 10g) computing. A grid is simply a pool of computers that provides needed resources for applications on an as-needed basis. The goal is to provide computing resources that transparently scale to the user community, much as an electrical utility company can deliver power to meet peak demand by accessing energy from other power providers’ plants via a power grid. Oracle Database 10g further reduces the time, cost, and complexity of database management through the introduction of self-managing features such as the Automated Database Diagnostic Monitor, Automated Shared Memory Tuning, Automated Storage Management, and Automated Disk Based Backup and Recovery. One important key to Oracle Database 10g’s usefulness in grid computing is the ability to provision CPUs and data.

Answer 8

Oracle is a Relational Database system (RDBMS) where is sql is a language. In simple terms sql is a language and oracle is a database which uses sql language.



Hope this helps.

Answer 9

Actually oracle is bundle of softwares wich is used for databse management.



SQl is a part of oracle.

Answer 10

Well i donn't know the difference buy orcale is new computer language which has codes and bla bla for programming