insert pl sql code example

Example 1: pl sql insert into table

INSERT INTO categories
(category_id, category_name)
VALUES
(150, 'Miscellaneous');

Example 2: sql insert query

--sql insert quest example
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Example 3: oracle insert into

INSERT INTO table
(column1, column2, ... column_n )
VALUES
(expression1, expression2, ... expression_n );

Example 4: oracle insert into

INSERT INTO table
(column1, column2, ... column_n )
SELECT expression1, expression2, ... expression_n
FROM source_table
[WHERE conditions];