ASKYEDU

Hello, In this tutorial you are going to learn about PL / SQL advance topics. Procedures, Functions, Cursors, Triggers and packages are the topics you will learn here. The following topics demonstrated for you here. How to define procedures functions and using or calling them? What is cursor and how to work with cursors? What is trigger and How they act while working with DML commands? What is package? Note: Plase give your views and suggestions in the COMMENTS section. It will help me to improve the content.

Hello, In this tutorial you are going to learn about PL / SQL programing. What is PL/ SQL? PL/ SQL architecture. How anonymous blocks of code can be written? You can also learn about  data types, declaration of variables, processing them in Begin - End section of code.  You can write decision making statements, loops, output function, doing calculations by arithmetic operators.  Learn about user defined types, Exception handling and 'Varray' array types. You can find detailed information of these topics in the following presentation. Note: After reading it please comment your views and suggestions in the comment section. It will help  to improve the content.

 Hello, Welcome to SQL tutorial. In this session you will learn SQL Functions, Joins & Subqueries. Following is the presentation for the same. 

Learn RDBMS Concepts easily   Learn SQL Statements Easily and in Simple Way.

 Hello, Welcome to C# Tutorial. My name is Abdul Yesdani. Today we are going to learn about methods in C# programing language. Method is a bunch of code or statements which perform a single task. Here you can see the method example.     static void Hello(string name)         {             Console.WriteLine("Hello!" + name +"  Welcome to C#");             Console.WriteLine("Methods can have n number of statements");             Console.WriteLine("method will perform a single task");         } Methods can have parameters as shown in the above example, 'string name' is a parameter must be passed its value at the calling method in side the Main() method. Press Ctrl+ F5 to run the application. You will get the following output. In the above example you can see 'void'  keyword before method name. Means method return type is void , i.e., met...

Hi, Welcome to all. My name is Abdul Yesdani. Today we are going to learn about arrays in C#. In our previous postings we have worked with variables. One variable can store only one value. If we want to store multiple values of same type, array variable is there to do that job. What is an array? An array variables is capable of storing multiple values of same type.   Syntax:  datatype[ ] arrayName = new datatype[size]; Example: int [ ] myNumbers = new int [ 5];  The above array variable  myNumbers is capable of storing 5 integer values. In the memory it will allocate 5 slots to store 5 values, index starting from 0 to 4. Array indexing will always start with 0 and end with size -1. Types of Arrays in C# : There are 3 types of array in C#.  Single dimensional array, multi dimensional array and jagged array. Single dimension array represent a single column or row of values. The above example is for the same. Multi dimension array represent 2 dimension or 3 di...

 Hello, Welcome to C# learning. My name is Abdul Yesdani. Today we are going to discuss about decision making or branching statements and looping or iteration statements in the C# language. Decision making statements: To make a firm decision we will use decision making statements. For this we will use specific key words such as if, if-else. example: A buyer   wants to buy a product, but he will make a decision to buy it if  the product is available for less than some x amount. int price = 180; if (price < 200)   Console.WriteLine("Buy the product"); if() statement checks Boolean value of a variable , means the value is true or false. price is assigned with 180. In the statement if (price < 200) , the boolean value is true. When the value is true the statement or block of statements which follows if will get executed. So out put will be Buy the product. int price = 280; if (price < 200)       Console.WriteLine("Buy the product"); else ...