How to execute OS(operating system) command from pl/sql?

Answers were Sorted based on User's Feedback



How to execute OS(operating system) command from pl/sql?..

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

How to execute OS(operating system) command from pl/sql?..

Answer / nasir mehmood

HOST('Os Command') procedure will be used for this purpose.

Is This Answer Correct ?    5 Yes 3 No

How to execute OS(operating system) command from pl/sql?..

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

Post New Answer

More SQL PLSQL Interview Questions

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,


Explain cursor types?

0 Answers  


How do you explain an index?

0 Answers  


write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,


How do I add a database to sql?

0 Answers  






what is a field in a database ? : Sql dba

0 Answers  


How many clustered indexes can be created on a table?

0 Answers  


What is a transaction?

5 Answers  


Explain how to use transactions efficiently : transact sql

0 Answers  


Explain Connect by Prior?

2 Answers  


what is uncommittable transactions? : Transact sql

0 Answers  


What are the sql versions?

0 Answers  


Categories