How to execute OS(operating system) command from pl/sql?
Answer Posted / 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 View All Answers
What do you think about pl/sql?
What is oracle sql called?
what is 'trigger' in sql? : Sql dba
What is the use of %rowtype?
What is normalization in a database?
Why do we use partitions in sql?
Why do we use procedures?
how to get @@error and @@rowcount at the same time? : Sql dba
What are the steps for performance tuning.
What are the advantages of pl sql over sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How many sql statements are used?
What has stored procedures in sql and how we can use it?
Differentiate between syntax and runtime errors.
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...