sql program to insert and delete value in table.

OBJECTIVE:-  Program to insert and delete value in table.

SOFTWARE USED:  Oracle SQL

THEORY:-

INSERT:- It is a DDL command .The insert statement uses the set clause, which specifies the values of a column. You can use more than one set clause per insert statement, and each set clause can set the values in more than one column. Multiple set clauses are not separated by commas. If you specify an optional list of columns, then you can set a value only for a column that is specified in the list of columns to be inserted .and when character value insert then apply  (' ') example ('value') otherwise not apply.

SOURCE CODE ( IF INCLUDED )

insert into table_name

values(value<,....,value>);                                    

PROCEDURE

OUTPUT:-

DELETE:- It is a DDL command .the delete statement is used to delete rows in a table.

SOURCE CODE ( IF INCLUDED )

delete from table_name
where (some_column=some_value);                   

PROCEDURE

OUTPUT:-

CONCLUSION:-

We learned about writing the program to insert and delete value in table.