Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

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