1. Where does sql statements processing takes place? In server or client machine?
2. Where does Pl/sql Statements processing takes place? In server or client machine?
Printable View
1. Where does sql statements processing takes place? In server or client machine?
2. Where does Pl/sql Statements processing takes place? In server or client machine?
client sends the commands to the server only after it passes through syntax check . The rest of the procesing is done at the server.
Pl/sql statments are processed by plsql engine.
Follow some good books for further details.
All the Sql satametent processed at server side but the verfication of syntex will happen at client side.
A simple answer to you is in you machine dont install Sql server while make anothere system(server) that have Sql serve and then make a application that need sql query execution , you can find you soultion own by own.