SQL & PL/SQL

Hi All,

I need to create oracle subfolder inside oracle directory at run-time.

Suppose i have one oracle directory like this  :

Create or Replace directory my_dir as '/tmp/s1'

Now my requirement is i need to create sub directory on that folder based on emp no .

E.g.

If empno - 2215 , Directory will create like this MY_DIR\EMP_2215\

if Empno - 2216 , Directory will create like this MY_DIR\EMP_2216\

Is it possible to create directory at run time or we need to create on physical level. If yes , how can we achieve this.

Thanks