oracle和SQL SERVER的多字段赋值简析

2012-4-27 14:38 534 0

摘要: [sql] create table tablea(id int,ip varchar(15),apps varchar(10)) insert into tablea select 23,...

关键词： select Variable varchar rw 变量 tablea into rowtype 方式 kh

[sql] create table tablea(id int,ip varchar(15),apps varchar(10)) insert into tablea select 23,'127.0.0.1','aaa' go www.2cto.com declare @Variable1 varchar(15),@Variable2 varchar(10) select @Variable1 = ip ,@Variable2 = apps from tablea where id = 23 select @Variable1,@Variable2 /* --------------- ---------- 127.0.0.1 aaa (1 行受影响) */ go drop table tablea SQLSERVER的多字值赋值方式如上所示，直接SELECT就可以但在ORACLE的PLSQL下 select into 只能赋值单个变量，不能进行多变量同时赋值。如 : select count(*) into nb_count from t_khz where fzbh=V_fzbh; 多变量赋值一般采取游标FETCH的方式： [sql] cursor c_rw is select * from t_kh www.2cto.com 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 [sql] -- Local variables here i integer; v_kh t_kh%rowtype; gin -- Test statements here www.2cto.com select * into v_kh from t_kh where rownum=1; dbms_output.put_line(v_kh.khbh||' '||v_kh.khxm||' '||v_kh.yzbm); d; 摘自无为的专栏

声明：文章版权归原作者所有部分文章转自互联网如有侵权请联系 [邮箱地址] 删除