Inserting Data in Oracle

 Inserting Data in Oracle

Once you have created a table, you can insert data into it using the INSERT statement. Here is an example:

INSERT INTO employees (employee_id, first_name, last_name, email, job_id, salary)

VALUES (1001, 'John', 'Doe', 'johndoe@example.com', 'IT_PROG', 5000);

This inserts a single row into the "employees" table with the specified values for the columns. Note that you only need to provide values for the columns that do not have a default value or are not designated as NULL.