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 […]
This is the series for learning Oracle SQL . In this blog we will learn to create stored procedure in SQL . Stored procedure is the stored code in Oracle database which can be reused again & again. If you have some statement which you have to execute again and again then you can write it in stored procedure. Stored […]
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 […]
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 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 […]
Here are the list of most frequently asked ORACLE PL/SQL Interview Questions in technical interviews ORACLE PL/SQL Interview Questions 1.Difference between Varchar and Char ? Varchar doesn’t sets aside memory location during declaration of a variable. It stores the value only after a variable is defined or assigned a value. Its storage capacity is 32767 Bytes. Char however preserves the […]