[vc_row][vc_column][vc_single_image image=”1669″ img_size=”Large”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]PL\/SQL<\/strong><\/p>\n

\n
• Introduction to PL\/SQL<\/li>\n
• Advantages of PL\/SQL<\/li>\n
• The PL\/SQL Block<\/li>\n
• Basic PL\/SQL Block Structure<\/li>\n
• The Declaration Section<\/li>\n
• The Execution Section<\/li>\n
• The Exception Section<\/li>\n
• Generation Output<\/li>\n<\/ul>\n

  Variables And Constants<\/strong><\/p>\n

  \n
  • Data types<\/li>\n
  • Scalar Data types<\/li>\n
  • Composite Data types<\/li>\n
  • Variables (%type, %rowtype)<\/li>\n
  • Variable Assignment<\/li>\n
  • Scope of Variables<\/li>\n
  • Constants<\/li>\n
  • Writing Sample programs demonstrating all above Functionalities<\/li>\n<\/ul>\n

    Conditions and Loops<\/strong><\/p>\n

    \n
    • Conditional Control<\/li>\n
    • Iterative Control<\/li>\n
    • Guidelines<\/li>\n
    • Sample, While, and For Loops<\/li>\n
    • While Loop<\/li>\n
    • For Loop<\/li>\n<\/ul>\n

      Cursors<\/strong><\/p>\n

      \n
      • Implicit and Explicit Cursors<\/li>\n
      • Cursors Actions<\/li>\n
      • Declaring a Cursors<\/li>\n
      • Opening a Cursors<\/li>\n
      • Fetching Data from ad Cursor<\/li>\n
      • Closing a Cursor<\/li>\n
      • Cursor Attributes<\/li>\n
      • Cursors and Loops<\/li>\n
      • Cursors For Loops<\/li>\n<\/ul>\n

        Exception Handling<\/strong><\/p>\n

        \n
        • Guidelines<\/li>\n
        • Types of Exceptions<\/li>\n
        • Named System Exceptions<\/li>\n
        • Named User-Defined Exceptions<\/li>\n
        • Unnamed System Exceptions<\/li>\n
        • Unnamed User-Defined Exceptions<\/li>\n
        • SQL ERRM and SQL Code<\/li>\n<\/ul>\n

          Procedures<\/strong><\/p>\n

          \n
          • Writing Procedures using Oracle SQL,PLSQL<\/li>\n
          • Types of Program Units<\/li>\n
          • Named and Unnamed Block Structures<\/li>\n
          • Diff between Anonymous Blocks and named Blocks<\/li>\n
          • Procedures Parameters<\/li>\n
          • Parameter Modes<\/li>\n
          • IN<\/li>\n
          • Out<\/li>\n
          • IN Out<\/li>\n
          • Testing Procedure from anonymous blocks<\/li>\n
          • Calling procedure from another procedure<\/li>\n<\/ul>\n

            User Defined Functions<\/strong><\/p>\n

            \n
            • Using Functions within Oracle<\/li>\n
            • Difference ways of Callings a function<\/li>\n
            • Named Notation<\/li>\n
            • Functions<\/li>\n
            • Function Parameters<\/li>\n
            • Referencing a Function<\/li>\n<\/ul>\n

              Packages<\/strong><\/p>\n

              \n
              • Defining and Using Packages<\/li>\n
              • Advantages of Using Packages<\/li>\n
              • Overloading<\/li>\n
              • Dependency<\/li>\n
              • Abstraction \u2013 Information Hiding<\/li>\n
              • Inheritance<\/li>\n
              • Defining Global Variables<\/li>\n<\/ul>\n

                Database Triggers<\/strong><\/p>\n

                \n
                • Trigger Types<\/li>\n
                • Trigger Events<\/li>\n
                • Trigger Restrictions<\/li>\n
                • Trigger Body<\/li>\n
                • Complication of Database Triggers<\/li>\n
                • Trigger Syntax<\/li>\n
                • Usage of Instead of Triggers<\/li>\n<\/ul>\n

                  An Overview of Oracle Large Objects<\/strong><\/p>\n

                  \n
                  • BLOB<\/li>\n
                  • CLOB<\/li>\n
                  • PL\/SQL Table<\/li>\n
                  • VARRAY<\/li>\n
                  • BFILE<\/li>\n
                  • Nested Tables<\/li>\n<\/ul>\n

                    <\/h4>\n

                    [\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

                    [vc_row][vc_column][vc_single_image image=”1669″ img_size=”Large”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]PL\/SQL Introduction to PL\/SQL Advantages of PL\/SQL The PL\/SQL Block Basic PL\/SQL Block Structure The Declaration Section The Execution Section The Exception Section Generation Output Variables And Constants Data types Scalar Data types Composite Data types Variables (%type, %rowtype) Variable Assignment Scope of Variables Constants Writing Sample programs demonstrating all above Functionalities Conditions […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1301","page","type-page","status-publish","hentry","no-post-thumbnail"],"_links":{"self":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/comments?post=1301"}],"version-history":[{"count":2,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1301\/revisions"}],"predecessor-version":[{"id":1670,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1301\/revisions\/1670"}],"wp:attachment":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/media?parent=1301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}