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 are all the common sql functions?
Can ddl statements be used in pl/sql?
When to use inner join and left join?
Does SQL*Plus contains pl/sql Engine?
How subquery works in sql?
i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6
What packages are available to pl/sql developers?
How many columns should be in an index?
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
What type of join is sql join?
what are the features and advantages of object-oriented programming? : Sql dba
How do I view stored procedures?
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)