PL/SQL Variable Question

How do you assign, from the row of data that you have selected with a rowtype variable, just the data from one column into a variable? Here is an example

SQL> variable li_deptname varchar2(20); SQL> declare

    	li_dept      dept%rowtype;
   	begin
           		select * into li_dept
           		from dept
           		where deptno = 40;
  	 end;

In the dept table exsits a loc column, how do I get only data from that one column and assign it to the host variable li_deptname?

Thanks in advance

SS
‰

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Nov 21 1998 - 20:35:02 CST