How to execute OS(operating system) command from pl/sql?
- 3 Answers
- 9713 Views
- I also Faced
- E-Mail Answers
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 |
Can we use insert statement in function?
Does a user_objects view have an entry for a trigger?
what are ddl statements in mysql? : Sql dba
What is data manipulation language?
What is the difference between a database and a relational database?
how to write date and time literals? : Sql dba
Regarding joins what are the differences you observed in oracle 9i and sql server?
What is insert command in sql?
What are the various restrictions imposed on view in terms of dml?
What is t-sql? : Transact sql
Explain the two type of Cursors ?
what is organisational index?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
