Contents of Blog

Contents of Blog

Oracle PLSQL

1. Oracle PLSQL---Function SALARY_VALID() Scenario
2. Oracle PLSQL--Creating Procedures RAISE_SALARY()
3. Oracle PLSQL--Explicit Cursor Attributes
4. Oracle PLSQL--KINDS OF CURSOR AND EXPLANATION OF EXPLICIT CURSOR
5. Oracle PLSQL--codes-concepts of FUNCTIONS
6. Oracle PLSQL--FUNCTIONS TYPES
7. Oracle PLSQL--Conditional Loop PL/SQL
8. Oracle PLSQL--Indefinite Loop Pl/sql
9. Oracle PLSQL--Complex extended user-defined types (decode the code )
10. Oracle PLSQL--“TYPE … RECORD” --- DECLARE
11. Oracle PLSQL--TYPE-TABLE Declare PL/SQL ---Scenario: We want to extract SSN of manager and worker from our database.
12. Oracle PLSQL--LOOP ---PL/SQL
13. Oracle PLSQL--GOTO ---PL/SQL
14. Oracle PLSQL--LABELS -----Scenario we want to extract the most busy employee and least busy employee
15. OraclePLSQL--DML Update & Transaction Control in PL/SQL Scenario: Let suppose we want to transfer the employee who is the least busy and we want to transfer into another task so we write the following program
16. OraclePLSQL--DATA MANIPULATION IN BEGIN CLAUSE pl/sql We want to extract the best employee name and his bdate,gender,ssn,dept name,hours to do work as well as bonus from these three tables and we want to evaluate whether or not lived in a big city or a small town and also evaluate his/her address
17. OraclePLSQL--DATA MANIPULATION IN BEGIN CLAUSE BY SQL FUNCTION
18. OraclePLSQL--uses of Cursors
19. OraclePLSQL--INTRO OF DECLARE VARIABLES PART#02
20. OraclePLSQL--INTRO OF DECLARE VARIABLES PART#01
21. OraclePLSQL--AGGREGATE AND ANALYSIS FUNCTIONS AS WELL AS WINDOW FUNCTION
22. (ANSI vs. Oracle): Inner, Outer, Self

SQL

1. MSSQL Inline Table Valued function(ILTVF)
2. MSSQL UDFs Scalar functions
3. MSsql USER DEFINED FUNCTION
4. Group By and Having Clauses