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 |
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?
How do you explain an index?
write sub query for eliminating duplicate rows using analytical function?
How do I add a database to sql?
what is a field in a database ? : Sql dba
How many clustered indexes can be created on a table?
What is a transaction?
Explain how to use transactions efficiently : transact sql
Explain Connect by Prior?
what is uncommittable transactions? : Transact sql
What are the sql versions?