pl/sql in oracle10g express edition?

Question

Frnds....do any of u know the way to run pl/sql scripts saved in specified location of pc in sql prompt of oracle 10g expression edition..If not can u specify the exact location to save those sql scripts wrt to this edition.. ????

Answer 1

Hi,



Are you talking about SQL script or PL/SQL script?



When we are saving any sql or pl/sql script, default it will store in user's default location. Any SQL or pl/sql script you can execute using @ and saved script name in sqlplus. If you don't provide specific location then it will call from default location.



@test.sql <= it will call default location.

@d:\scripts\test.sql <= it will call from d:\scripts folder.



For getting default location of user in windows, kindly check cmd in windows. You can get default location of user in cmd (command line of windows).



For getting default location of user in Unix/Linux, check your shell prompt using command pwd. You will get default user location.



But if we are talking about stored pl/sql then it would stored in database itself. Then you should need to execute using "execute" command in sqlplus.



Example:

execute dbms_system <= it will execute dbms_system pl/sql procedure from database.



I think this would be helpful to you.



Thanks and regards,

Gitesh Trivedi

http://www.dbametrix.com/service.html

Answer 2

Improve Your Running Technique Now!

Answer 3

the convey version is decrease down for inner maximum use, to get used to the kit and which you would be able to verify to software. in case you should make purposes for human beings you will the two could purchase the pro version, study C, C++ or something comparable and get a compiler. i be attentive to VB is ordinary to verify yet MS might desire to make some money for his or her efforts... pitiful in spite of the incontrovertible fact that they may well be sometimes.