Shaad [message #8313] |
Fri, 08 August 2003 08:23 |
denni
Messages: 24 Registered: August 2002
|
Junior Member |
|
|
SQL> ed
Wrote file afiedt.buf
1 declare
2 v_var varchar2(10);
3 begin
4 v_var:='1234567890';
5 dbms_output.put_line(v_var||' value before using substr '||(chr(10)));
6 if substr(v_var,1,10)='1234567890' then
7 v_var:=substr(v_var,1,5);
8 dbms_output.put_line(v_var||' 1st 5 chars shown');
9 end if;
10* end;
SQL> /
1234567890 value before using substr
12345 1st 5 chars shown
PL/SQL procedure successfully completed.
SQL>
|
|
|