Oracle PLSQL Tutorial Insert Update Delete 50 codes

1 Adding Multiple Rows to a Table

2 Adding Rows Using the INSERT Statement

3 Change department name to lower case

4 Change more than one column value in update statement

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

6 Combine three tables with insert into statement

7 Conditional INSERT Statement

8 Copying Rows from One Table to Another (INSERT INTO select )

9 Delete all rows from a table

10 Delete and subquery

11 Delete one row

12 Delete with where clause

13 Deleting Row Data

14 If the WHERE clause were omitted, all the rows would be updated

15 Including Single and Double Quotes in a Column Value

16 Insert bulk by insert into select

17 Insert default value

18 Insert double quote

19 Insert into select

20 Insert into select with where clause

21 Insert value for specific columns

22 Modifying Rows Using the UPDATE Statement

23 Omitting the Column List

24 Removing Rows Using the DELETE Statement

25 Set clause with math expression

26 Set value based on a select statement

27 Specifying a Null Value for a Column

28 Subquery in update statement

29 The DELETE Statements

30 The RETURNING Clause

31 To delete the records of emps whose salary is below the average salary in the department (correlated subquery)

32 To insert records into a table using a subquery

33 To update the salary of all emps to the maximum salary in the corresponding department (correlated subquery)

34 To_date() and insert statement

35 Truncate sysdate in insert statement

36 Two quotes really means one quote

37 Update a subquery

38 Update data from existing column

39 Update four columns

40 Update one row

41 Update salary based on average salary

42 Update the emp table, converting emp names to uppercase

43 Update with subquery

44 Use a q as the leading character after the parentheses

45 Use function in set clause

46 Use quote in insert statement

47 Use TO_DATE(December 31, 2005, 11

48 Use trunc in insert statement

49 Writing a DELETE Statement Containing a Subquery

50 Writing an UPDATE Statement Containing a Subquery