Hello All,

I want solution to following problem:-

1. How can I use Operating System command from within PL/SQL? Please explain
with Example.

2. Can I use IF clause within SELECT statement? If yes kindly give the syntax
details? Also provide an example.

Can anyone provide me help.