Inserting data records into the table using multiple insert statements. Putting a semi colon in front of the key word INSERT in the next statement rather than terminating the first statement with a semi colon achieves it.
Insert into Sales “select * from customer”;
Insert into Loan “select * from customer”;
Insert into Sales “select * from customer”;
Insert into Loan “select * from customer”;
No comments:
Post a Comment