• Lesson.No : 16
  • 00:13:06

  • 16/125 Oracle PLSQL: Case Statement VS Case Expression

  • Play

Course Lessons

  1. 1- 1/125 Oracle PLSQL: Before You Start
  2. 2- 2/125 Oracle PLSQL: Course Agenda
  3. 3- 3/125 Oracle PLSQL: Overview of PLSQL 1
  4. 4- 4/125 Oracle PLSQL: Overview of PLSQL 2
  5. 5- 5/125 Oracle PLSQL: Overview of PLSQL 3
  6. 6- 6/125 Oracle PLSQL: Declaring PLSQL Variables 1
  7. 7- 7/125 Oracle PLSQL: Declaring PLSQL Variables 2
  8. 8- 8/125 Oracle PLSQL: Declaring PLSQL Variables 3
  9. 9- 9/125 Oracle PLSQL: Declaring PLSQL Variables 4
  10. 10- 10/125 Oracle PLSQL: Declaring PLSQL Variables 5
  11. 11- 11/125 Oracle PLSQL: Writing executable statements 1
  12. 12- 12/125 Oracle PLSQL: Writing executable statements 2
  13. 13- 13/125 Oracle PLSQL:Interacting with Oracle DB Server 1
  14. 14- 14/125 Oracle PLSQL:Interacting with Oracle DB Server 2
  15. 15- 15/125 Oracle PLSQL: IF Statement- ركز هنا
  16. 16- 16/125 Oracle PLSQL: Case Statement VS Case Expression
  17. 17- 17/125 Oracle PLSQL: Handling Nulls in IF Statement
  18. 18- 18/125 Oracle PLSQL: Basic Loop
  19. 19- 19/125 Oracle PLSQL: While Loop
  20. 20- 20/125 Oracle PLSQL: FOR Loop
  21. 21- 21/125 Oracle PLSQL: Nested Loops & Labels
  22. 22- 22/125 Oracle PLSQL: Continue Statement
  23. 23- 23/125 Oracle PLSQL: PLSQL Records Part 1
  24. 24- 24/125 Oracle PLSQL: PLSQL Records Part 2
  25. 25- 25/125 Oracle PLSQL: Index by Tables-Associative Arrays 1
  26. 26- 26/125 Oracle PLSQL: Index by Tables-Associative Arrays 2
  27. 27- 27/125 Oracle PLSQL: Index by Tables-Assosiative Arrays 3
  28. 28- 28/125 Oracle PLSQL: Nested tables
  29. 29- 29/125 Oracle PLSQL: Varray
  30. 30- 30/125 Oracle PLSQL: Using explicit cursors 1
  31. 31- 31/125 Oracle PLSQL: Using explicit cursors 2
  32. 32- 32/125 Oracle PLSQL: Using explicit cursors 3 ( FOR)
  33. 33- 33/125 Oracle PLSQL: Using explicit cursors 4
  34. 34- 34/125 Oracle PLSQL: Using explicit cursors 5
  35. 35- 35/125 Oracle PLSQL: Handling Exceptions/Introduction
  36. 36- 36/125 Oracle PLSQL: Handling Exceptions/Real Examples
  37. 37- 37/125 Oracle PLSQL: Handling Exceptions/Non- Predefined
  38. 38- 38/125 Oracle PLSQL: Handling Exceptions/Non- Predefined Practice
  39. 39- 39/125 Oracle PLSQL: Handling Exceptions/Programmer Exceptions
  40. 40- 40/125 Oracle PLSQL:Creating Procedure/Introduction
  41. 41- 41/125 Oracle PLSQL:Creating Procedure/Practice
  42. 42- 42/125 Oracle PLSQL:Creating Procedure/ OUT Parameters
  43. 43- 43/125 Oracle PLSQL:Creating Procedure/ IN OUT Parameters
  44. 44- 44/125 Oracle PLSQL:Creating Procedure/ Passing Parameters
  45. 45- 45/125 Oracle PLSQL:Creating Procedure/ Handling Exceptions
  46. 46- 46/125 Oracle PLSQL: Creating Functions 1
  47. 47- 47/125 Oracle PLSQL: Creating Functions 2
  48. 48- 48/125 Oracle PLSQL: Creating Functions 3
  49. 49- 49/125 Oracle PLSQL: Creating Functions 4
  50. 50- 50/125 Oracle PLSQL: Creating Packages 1
  51. 51- 51/125 Oracle PLSQL: Creating Packages 2
  52. 52- 52/125 Oracle PLSQL: Creating Packages 3
  53. 53- 53/125 Oracle PLSQL: Creating Packages 4
  54. 54- 54/125 Oracle PLSQL: Working with Packages / Overloading
  55. 55- 55/125 Oracle PLSQL: Working with Packages / Overloading Standard Program
  56. 56- 56/125 Oracle PLSQL: Working with Packages / Forward Declaration
  57. 57- 57/125 Oracle PLSQL: Working with Packages / Persistent State
  58. 58- 58/125 Oracle PLSQL: Working with Packages / Persistent Cursor
  59. 59- 59/125 Oracle PLSQL: Working with Packages / Array Example
  60. 60- 60/125 Oracle PLSQL: Supplied Packages / Introduction
  61. 61- 61/125 Oracle PLSQL: Supplied Packages / DBMS_OUTPUT
  62. 62- 62/125 Oracle PLSQL: Supplied Packages / UTL_FILE 1
  63. 63- 63/125 Oracle PLSQL: Supplied Packages / UTL_FILE 2
  64. 64- 64/125 Oracle PLSQL: Supplied Packages /UTL_FILE 3
  65. 65- 65/125 Oracle PLSQL: Supplied Packages / UTL_MAIL 1
  66. 66- 66/125 Oracle PLSQL: Supplied Packages / UTL_MAIL 2
  67. 67- 67/125 Oracle PLSQL: Dynamic SQL / Introduction
  68. 68- 68/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 1
  69. 69- 69/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 2
  70. 70- 70/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 3
  71. 71- 71/125 Oracle PLSQL: Dynamic SQL / REF Cursor
  72. 72- 72/125 Oracle PLSQL: Dynamic SQL / More Examples
  73. 73- 73/125 Oracle PLSQL: Dynamic SQL / DBMS_SQL
  74. 74- 74/125 Oracle PLSQL: Design consideration / Standardizing
  75. 75- 75/125 Oracle PLSQL: Design consideration / Definer’s & Invoker’s Rights
  76. 76- 76/125 Oracle PLSQL: Design consideration / AUTONOMOUS_TRANSACTION
  77. 77- 77/125 Oracle PLSQL: Design consideration / NOCOPY Hint 1
  78. 78- 78/125 Oracle PLSQL: Design consideration / NOCOPY Hint 2
  79. 79- 79/125 Oracle PLSQL: Design consideration / parallel_enable/ result_cache
  80. 80- 80/125 Oracle PLSQL: Design consideration / Bulk Binding 1
  81. 81- 81/125 Oracle PLSQL: Design consideration / Bulk Binding 2
  82. 82- 82/125 Oracle PLSQL: Design consideration / Bulk Binding 3
  83. 83- 83/125 Oracle PLSQL: Design consideration / Bulk Binding 4
  84. 84- 84/125 Oracle PLSQL: Design consideration / Bulk Binding 5
  85. 85- 85/125 Oracle PLSQL: Design consideration / Bulk Binding 6
  86. 86- 86/125 Oracle PLSQL: Creating Triggers / Introduction
  87. 87- 87/125 Oracle PLSQL: Creating Triggers / Statement Level
  88. 88- 88/125 Oracle PLSQL: Creating Triggers / Row Level (1)
  89. 89- 89/125 Oracle PLSQL: Creating Triggers / Row Level (2)
  90. 90- 90/125 Oracle PLSQL: Creating Triggers / Trigger Firing Sequence
  91. 91- 91/125 Oracle PLSQL: Creating Triggers / Default Value
  92. 92- 92/125 Oracle PLSQL: Creating Triggers / Instead of Triggers
  93. 93- 93/125 Oracle PLSQL: Creating Triggers / follows Statement
  94. 94- 94/125 Oracle PLSQL: Creating Triggers / Compound triggers 1
  95. 95- 95/125 Oracle PLSQL: Creating Triggers / Compound triggers 2
  96. 96- 96/125 Oracle PLSQL: Creating Triggers / Compound triggers 3
  97. 97- 97/125 Oracle PLSQL: Creating Triggers / Compound triggers 4
  98. 98- 98/125 Oracle PLSQL: Creating Triggers / Compound triggers 5
  99. 99- 99/125 Oracle PLSQL: Creating Triggers / DDL Triggers
  100. 100- 100/125 Oracle PLSQL: Creating Triggers / Database Events
  101. 101- 101/125 Oracle PLSQL: Creating Triggers /Call Statement
  102. 102- 102/125 Oracle PLSQL: PLSQL Compiler / plsql_code_type
  103. 103- 103/125 Oracle PLSQL: PLSQL Compiler / plsql_optimize_level
  104. 104- 104/125 Oracle PLSQL: PLSQL Compiler / plsql_warnings 1
  105. 105- 105/125 Oracle PLSQL: PLSQL Compiler / plsql_warnings 2
  106. 106- 106/125 Oracle PLSQL: PLSQL Compiler / dbms_warning
  107. 107- 107/125 Oracle PLSQL: Managing PLSQL / Conditional Complication 1
  108. 108- 108/125 Oracle PLSQL: Managing PLSQL / Conditional Complication 2
  109. 109- 109/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 1
  110. 110- 110/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 2
  111. 111- 111/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 3
  112. 112- 112/125 Oracle PLSQL: Managing PLSQL / dbms_ddl.create_wrapped
  113. 113- 113/125 Oracle PLSQL: Managing PLSQL / Wrapper Utility 1
  114. 114- 114/125 Oracle PLSQL: Managing PLSQL / Wrapper Utility 2
  115. 115- 115/125 Oracle PLSQL: Managing Dependencies / Introduction
  116. 116- 116/125 Oracle PLSQL: Managing Dependencies / Direct and Indirect
  117. 117- 117/125 Oracle PLSQL: Managing Dependencies / Nice Practice
  118. 118- 118/125 Oracle PLSQL: Managing Dependencies / 3 cases
  119. 119- 119/125 Oracle PLSQL: Managing Dependencies / package case
  120. 120- 120/125 Oracle PLSQL: Managing Dependencies / Synonym 1
  121. 121- 121/125 Oracle PLSQL: Managing Dependencies / Synonym 2
  122. 122- 122/125 Oracle PLSQL: Managing Dependencies / Reduce invalidation
  123. 123- 123/125 Oracle PLSQL: Managing Dependencies / Remote part 1
  124. 124- 124/125 Oracle PLSQL: Managing Dependencies / Remote part 2
  125. 125- 125/125 Oracle PLSQL: Thank You