1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

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

what is primary key? : Sql dba

0 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

what is overloading procedure or overloading function ?

3 Answers   Genpact,

What is the difference between left join and right join?

0 Answers  

What is offset and limit in sql?

0 Answers  




suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

What is sql dialect?

0 Answers  

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

Define the select into statement.

0 Answers  

How do I add a database to sql?

0 Answers  

How do I start pl sql?

0 Answers  

What is input buffer in sql*plus?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories