[pluralsight.com] Oracle PL_SQL Fundamentals - Part 2

File Name

Size

01. Overview/01_01-Overview.mp4

3.6 MB

01. Overview/01_02-Benefits of Named Program Units.mp4

2.4 MB

01. Overview/01_03-Prerequisites.mp4

1.0 MB

01. Overview/01_04-Audience.mp4

1.2 MB

01. Overview/01_05-Tools.mp4

2.0 MB

02. Procedures/02_01-What is a Procedure.mp4

4.6 MB

02. Procedures/02_02-Defining Procedures.mp4

7.1 MB

02. Procedures/02_03-Compiling Procedures & Native Compilation.mp4

5.2 MB

02. Procedures/02_04-PLSQL_OPTIMIZE_LEVEL & Compile for Debug.mp4

5.3 MB

02. Procedures/02_05-Errors and Warnings.mp4

10 MB

02. Procedures/02_06-Demo Creating & Compiling Procedures, Errors and Warnings.mp4

31 MB

02. Procedures/02_07-Executing Dropping & Terminating Procedures.mp4

3.7 MB

02. Procedures/02_08-Demo Executing Dropping & Terminating Procedures.mp4

12 MB

02. Procedures/02_09-Summary.mp4

1.4 MB

03. Functions/03_01-What is a Function.mp4

2.6 MB

03. Functions/03_02-Oracle Provided Functions.mp4

5.5 MB

03. Functions/03_03-Defining Functions.mp4

9.1 MB

03. Functions/03_04-Compiling & Executing Functions.mp4

12 MB

03. Functions/03_05-Dropping & Terminating Functions.mp4

7.0 MB

03. Functions/03_06-Demo.mp4

28 MB

03. Functions/03_07-Summary.mp4

1011 kB

04. Parameters in Procedures & Functions/04_01-Introduction.mp4

2.3 MB

04. Parameters in Procedures & Functions/04_02-Formal vs. Actual Parameters.mp4

8.6 MB

04. Parameters in Procedures & Functions/04_03-Parameter Modes.mp4

19 MB

04. Parameters in Procedures & Functions/04_04-Passing by Reference & Value.mp4

9.7 MB

04. Parameters in Procedures & Functions/04_05-NOCOPY hint.mp4

6.0 MB

04. Parameters in Procedures & Functions/04_06-DemoParameter Modes & NOCOPY.mp4

22 MB

04. Parameters in Procedures & Functions/04_07-Positional, Named & Mixed Notation.mp4

8.2 MB

04. Parameters in Procedures & Functions/04_08-Default Values & Constraints on Formal Parameters.mp4

2.9 MB

04. Parameters in Procedures & Functions/04_09-Demo Default Values, Positional & Named Notations.mp4

12 MB

04. Parameters in Procedures & Functions/04_10-Summary.mp4

1.7 MB

05. Local Subprograms/05_01-Introduction.mp4

4.7 MB

05. Local Subprograms/05_02-Defining Local Subprograms.mp4

6.6 MB

05. Local Subprograms/05_03-Demo Local Subprograms.mp4

7.2 MB

05. Local Subprograms/05_04-Exceptions, Scope & Visibility of Variables.mp4

11 MB

05. Local Subprograms/05_05-Demo Exceptions, Scope & Visibility of Variables.mp4

14 MB

05. Local Subprograms/05_06-Summary.mp4

838 kB

06. Package Specification/06_01-Introduction.mp4

2.4 MB

06. Package Specification/06_02-Why Use Package Specifications.mp4

5.9 MB

06. Package Specification/06_03-Package Structure & Contents.mp4

3.7 MB

06. Package Specification/06_04-Defining Package Specification.mp4

10 MB

06. Package Specification/06_05-Compiling Package Specification.mp4

4.1 MB

06. Package Specification/06_06-Executing & Dropping Package Specification.mp4

5.2 MB

06. Package Specification/06_07-Global Variables & Session State.mp4

2.1 MB

06. Package Specification/06_08-Demo.mp4

24 MB

06. Package Specification/06_09-Summary.mp4

1.2 MB

07. Package Body/07_01-Introduction.mp4

1.2 MB

07. Package Body/07_02-Defining Package Body.mp4

18 MB

07. Package Body/07_03-Package Initialization.mp4

5.5 MB

07. Package Body/07_04-Compiling & Executing Package Body.mp4

4.4 MB

07. Package Body/07_05-Order of Subprograms & Forward Declaration.mp4

3.2 MB

07. Package Body/07_06-Stateful & Stateless Packages.mp4

6.2 MB

07. Package Body/07_07-Overloading Subprograms.mp4

16 MB

07. Package Body/07_08-Overloading Considerations.mp4

8.0 MB

07. Package Body/07_09-Demo Compiling & Executing Packages.mp4

