BASIC SQL REFERENCE FOR ORACLE DBA

OVERVIEW OF SQL Please create the scott schema from the following GITHUB repository //github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.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 […]

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 Client side application development tools. Advantages […]