Question

Write pl/sql block insert a number 1to 5 in a table

Answer 1

Answer:

BEGIN

 INSERT INTO table1(numbers)  VALUES(1);

 INSERT INTO table1(numbers)  VALUES(2);

 INSERT INTO table1(numbers)  VALUES(3);

 INSERT INTO table1(numbers)  VALUES(4);

 INSERT INTO table1(numbers)  VALUES(5);

END;

Explanation:

Expecting table_name as "table1" and the row to be inserted as "numbers"