sql explicit join

Oracle SQL

cms technology web page configuration drupal web site

Setup and configuration of cms and drupal web site

SQL> edit sql_explicit01

SELECT
e.empno,
e.ename,
d.dname,
d.loc
FROM
emp e INNER JOIN dept d
ON
e.deptno = d.deptno
ORDER BY
d.loc;

SQL> start sql_explicit01
DOC>select
DOC> e.empno as "ID",
DOC> INITCAP(e.ename) as "NAME",
DOC> INITCAP(d.dname) as "DEPT.",
DOC> INITCAP(d.loc) as "LOCATION"
DOC>from
DOC> emp e, dept d
DOC>where
DOC> e.deptno = d.deptno
DOC>order by
DOC> d.loc;
DOC>*/

Employee Salary statistics
EMPNO ENAME DNAME LOC
---------- ---------- -------------- -------------
7499 ALLEN SALES CHICAGO
7521 WARD SALES CHICAGO
7654 MARTIN SALES CHICAGO
7900 JAMES SALES CHICAGO
7844 TURNER SALES CHICAGO
7698 BLAKE SALES CHICAGO
7369 SMITH RESEARCH DALLAS
7902 FORD RESEARCH DALLAS
7876 ADAMS RESEARCH DALLAS
7566 JONES RESEARCH DALLAS
7788 SCOTT RESEARCH DALLAS
7782 CLARK ACCOUNTING NEW YORK
7839 KING ACCOUNTING NEW YORK
7934 MILLER ACCOUNTING NEW YORK
SQL>

EXAMPLE 2:

SQL> edit sql_explicit02

SELECT
e.empno as "ID",
INITCAP(e.ename) as "NAME",
INITCAP(d.dname) as "DEPT.",
INITCAP(d.loc) as "LOCATION"
FROM
emp e INNER JOIN dept d
ON
e.deptno = d.deptno
ORDER BY
d.loc;

SQL> start sql_explicit02
DOC>select
DOC> e.empno as "ID",
DOC> INITCAP(e.ename) as "NAME",
DOC> INITCAP(d.dname) as "DEPT.",
DOC> INITCAP(d.loc) as "LOCATION"
DOC>from
DOC> emp e, dept d
DOC>where
DOC> e.deptno = d.deptno
DOC>order by
DOC> d.loc;
DOC>*/

Employee Salary statistics
ID NAME DEPT. LOCATION
---------- ---------- -------------- -------------
7499 Allen Sales Chicago
7521 Ward Sales Chicago
7654 Martin Sales Chicago
7900 James Sales Chicago
7844 Turner Sales Chicago
7698 Blake Sales Chicago
7369 Smith Research Dallas
7902 Ford Research Dallas
7876 Adams Research Dallas
7566 Jones Research Dallas
7788 Scott Research Dallas
7782 Clark Accounting New York
7839 King Accounting New York
7934 Miller Accounting New York
SQL>