38 MB

07. Package Body/07_10-Demo Stateful & Stateless Packages.mp4

17 MB

07. Package Body/07_11-Summary.mp4

1.5 MB

08. Calling Functions from SQL/08_01-Where Can They Be Called.mp4

5.8 MB

08. Calling Functions from SQL/08_02-Restrictions.mp4

9.3 MB

08. Calling Functions from SQL/08_03-Demo Functions in SQL Statements.mp4

20 MB

08. Calling Functions from SQL/08_04-Deterministic.mp4

9.3 MB

08. Calling Functions from SQL/08_05-Parallel Enable.mp4

5.5 MB

08. Calling Functions from SQL/08_06-Demo Deterministic Functions.mp4

9.1 MB

08. Calling Functions from SQL/08_07-Pragma Restrict References.mp4

4.8 MB

08. Calling Functions from SQL/08_08-Summary.mp4

1.6 MB

09. Roles & Privileges With Subprograms/09_01-Subprogram Resolution.mp4

8.6 MB

09. Roles & Privileges With Subprograms/09_02-Demo Subprogram Resolution.mp4

11 MB

09. Roles & Privileges With Subprograms/09_03-AUTHID DEFINER.mp4

14 MB

09. Roles & Privileges With Subprograms/09_04-AUTHID CURRENT_USER.mp4

16 MB

09. Roles & Privileges With Subprograms/09_05-Execution Flow Between Invoker & Executor.mp4

12 MB

09. Roles & Privileges With Subprograms/09_06-Demo AUTHID Clause & Execution Flow.mp4

31 MB

09. Roles & Privileges With Subprograms/09_07-Direct Grants vs. Roles.mp4

15 MB

09. Roles & Privileges With Subprograms/09_08-Demo Direct Grants vs. Roles.mp4

323 kB

09. Roles & Privileges With Subprograms/09_09-Summary.mp4

1.2 MB

Exercise files/1-oracle-plsql-part2-m1-slides.pdf

112 kB

Exercise files/2-oracle-plsql-part2-m2-exercise-files/After/oracle-plsql-fundamentals-m5-cursors-drop.txt

47 B

Exercise files/2-oracle-plsql-part2-m2-exercise-files/Before/oracle-plsql-fundamentals-m2-create.txt

1023 B

Exercise files/2-oracle-plsql-part2-m2-exercise-files/oracle-plsql-fundamentals2-module2-procedure-demo1-1.sql

415 B

Exercise files/2-oracle-plsql-part2-m2-exercise-files/oracle-plsql-fundamentals2-module2-procedure-demo1-2.sql

253 B

Exercise files/2-oracle-plsql-part2-m2-exercise-files/oracle-plsql-fundamentals2-module2-procedure-demo1-3.sql

247 B

Exercise files/2-oracle-plsql-part2-m2-exercise-files/oracle-plsql-fundamentals2-module2-procedure-demo2_execute-1.sql

434 B

Exercise files/2-oracle-plsql-part2-m2-exercise-files/oracle-plsql-fundamentals2-module2-procedure-demo2_execute-2.sql

108 B

Exercise files/2-oracle-plsql-part2-m2-exercise-files/Setup.txt

338 B

Exercise files/2-oracle-plsql-part2-m2-slides.pdf

162 kB

Exercise files/3-oracle-plsql-part2-m3-exercise-files/After/oracle-plsql-fundamentals-m5-cursors-drop.txt

47 B

Exercise files/3-oracle-plsql-part2-m3-exercise-files/Before/oracle-plsql-fundamentals-m2-create.txt

1023 B

Exercise files/3-oracle-plsql-part2-m3-exercise-files/oracle-plsql-fundamentals-part2-functiondemo.txt

570 B

Exercise files/3-oracle-plsql-part2-m3-exercise-files/oracle-plsql-fundamentals-part2-functiondemo2.txt

219 B

Exercise files/3-oracle-plsql-part2-m3-exercise-files/Setup.txt

338 B

Exercise files/3-oracle-plsql-part2-m3-slides.pdf

157 kB

Exercise files/4-oracle-plsql-part2-m4-exercise-files/After/drop.txt

104 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/Before/create.txt

1023 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/oracle-plsql-fundamentals-m4-parameters-demo1-1.txt

960 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/oracle-plsql-fundamentals-m4-parameters-demo1-2.txt

655 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/oracle-plsql-fundamentals-m4-parameters-demo2-1.txt

859 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/oracle-plsql-fundamentals-m4-parameters-demo2-2.txt

59 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/oracle-plsql-fundamentals-m4-parameters-demo2-3.txt

230 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/oracle-plsql-fundamentals-m4-parameters-demo2-4.txt

94 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/oracle-plsql-fundamentals-m4-parameters-demo2-5.txt

185 B

