Oracle PLSQL Insert Delete Update 46 codes

1 Adding Multiple Rows to a Table

2 An example of using a function in the SET clause

3 Change department name to lower case

4 Change multiple rows and multiple columns in the same UPDATE statement

5 Change value case with update statement

6 Changing column order

7 Conditional INSERT Statement

8 Date calculation in insert statement

9 Delete all records in TableA whose data in field1 and field2 DO NOT match the data in fieldx and fieldz of TableB

10 Delete clause with sub query

11 Delete command with conditions

12 Delete one row

13 Delete statement with where clause and varchar2 type column

14 Including Double Quotes in a Column Value

15 Insert bulk by insert into select

16 Insert into select

17 INSERTING DATA CONTAINING APOSTROPHES

18 Inserting values using System function

19 Merge into a table

20 Modify multiple rows with a single UPDATE statement

21 Perform more complicated inserts using sub-selects

22 SELECT SPECIFIC COLUMNS

23 Specifying a Null Value for a Column

24 The order of values in the VALUES clause matches the order in which the columns are specified in the column list

25 To insert records into a table using a subquery

26 Update command without condition

27 Update data from existing column

28 Update four columns

29 Update number type column

30 Update one row

31 Update records in one table based on values in another table

32 Update salary based on average salary

33 Update the emp table, converting emp names to uppercase

34 Update with where condition

35 Use arithmetic operators and functions in the SET clause to modify data

36 Use bulk collect and rownum to insert first 10 records

37 Use quotation in insert statement in PLSQL

38 Use TO_DATE(December 31, 2002, 11

39 Use Trunc in insert statement

40 Using the column list in INSERT command, include a column list after the table name

41 WHERE clause is used to control which rows are affected by the DELETE statement

42 Without the WHERE clause, this UPDATE affects all rows in the table

43 Writing a DELETE Statement Containing a Subquery

44 Writing an UPDATE Statement Containing a Subquery

45 You can update a column and set it back to the default using the DEFAULT keyword in an UPDATE statement

46 You can use variables such as SYSDATE and USER in your INSERT statements