CODEWITHSUNDEEP
oracle-databaseplsqloracle11g
radha
radha

Reputation: 175

PL/SQL is executed by Oracle Database not the host system

I have just started with Basics of PL/SQL and encountered with this statement and I am unable to get this .Please guide .

Upvotes: 0

Views: 189

Answers (1)

Littlefoot
Littlefoot

Reputation: 142788

If I understood what you are saying, then: PL/SQL is executed within the database which is installed on the database server.

Although you can "save" your PL/SQL code into a script which resides on your hard disk (local PC), there's no use of it - it has to be "stored" in the database. That's why we call those procedures "stored procedures". True - there are anonymous PL/SQL blocks, but they also run in the database.

Opposed to those are .SQL scripts, files you can store to your hard disk and execute them "locally" by e.g. connecting to the database via SQL*Plus, a command line tool, and call those locally stored files (if that's what you call "host system").

Upvotes: 1

Related Questions