Dears i want to insert 1000 records by only one query. I want to make something like loop we use in language to perform any action in a particular number of times.
insert into ali_bill(cnsg_no,cus_no,cus_nam)
values ('1' to '1000',P0110','ALI')
I want to insert these values for one thousand time but by only one sql statement and in only one action.
Do help me out.