Question d’entretien chez NowNow

Differentiate between SQL and PL/SQL. What is the importance of %TYPE and %ROWTYPE data types in PL/SQL? What are the various functions available for manipulating the character data?