Oracle plsql

SUBSTR function in Oracle Pl Sql In real time projects the requirement might come like to extract the length of data from the particular data. In this blog, we will see how we can execute this requirement through Oracle pl sql by using Oracle/PLSQL SUBSTR function.   Syntax of SUBSTR function in Oracle PL SQL is: SUBSTR( string, starting_position [, Total length of the data ] ) Parameters of SUBSTR string Input data which we are going to use for extraction process. starting position It denotes the starting position of length of the data. The position of the string will always start from 1. length Optional. It denotes the length of the character to extract. If this parameter is not given, then the SUBSTR function will return the entire string from the starting position which we given in syntax. The SUBSTR function is used to returns a string value. If length of the data is a negative number, then the SUBSTR function will return a NULL value. Rule of...

Implicit Cursor Implicit Cursor Oracle plsql: Types of Cursor? a. Explicit - If user is declared Cursor, then it is explicit cursor. b. Implicit - If Oracle is declared Cursor, then it is implicit cursor. We will have look about Implicit cursor. When Oracle declare this cursor? After execution of DML(Select, Insert, Update, Delete) command, Oracle will declare this implicit cursor. It can be also called as SQL. Importance of Implicit cursor is to provide the status of last execution of DML command whether the last statement is successful or not. Below 3 attributes are being used for Implicit cursor: %found      - - > TRUE/FALSE                        < If DML is successful, returns TRUE, If not then returns FALSE> %notfound - - > TRUE/FALSE            ...