Multi-field assignment for Oracle and SQL SERVER

1. Create TableTablea (idInt, IpVarchar(15), appsVarchar(10 ))
2. Insert IntoTableaSelect23,'2017. 0.0.1','Aaa'
3. Go
4. Declare@ Variable1Varchar(15), @ Variable2Varchar(10)
5. Select@ Variable1 = ip, @ Variable2 = appsFromTableaWhereId = 23
7. Select@ Variable1, @ Variable2
8. /*
9. -------------------------
10. 127.0.0.1 aaa
12. (One row is affected)
14. */
15. Go
16. Drop TableTablea

The multi-character value assignment method of SQLSERVER is as shown above. You can directly SELECT

However, in Oracle PLSQL, select into can only assign values to a single variable, but cannot assign values to multiple variables at the same time.

For example, select count (*) into nb_count from t_khz where fzbh = V_fzbh;

Multi-variable value assignment generally adopts the cursor FETCH method:

1. CursorC_rwIs
2. Select*FromT_kh
4. R_rw c_rw % rowtype;
5. OpenC_rw;
6. Loop
7. FetchC_rwIntoR_rw;
8. ExitWhenC_rw % notfound;
9. Dbms_output.put_line (r_r1_khbh |''| R_r1_khxm |''| R_rw.yzbm );
10.  EndLoop;
11. CloseC_rw;

Another way is to use ROWTYPE.

1. -- Local variables here
2. IInteger;
3. V_kh t_kh % rowtype;
4. Gin
5. -- Test statements here
8. Select*IntoV_khFromT_khWhereRownum = 1;
9. Dbms_output.put_line (v_kh.khbh |''| V_kh.khxm |''| V_kh.yzbm );
13. D;

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12