Exercise files/4-oracle-plsql-part2-m4-exercise-files/Setup.txt

338 B

Exercise files/4-oracle-plsql-part2-m4-slides.pdf

199 kB

Exercise files/5-oracle-plsql-part2-m5-exercise-files/After/drop.txt

108 B

Exercise files/5-oracle-plsql-part2-m5-exercise-files/Before/create.txt

1023 B

Exercise files/5-oracle-plsql-part2-m5-exercise-files/oracle-plsql-fundamentals-m5-localsubprogram_exception_scope_visibility-demo2-1.txt

944 B

Exercise files/5-oracle-plsql-part2-m5-exercise-files/oracle-plsql-fundamentals-m5-localsubprogram_exception_scope_visibility-demo2-2.txt

24 B

Exercise files/5-oracle-plsql-part2-m5-exercise-files/oracle-plsql-fundamentals-m5-localsubprogrma_demo1-1.txt

756 B

Exercise files/5-oracle-plsql-part2-m5-exercise-files/oracle-plsql-fundamentals-m5-localsubprogrma_demo1-2.txt

24 B

Exercise files/5-oracle-plsql-part2-m5-exercise-files/Setup.txt

338 B

Exercise files/5-oracle-plsql-part2-m5-slides.pdf

174 kB

Exercise files/6-oracle-plsql-part2-m6-exercise-files/After/drop.txt

45 B

Exercise files/6-oracle-plsql-part2-m6-exercise-files/Before/create.txt

1023 B

Exercise files/6-oracle-plsql-part2-m6-exercise-files/oracle-plsql-fundamentals-part2-m6-demo1-1.txt

614 B

Exercise files/6-oracle-plsql-part2-m6-exercise-files/oracle-plsql-fundamentals-part2-m6-demo1-2.txt

295 B

Exercise files/6-oracle-plsql-part2-m6-exercise-files/oracle-plsql-fundamentals-part2-m6-demo1-3.txt

608 B

Exercise files/6-oracle-plsql-part2-m6-exercise-files/oracle-plsql-fundamentals-part2-m6-demo1-4.txt

24 B

Exercise files/6-oracle-plsql-part2-m6-exercise-files/Setup.txt

338 B

Exercise files/6-oracle-plsql-part2-m6-slides.pdf

169 kB

Exercise files/7-oracle-plsql-part2-m7-exercise-files/After/drop.txt

47 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/Before/create.txt

1023 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-1.txt

3.1 kB

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-2.txt

465 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-3.txt

2.5 kB

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-4.txt

172 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-5.txt

442 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-6.txt

526 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-7.txt

460 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-8.txt

2.4 kB

Exercise files/7-oracle-plsql-part2-m7-exercise-files/oracle-plsql-fundamentals-part2-m7-packagesbody-demo1-9.txt

52 B

Exercise files/7-oracle-plsql-part2-m7-exercise-files/Setup.txt

338 B

Exercise files/7-oracle-plsql-part2-m7-slides.pdf

207 kB

Exercise files/8-oracle-plsql-part2-m8-exercise-files/After/.DS_Store

6.0 kB

Exercise files/8-oracle-plsql-part2-m8-exercise-files/After/drop.txt

89 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/Before/create.txt

1023 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo1-1.txt

575 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo1-2.txt

38 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo1-3.txt

72 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo1-4.txt

158 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo1-5.txt

579 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo1-6.txt

857 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo2-1.txt

572 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo2-2.txt

587 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/oracle-plsql-fundamentals-part2-m8-demo2-3.txt

760 B

Exercise files/8-oracle-plsql-part2-m8-exercise-files/Setup.txt

338 B

Exercise files/8-oracle-plsql-part2-m8-slides.pdf

199 kB

Exercise files/9-oracle-plsql-part2-m9-exercise-files/After/.DS_Store

6.0 kB

Exercise files/9-oracle-plsql-part2-m9-exercise-files/After/drop.txt

254 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/Before/create.txt

1023 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo1-1.txt

476 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo1-2.txt

342 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo1-3.txt

110 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo1-4.txt

187 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo1-5.txt

191 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-1.txt

1.0 kB

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-10.txt

1.0 kB

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-11.txt

163 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-2.txt

261 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-3a.txt

1.0 kB

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-3b.txt

365 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-4.txt

228 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-5.txt

370 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-6.txt

162 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-7.txt

163 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-8.txt

696 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo2-9.txt

163 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo3-1.txt

187 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo3-2.txt

695 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo3-3.txt

127 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo3-4.txt

187 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo3-5.txt

96 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/oracle-plsql-fundamentals-part2-m9-demo3-6.txt

98 B

Exercise files/9-oracle-plsql-part2-m9-exercise-files/Setup.txt

338 B

Exercise files/9-oracle-plsql-part2-m9-slides.pdf

184 kB