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            ...

                              Understand the concept of Software Testing for fresher Software testing is used to evaluate whether the newly or enhanced application or product is working as expected or not. It can be do via various process like by passing input to the application and get the expected output from application. Before delivering every applications to the client which we need to evaluate the quality of the output whether the requirement is fulfilled or not. It can be done after software development is completed. SDLC of Testing: 1. Developer/Test Lead or Test Manager  will do the Verification and validation from their end before hand over to Quality team. 2. Quality team will do the Verification and validation from their end before hand over to Client or 3rd party testing company. 3. During their Verification ...

                             Concept of explicit cursor in oracle pl/sql What is Cursor?      If we want to retrieve multiple rows from the table then we will go for Cursor.           Cursor will works like line by line execution.           i.e. After successful processing of first record then cursor will retrieve and process the following            records one by one. How to use Cursor? Follow the below steps to use Cursor: Declare cursor - - - > It is used to define a cursor that will be subsequently used to open and fetch                           ...

                                                 Packages in Oracle Pl/Sql What is Packages?       The collection of Procedures, variables, functions, cursors and types etc. is called packages.       The related Procedures and functions are grouped in to single unit is called package.       Ex of package : The banking sector has multiple divisions such as Credit card, Personal loan,                                   Home loan, Car loan, Insurance etc... Benefits of creating packages?   ...

                                                             Basics about Oracle pl/sql tutorial - Day 1 Oracle Sql basic Plsql basic Sql advanced Plsql advanced Performace tuning basic Performance tuning advanced Introduction of SQL 1. Introduction 2. Commands 3. Data types 4. Clauses 5. Constraints 6. Operators 7. Functions 8. Joins 9. Subqueries 10. Other DB objects Oracle history Below version are DBMS based: Version       Date 2    June       1979 3    Mar        1983 4    Oct       ...