PL/SQL – Packages
In this chapter, we will discuss the Packages in PL/SQL. Packages are schema objects that group logically related PL/SQL types, variables, and subprograms. A package will have two mandatory parts…
In this chapter, we will discuss the Packages in PL/SQL. Packages are schema objects that group logically related PL/SQL types, variables, and subprograms. A package will have two mandatory parts…
In JIRA, workflow is used to track the lifecycle of an Issue. Workflow is a record of statuses and transitions of an issue during its lifecycle. A status represents the stage…
JIRA is a project management tool and uses issues to track all the tasks. An issue helps to track all works that underlie in a project. In real time, every…
In this chapter, we will discuss Triggers in PL/SQL. Triggers are stored programs, which are automatically executed or fired when some events occur. Triggers are, in fact, written to be…
In this chapter, we will discuss Exceptions in PL/SQL. An exception is an error condition during program execution. PL/SQL supports programmers to catch such conditions using the EXCEPTION block in the program…
A Project contains issues; a JIRA project can be called as a collection of issues. A JIRA Project can be of several types. For example − Software Development ProjectMarketing ProjectMigration…
JIRA is a project management tool used for issues and bugs tracking system. It is widely used as an issue-tracking tool for all types of testing. This tutorial introduces the…
In this chapter, we will discuss Records in PL/SQL. A record is a data structure that can hold data items of different kinds. Records consist of different fields, similar to a row…
In this chapter, we will discuss the cursors in PL/SQL. Oracle creates a memory area, known as the context area, for processing an SQL statement, which contains all the information…
Monitoring is one of the key component for managing large clusters. For this, we have a number of tools. Monitoring with Prometheus It is a monitoring and alerting system. It…