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 a cursor ? Why Cursor is required ?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
How does a self join work?
Why cross join is used?
tell us something about heap tables. : Sql dba
What is mutating sql table?
can i call procedure in package
What's the difference between inner join and left join?
What are pl sql data types?
What is materialised View?
How do I add a database to sql?
in materialized view the structure will create immediately or not?
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)