Home » SQL & PL/SQL » SQL & PL/SQL » Shaad
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>
Previous Topic: Carriage Return in Oracle?
Next Topic: dynamic SQL -HELP !!!!!!
Goto Forum:
  


Current Time: Fri Mar 29 05:53:53 CDT 2024