Oracle DBA FAQ - Understanding PL/SQL Language Basics

A collection of 22 FAQs on PL/SQL language basics or DBA and developers. It can also be used as learning tutorials on defining variables, assigning values, using "loop" statements, setting "if" conditions, and working with null values.

1. What Is PL/SQL Language Case Sensitive?
2. How To Place Comments in PL/SQL?
3. What Are the Types PL/SQL Code Blocks?
4. What Is an Anonymous Block?
5. What Is a Named Program Unit?
6. What Is a Procedure?
7. What Is a Function?
8. How To Declare a Local Variable?
9. How To Initialize Variables with Default Values?
10. How To Assign Values to Variables?
11. What Are the Arithmetic Operations?
12. What Are the Numeric Comparison Operations?
13. What Are the Logical Operations?
14. How Many Categories of Data Types?
15. How Many Scalar Data Types Are Supported in PL/SQL?
16. How To Convert Character Types to Numeric Types?
17. What Are the Execution Control Statements?
18. How To Use "IF" Statements on Multiple Conditions?
19. How To Use "WHILE" Statements?
20. How To Use "FOR" Statements?
21. What Is NULL in PL/SQL?
22. How To Test NULL Values?

----->Answers