1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/PLSQL/FormattingOptions/src/org/netbeans/modules/plsql/format/options/IndentationExample	Thu Sep 22 15:46:11 2011 +0200
     1.3 @@ -0,0 +1,14 @@
     1.4 +CREATE OR REPLACE FUNCTION emptype (paytype CHAR)
     1.5 +RETURN VARCHAR2 IS
     1.6 +BEGIN
     1.7 +   IF paytype = 'H' THEN
     1.8 +      RETURN 'Hourly';
     1.9 +   ELSIF paytype = 'S' THEN
    1.10 +      RETURN 'Salaried';
    1.11 +   ELSE
    1.12 +      RETURN 'Invalid Type';
    1.13 +   END IF;
    1.14 +EXCEPTION
    1.15 +   WHEN OTHERS THEN
    1.16 +      RETURN 'Error Encountered';
    1.17 +END emptype;
    1.18 \ No newline at end of file