Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is The different between PL/SQL and SQL*Plus?

Re: What is The different between PL/SQL and SQL*Plus?

From: Chuckster <chuckycarson_at_networkcloud.com>
Date: Wed, 12 Mar 2003 08:30:39 -0800
Message-ID: <3E6F60AF.5020202@networkcloud.com>

Jay wrote:
> What is The different between PL/SQL and SQL*Plus?
> Can anyone give me some examples???
> Thanks
>
>

SQL*Plus is merely a DBA tool, usefull for manipulating teh database. Normally only DBA and developers would use SQL*Plus.

PL/SQL is 'scripting language', so to speak. It allows procedures and etc.. to be stored in oracle that contain greater logic than possible with SQL alone. It is a very usefull tool.

Sorry my explanation isn't more detailed but the big difference is that one is a tool and one is a 'language'. (however, SQL*Plus also has it's own syntax within itself)

-Chuck

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Mar 12 2003 - 10:30:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US