Oracle BULK INSERT with date type data

For example, now there's a table

ID (number)	StartTime (date)	Name (VARCHAR2)
1	2017-08-13	Zhangsan
2	2017-08-14	Zhangsan

Need to BULK Insert name Zhangsan, date incremented in days, one months of data

1 Insert  intoT (id,date,name)2 Select  Level, Trunc (Current_timestamp)+ Level,'Zhangsan'3      fromDual4Connect by  Level<=Add_months (Trunc (Current_timestamp),1)-TruncCurrent_timestamp)

Add_months (time,months)

　　Oracle's own date function to increase or decrease months months at time

Select add_months (current_timestamp,6 from dual--  At current time plus first half select add_months (current_timestamp,-1 from Dual-- minus one months at the current time

Connect by Usage http://blog.csdn.net/wang_yunj/article/details/51040029

Oracle BULK INSERT with date type data