Well, for one thing, you have MOM instead of MON in the date
format. Besides that, it might help if you describe what problem you are
having.
At 12:10 AM 10/5/01 -0800, you wrote:
>sorri i have pasted the wrong one
>here is the correct on
>
>declare
>code number(3):=0;
>edate date;
>begin
>co
Title: RE: ampersand problem
sorri i have pasted the wrong one
here is the correct on
declare
code number(3):=0;
edate date;
begin
code:=111;
edate:=to_date('01-jan-2001','dd-mom-');
dbms_output.put_line('actual data '||code ||','||edate);
@ab
Change the substitution variable in this way:
l_chk varchar2(1) :='&chk.'
And turn off the verify option of sqlplus:
set verify off
Regards.
--- Amar Kumar Padhi <[EMAIL PROTECTED]> wrote:
> This is not feasible within a PL/SQL block. Oracle
> will first prompt you to
> input value for all
This is not feasible within a PL/SQL block. Oracle will first prompt you to
input value for all the & provided in the code, before actually executing
it.
One option:
accept chk prompt 'Do you want to continue (y/n)?'
declare
l_chk varchar2(1) :='&chk';
begin
if l_chk = 'y' then
dbms_output