More

    Data

    Installing and Setting up Oracle Express Edition (database) and SQL Developer (client) on Windows for Development

    Oracle Database Express Edition is the free version of Oracle relational database. We will quickly see how we can download, install and...

    Installing and Setting up MySQL Community Server on Windows for Development

    MySQL is provided in two editions primarily: the commercial MySQL Enterprise Edition and the open MySQL Community Edition. We will try to...

    Oracle Arrays – VARRAYs and Nested Table Arrays (AS TABLE OF)

    Oracle collections are database types that allow you to store sets of elements, similar to arrays and collections in Java. Storing data...

    Examples for using Stored Procedure with Arrays in Oracle DB

    First we will create an array (nested table array or varray), use it in a stored procedure and IN and/or OUT parameters...

    Procedures and Functions in Oracle DB

    Procedures and functions encapsulate a group of SQL and PL/SQL statements. A function is different from stored procedure in...

    Cursors in Oracle PL/SQL

    You can retrieve the rows into the cursor using a query and then fetch the rows one at a time from the...

    Recent Articles

    OAUTH – FREQUENTLY ASKED QUESTIONS FOR INTERVIEWS AND SELF EVALUATION

    Why is refresh token needed when you have access token? Access tokens are usually short-lived and refresh tokens are...

    SUMO LOGIC VIDEOS AND TUTORIALS

    Sumo Logic Basics - Part 1 of 2 (link is external) (Sep 29, 2016)Sumo Logic Basics - Part 2 of 2...

    GIT – USEFUL COMMANDS

    Discard all local changes, but save them for possible re-use later:  git stash Discarding local changes...

    DISTRIBUTED COMPUTING – RECORDED LECTURES (BITS)

    Module 1 - INTRODUCTION Recorded Lecture - 1.1 Introduction Part I – Definition

    BOOK REVIEW GUIDELINES FOR COOKBOOKS

    Whenever you add reviews for the book, please follow below rules. Write issues in an excel.Create an excel...

    Stay on op - Ge the daily news in your inbox