BASIC SQL REFERENCE FOR ORACLE DBA

OVERVIEW OF SQL EXECUTING SELECT STATEMENT SQL> SELECT * FROM DEPT; DEPTNO DNAME LOC ———- ————– ————- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON HANDLING NULL VALUES SQL> SELECT EMPNO,ENAME,NVL(MGR,0) FROM EMP; EMPNO ENAME NVL(MGR,0) ———- ———- ———- 7369 SMITH 7902 7499 ALLEN 7698 4567 WARD 1234 7566 JONESContinue reading BASIC SQL REFERENCE FOR ORACLE DBA

PLSQL Reference for DBA

PLSQL Reference for DBA PL/SQL stands for Procedural Language/SQL.PL/SQL extends SQL by adding control Structures found in other procedural language.PL/SQL combines the flexibility of SQL with Powerful feature of 3rd generation Language. The procedural construct and database access Are present in PL/SQL.PL/SQL can be used in both in database in Oracle Server and in ClientContinue reading PLSQL Reference for DBA