21 – HOW TO MANIPULATE DATA INSERT / UPDATE / DELETE
Having created Ledger-Master, we shall try to create 1 insert records 1 rows into this table'
Let us understand the SQL script
INSERT INTO << Table Name >> ( <<column Names >> ) values ( <<
datas>> );
→ column names may be given in multiple but should be separated with comma
→ values need to be given in the same order separated by comma'
→ character data type ( Char, Varchar2 ) the values should be embedded by single quotes'
→ In data's portion Function commands can be used like upper( ) etc'
→ where condition can be given for restricting the insertion'
→ the insertion can be made from another table
→ the insertion can be from another table leaving the existing data's in the present table
→ user can append records from another table'
→ Column Name order need not be in the same order of creation UPDATE <<TABLE NAME >> SET COLUMN NAME = <<VALUE >> WHERE <<CONDITION>>
→ column_name and values can be separated by commas for
multiple column update'
DELETE FROM <<TABLE NAME>> WHERE <<CONDITIONS>> We shall see some of the examples for data manipulation