Re: Oracle Jargon

On Thu, 25 Apr 2002 08:12:13 GMT, "Sted Alana" <Sted_Alana_at_hotmail.com> wrote:

>

<snip>
>One last question regarding the query tools (SQL, SQL*PLUS, SQLLOADER,
>PL/SQL etc.). To me it seems that the tools are a database itself because
>you can create tables that hold data (.sql files), so why need the database
>part?
>

Nooo.

The tools are tools. The database is the database. The database is where the data is. The tools are the programs you use to manage objects or data that is in the database.

If I start SQL*Plus and issue a CREATE TABLE command, I'm not createing the table *in* SQL*Plus, I'm *using* SQL*Plus as a tool to create a table in the database. If I save that command in a .SQL file, that is simply a text file holding a command to be executed by a tool. The SQL file is not the data, nor is it a table that holds the data, nor is it the database

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)