Title: ampersand problem
Why is this code not working for me
declare
code number(3):=0;
edate date;
begin
code:=111;
edate:=to_date('01-01-2001','dd-mm-');
dbms_output.put_line('actual data '||code ||','||edate);
@abc code edate
dbms_output.put_line('hello');
end;
/
abc.sql
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);
@abc code edate
dbms_output.put_line('hello
||','||my_date);
end;
/
-Original
Message- From: Swapna_Chinnagangannagari Sent: Friday, October
05, 2001 12:27
PM To: '[EMAIL PROTECTED]' Subject:ampersand problem Why
is this code not working for me
declare code number(3):=0; edate
date; begin code:=111; edate
Hi Gurus,
declare
v_empno number:=empno;
v_sal number:=sal;
ok1 varchar(1);
begin
dbms_output.put_line('Do you want to update the sal...(Y/N)');
if (upper('ok1') = 'Y') then
update emp set sal=v_sal where empno=v_empno;
end if;
end;
In the above code
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 the
