Oracle plsql

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

​                                                 Learn Stored procedure concept in Oracle plsql Here in this blog just we are going to see stored procedure concept in Oracle plsql. We will include further topics in Oracle plsql training in separate blogs. 1. Stored procedure is also called as PL/SQL block 2.   Stored procedure receive input in the form of parameters and performs some task and it may or may not returns a value. 3.   Procedures are created to perform one or more DML operations over database.     (Ex: To create one or more DML operation (Insert or Delete or update) over database, we are creating        Stored procedure) SYNTAX for Stored procedure: CR...