Oracle变量

IF OBJECT_ID('TA') IS NOT NULL DROP TABLE TA
CREATE TABLE TA( HID VARCHAR(5),RID INT)
INSERT INTO TA SELECT 'aaa',1
UNION ALL SELECT 'aaa',2
UNION ALL SELECT 'aaa',3
UNION ALL SELECT 'aaa',4
UNION ALL SELECT 'aaa',5
UNION ALL SELECT 'aaa',6


DECLARE @A INT
DECLARE @I INT
SELECT @A=MAX(RID) FROM TA WHERE HID='aaa'
SET @I=1
WHILE @I<=@A
BEGIN
  INSERT INTO TA SELECT 'bbb',@I
  SET @I=@I+1
END

SELECT * FROM TA

/*
HID   RID        
----- -----------
aaa   1
aaa   2
aaa   3
aaa   4
aaa   5
aaa   6
bbb   1
bbb   2
bbb   3
bbb   4
bbb   5
bbb   6

（所影响的行数为 12 行）

*/