1

001 125 Oracle PLSQL- Before You Start

1:42

2

002 125 Oracle PLSQL- Course Agenda

8:01

3

003 125 Oracle PLSQL- Overview of PLSQL 1

11:25

4

004 125 Oracle PLSQL- Overview of PLSQL 2

9:56

5

005 125 Oracle PLSQL- Overview of PLSQL 3

6:19

6

006 125 Oracle PLSQL- Declaring PLSQL Variables 1

9:37

7

007 125 Oracle PLSQL- Declaring PLSQL Variables 2

10:27

8

008 125 Oracle PLSQL- Declaring PLSQL Variables 3

7:18

9

009 125 Oracle PLSQL- Declaring PLSQL Variables 4

21:46

10

010 125 Oracle PLSQL- Declaring PLSQL Variables 5

14:35

11

011 125 Oracle PLSQL- Writing executable statements 1

15:48

12

012 125 Oracle PLSQL- Writing executable statements 2

20:22

13

013 125 Oracle PLSQL-Interacting with Oracle DB Server 1

12:09

14

014 125 Oracle PLSQL-Interacting with Oracle DB Server 2

14:48

15

015 125 Oracle PLSQL- IF Statement- ركز هنا

14:46

16

016 125 Oracle PLSQL- Case Statement VS Case Expression

13:05

17

017 125 Oracle PLSQL- Handling Nulls in IF Statement

9:22

18

018 125 Oracle PLSQL- Basic Loop

11:41

19

019 125 Oracle PLSQL- While Loop

4:48

20

020 125 Oracle PLSQL- FOR Loop

13:33

21

021 125 Oracle PLSQL- Nested Loops & Labels

9:00

22

022 125 Oracle PLSQL- Continue Statement

6:19

23

023 125 Oracle PLSQL- PLSQL Records Part 1

17:11

24

024 125 Oracle PLSQL- PLSQL Records Part 2

17:59

25

025 125 Oracle PLSQL- Index by Tables-Associative Arrays 1

15:22

26

026 125 Oracle PLSQL- Index by Tables-Associative Arrays 2

13:34

27

027 125 Oracle PLSQL- Index by Tables-Assosiative Arrays 3

13:13

28

028 125 Oracle PLSQL- Nested tables

19:06

29

029 125 Oracle PLSQL- Varray

8:59

30

030 125 Oracle PLSQL- Using explicit cursors 1

23:07

31

031 125 Oracle PLSQL- Using explicit cursors 2

14:43

32

032 125 Oracle PLSQL- Using explicit cursors 3 ( FOR)

12:03

33

033 125 Oracle PLSQL- Using explicit cursors 4

11:38

34

034 125 Oracle PLSQL- Using explicit cursors 5

16:38

35

035 125 Oracle PLSQL- Handling Exceptions Introduction

13:27

36

036 125 Oracle PLSQL- Handling Exceptions Real Examples

17:12

37

037 125 Oracle PLSQL- Handling Exceptions Non- Predefined

10:36

38

038 125 Oracle PLSQL- Handling Exceptions Non- Predefined Practice

9:26

39

039 125 Oracle PLSQL- Handling Exceptions Programmer Exceptions

21:23

40

040 125 Oracle PLSQL-Creating Procedure Introduction

26:40

41

041 125 Oracle PLSQL-Creating Procedure Practice

16:51

42

042 125 Oracle PLSQL-Creating Procedure OUT Parameters

12:59

43

043 125 Oracle PLSQL-Creating Procedure IN OUT Parameters

11:36

44

044 125 Oracle PLSQL-Creating Procedure Passing Parameters

13:39

45

045 125 Oracle PLSQL-Creating Procedure Handling Exceptions

13:38

46

046 125 Oracle PLSQL- Creating Functions 1

13:40

47

047 125 Oracle PLSQL- Creating Functions 2

14:02

48

048 125 Oracle PLSQL- Creating Functions 3

11:57

49

049 125 Oracle PLSQL- Creating Functions 4

9:17

50

050 125 Oracle PLSQL- Creating Packages 1

8:35

51

051 125 Oracle PLSQL- Creating Packages 2

11:30

52

052 125 Oracle PLSQL- Creating Packages 3

9:10

53

053 125 Oracle PLSQL- Creating Packages 4

24:44

54

054 125 Oracle PLSQL- Working with Packages Overloading

22:43

55

055 125 Oracle PLSQL- Working with Packages Overloading Standard Program

7:16

56

056 125 Oracle PLSQL- Working with Packages Forward Declaration

11:59

57

057 125 Oracle PLSQL- Working with Packages Persistent State

16:40

58

058 125 Oracle PLSQL- Working with Packages Persistent Cursor

10:44

59

059 125 Oracle PLSQL- Working with Packages Array Example

2:32

60

060 125 Oracle PLSQL- Supplied Packages Introduction

7:17

61

061 125 Oracle PLSQL- Supplied Packages DBMS OUTPUT

15:59

62

062 125 Oracle PLSQL- Supplied Packages UTL FILE 1

7:19

63

063 125 Oracle PLSQL- Supplied Packages UTL FILE 2

11:57

64

064 125 Oracle PLSQL- Supplied Packages UTL FILE 3

7:22

65

065 125 Oracle PLSQL- Supplied Packages UTL MAIL 1

13:49

66

