How to execute OS(operating system) command from pl/sql?
Answers were Sorted based on User's Feedback
Answer / sourav
From Unix OS type the following command :
SQL>!ls
From Windows the command is :
SQL> HO[ST] [command]
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / nasir mehmood
HOST('Os Command') procedure will be used for this purpose.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / praveen
You would need to wrap OS command under External Procedure.
Read more about PL/SQL External Procedures on how the same
works.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is application trigger?
What does where 1/2 mean in sql?
pl/sql testing means what ...... explain process how to find pl/sql bugs
How many types of relationship are there?
how many tables will create when we create table, what are they? : Sql dba
What is crud sql?
What do you mean by stored procedures? How do we use it?
what is column? : Sql dba
how to create user in sql and how to set password for that?
What is an exception in pl/sql?
What is error ora-12154: tns:could not resolve the connect identifier specified?
how to findout the 100th maximum salary
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)