Oracle sql给一列赋值,[原创]oracle和SQLSERVER的多字段赋值

create table tablea(id int,ip varchar(15),apps varchar(10))insert into tablea select 23,'127.0.0.1','aaa'godeclare @Variable1 varchar(15),@Variable2 varchar(10)select @Variable1 = ip ,@Variable2 = apps from tablea where id = 23select @Variable1,@Variable2godrop table tablea

SQLSERVER的多字值赋值方式如上所示，直接SELECT就可以

但在ORACLE的PLSQL下 select into

只能赋值单个变量，不能进行多变量同时赋值。

如 : select count(*) into

nb_count from t_khz where fzbh=V_fzbh;

多变量赋值一般采取游标FETCH的方式：

cursor c_rw is select * from t_kh r_rw c_rw%rowtype;open c_rw; loop fetch c_rw into r_rw; exit when c_rw%notfound;dbms_output.put_line(r_rw.khbh||' '||r_rw.khxm||' '||r_rw.yzbm); end loop; close c_rw;

还有就一种方式就是用ROWTYPE

-- Local variables here i integer; v_kh t_kh%rowtype;begin -- Test statements here select * into v_kh from t_kh where rownum=1; dbms_output.put_line(v_kh.khbh||' '||v_kh.khxm||' '||v_kh.yzbm);end;