Learn PL/SQL : Create Oracle SQL Functions

Learn PL/SQL : Create Oracle SQL Functions

Do you know in Oracle PL/SQL How to Create Oracle SQL Functions and where you can use them. In this article of Oracle PL/SQL  , I  will tell you how to create function & uses . How to Create Oracle SQL Functions Lets first understand Oracle SQL function. What is a function ? Functions are built into Oracle Database and functions […]

Learn Oracle PL/SQL : Create & Use View

Learn Oracle PL/SQL : Create & Use View

Do you know the type of views ,how to create them and their uses.  In this blog I will tell you about views , how you can use them practically. Before that I want to tell you that this is my third blog on Learn Oracle pl/sql if you have not read earlier blog on Variables & Tables kindly read […]

Learn Oracle PL/SQL : Create & Use Tables

Learn Oracle PL/SQL : Create & Use Tables

Hello  friends , I hope you understood my last blog Learn Oracle PL/SQL with Live Project Part-1  In that blog I teach you that variable type which we usually use in Oracle pl/sql. Now in this blog i will tell you about tables , where and how to use them. Learn Oracle PL/SQL :Create & Use Tables   First lets […]

Learn Oracle PL/SQL : Variables

Learn Oracle PL/SQL : Variables

Learn Oracle PL/SQL Here i will make you learn Oracle PL/SQL in very simplified way . I will teach you in my way like I  learned.  I hope you know what is PL/SQL & what is database, because i am not here to teach you theory if you need definitions you can go to other websites. What you will learn […]

How to login with Putty & Execute Stored Procedure

How to login with Putty & Execute Stored Procedure

Have you ever execute stored procedure other than Toad or SQL Developer Software . If not then i will tell you how to execute stored procedure using Putty Software. If you don’t know  about Toad& SQL Developer . They are database management tool set that database developers, database administrators, and data analysts use to manage both relational and non-relational databases using SQL. How to […]