Learn Oracle PL/SQL with Live Project Part-1

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

  • Variable – Mainly Used Variables.
  • Table – Create, Alter, Select, Delete, Drop.
  • Views – Create & Use.
  • Functions – Create & Use.
  • Procedure -Create & Use.
  • Packages – Create & Use.
  • Trigger – Create & Use.
  • Simple to Complex SQL Query.

 

After learning all these topics you will become  Oracle PL/SQL developer. The main topics written above will include small topics also, that we will discuss later in this course. All the topics will go from simple to complex so that you will become familiar to each topic.

So now let’s start learning Oracle PL/SQL

Variable

First Basic thing in oracle database is variable. Variable is that entity which is used in the way the data will be saved in the database. Here I will not discuss all of them but some of them which we mainly use in PL/SQL .

  1. Char
  2. Varchar2
  3. Number
  4. Date
  5. BLOB

These are the 5 variable which we mainly use in Oracle Database. I will tell you importance of each variable one by one. They are very simple & easy to understand.

You might be thinking that why I am telling you the theory, because without this you cannot understand the oracle database. Let’s not waste time and start with our first variable.

Char

This variable is used to store character in Database.

For Example: If you want to store ABCD1 in char variable it will not store it but if you will store ABCD then it will store.

Varchar2

This variable is used to store variable length character string in Database.

For Example: If you want to store ABCD1 in Varchar2 variable it will store it & if you will store ABCD then it will also store as well.

Number

This variable will store fixed and floating point numbers.

For Example:

if you will store 1234 then it will also store.

if you will store 1234.50 then it will also store.

Date

This variable will store date & time .

For Example: if you will store 08-May-2018 then it will also store.

if you will store 08-May-2018 11:22:56 then it will also store.

BLOB

This variable will store unstructured binary data in Database. It can store up to 128 terabytes of binary data.

For Example:  If you want to store any files, images & the file with large amount of data so you can store that in this variable.

So these are the my favorite variable which I use generally for my project and in next blog we will discuss  Tables How to create & use them .  And if you have the problem with these mentioned or any other variable write to me I will wait for your comments.

  •  
    9
    Shares
  • 9
  •  
  •  
  •  
  •  
  •  

About the Author

Prashant Goswami

I am the blog writer who will teach how to love programming. My experience in programming is about 6 years. And i am the lover of programming , so i will make you people.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: