Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Pass a PL/SQL variable into SQL DEFINE
I want to pass variable wkday from a PL/SQL function into a SQL
variavle, but can not make it work. I need the result 'dir =
h:\Backup\WED'. Do you know how to do it?
Thanks a lot.
define kk = :wkday
define dir = 'h:\Backup\&kk'
prompt &dir
![]() |
![]() |