066 125 Oracle PLSQL- Supplied Packages UTL MAIL 2

24:54

67

067 125 Oracle PLSQL- Dynamic SQL Introduction

14:23

68

068 125 Oracle PLSQL- Dynamic SQL Execute Immediate 1

16:09

69

069 125 Oracle PLSQL- Dynamic SQL Execute Immediate 2

7:25

70

070 125 Oracle PLSQL- Dynamic SQL Execute Immediate 3

8:13

71

071 125 Oracle PLSQL- Dynamic SQL REF Cursor

9:22

72

072 125 Oracle PLSQL- Dynamic SQL More Examples

7:20

73

073 125 Oracle PLSQL- Dynamic SQL DBMS SQL

15:41

74

074 125 Oracle PLSQL- Design consideration Standardizing

13:41

75

075 125 Oracle PLSQL- Design consideration Definer’s & Invoker’s Rights

12:24

76

076 125 Oracle PLSQL- Design consideration AUTONOMOUS TRANSACTION

12:40

77

077 125 Oracle PLSQL- Design consideration NOCOPY Hint 1

13:26

78

078 125 Oracle PLSQL- Design consideration NOCOPY Hint 2

15:39

79

079 125 Oracle PLSQL- Design consideration parallel enable result cache

13:48

80

080 125 Oracle PLSQL- Design consideration Bulk Binding 1

23:29

81

081 125 Oracle PLSQL- Design consideration Bulk Binding 2

14:02

82

082 125 Oracle PLSQL- Design consideration Bulk Binding 3

5:19

83

083 125 Oracle PLSQL- Design consideration Bulk Binding 4

6:11

84

084 125 Oracle PLSQL- Design consideration Bulk Binding 5

9:35

85

085 125 Oracle PLSQL- Design consideration Bulk Binding 6

5:53

86

086 125 Oracle PLSQL- Creating Triggers Introduction

20:53

87

087 125 Oracle PLSQL- Creating Triggers Statement Level

17:50

88

088 125 Oracle PLSQL- Creating Triggers Row Level (1)

12:43

89

089 125 Oracle PLSQL- Creating Triggers Row Level (2)

12:28

90

090 125 Oracle PLSQL- Creating Triggers Trigger Firing Sequence

15:01

91

091 125 Oracle PLSQL- Creating Triggers Default Value

5:23

92

092 125 Oracle PLSQL- Creating Triggers Instead of Triggers

19:27

93

093 125 Oracle PLSQL- Creating Triggers follows Statement

7:40

94

094 125 Oracle PLSQL- Creating Triggers Compound triggers 1

13:35

95

095 125 Oracle PLSQL- Creating Triggers Compound triggers 2

5:56

96

096 125 Oracle PLSQL- Creating Triggers Compound triggers 3

23:55

97

097 125 Oracle PLSQL- Creating Triggers Compound triggers 4

13:24

98

098 125 Oracle PLSQL- Creating Triggers Compound triggers 5

9:06

99

099 125 Oracle PLSQL- Creating Triggers DDL Triggers

13:27

100

100 125 Oracle PLSQL- Creating Triggers Database Events

9:00

101

101 125 Oracle PLSQL- Creating Triggers Call Statement

8:54

102

102 125 Oracle PLSQL- PLSQL Compiler plsql code type

17:10

103

103 125 Oracle PLSQL- PLSQL Compiler plsql optimize level

11:40

104

104 125 Oracle PLSQL- PLSQL Compiler plsql warnings 1

15:59

105

105 125 Oracle PLSQL- PLSQL Compiler plsql warnings 2

13:08

106

106 125 Oracle PLSQL- PLSQL Compiler dbms warning

11:06

107

107 125 Oracle PLSQL- Managing PLSQL Conditional Complication 1

14:39

108

108 125 Oracle PLSQL- Managing PLSQL Conditional Complication 2

12:00

109

109 125 Oracle PLSQL- Managing PLSQL plsql ccflags 1

17:44

110

110 125 Oracle PLSQL- Managing PLSQL plsql ccflags 2

7:55

111

111 125 Oracle PLSQL- Managing PLSQL plsql ccflags 3

10:22

112

112 125 Oracle PLSQL- Managing PLSQL dbms ddl.create wrapped

11:58

113

113 125 Oracle PLSQL- Managing PLSQL Wrapper Utility 1

8:25

114

114 125 Oracle PLSQL- Managing PLSQL Wrapper Utility 2

8:50

115

115 125 Oracle PLSQL- Managing Dependencies Introduction

13:59

116

116 125 Oracle PLSQL- Managing Dependencies Direct and Indirect

17:18

117

117 125 Oracle PLSQL- Managing Dependencies Nice Practice

10:37

118

118 125 Oracle PLSQL- Managing Dependencies 3 cases

16:11

119

119 125 Oracle PLSQL- Managing Dependencies package case

7:20

120

120 125 Oracle PLSQL- Managing Dependencies Synonym 1

7:00

121

121 125 Oracle PLSQL- Managing Dependencies Synonym 2

9:52

122

122 125 Oracle PLSQL- Managing Dependencies Reduce invalidation

3:36

123

123 125 Oracle PLSQL- Managing Dependencies Remote part 1

16:53

124

124 125 Oracle PLSQL- Managing Dependencies Remote part 2

13:24

125

125 125 Oracle PLSQL- Thank You

0:10