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 |
Is nosql relational?
what are the advantages of package?
What are all the common sql functions?
What are actual parameters and formal parameters?
Explain the uses of control file.
what is the difference between a local and a global temporary table? : Sql dba
Does oracle use sql?
Is pl sql a programming language?
What is plpgsql language?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is scope and visibility in PL/SQL?
Is sql microsoft?
Oracle (3259)
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)