Posts

Showing posts from January, 2018

packagesinoracleplsql

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

oracleplsqlintroduction

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