How to use TextPad to write prompt in SQL
Posted: Mon Aug 05, 2002 2:28 pm
Hi,
I have difficulty using the prompt command in Oracle SQL plus in
TextPad. The same command worked in the direct SQL prompt does not work in TextPad. Do you have any idea why?
define parm1=&1
select * from vicki_path where vp_uid = &&parm1
/
Thanks
Dave
I have difficulty using the prompt command in Oracle SQL plus in
TextPad. The same command worked in the direct SQL prompt does not work in TextPad. Do you have any idea why?
define parm1=&1
select * from vicki_path where vp_uid = &&parm1
/
Thanks
Dave