Change name on the sql table

cms technology web page configuration drupal web site

Setup and configuration of cms and drupal web site

SQL> select * from dept;

DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

SQL> SELECT DEPTNO as id, DNAME as "DEPT. Name", LOC as Location FROM dept;

ID DEPT. Name LOCATION
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

SQL> SELECT
2 DEPTNO as "id"
3 DNAME as "Dept. Name",
4 LOC as Location
5 FROM dept;
DNAME as "Dept. Name",
*
ERROR at line 3:
ORA-00923: FROM keyword not found where expected

SQL> SELECT
2 DEPTNO as "id"
3 ,
4 DNAME as "Dept. Name",
5 LOC as location
6 FROM dept;

id Dept. Name LOCATION
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

SQL>

EXAMPLE 2

SQL> select ename, empno from emp where empno > 7800 order by ename;

ENAMEÂ Â Â Â Â Â Â Â Â Â EMPNO
---------- ----------
ADAMSÂ Â Â Â Â Â Â Â Â Â Â 7876
FORDÂ Â Â Â Â Â Â Â Â Â Â Â 7902
JAMESÂ Â Â Â Â Â Â Â Â Â Â 7900
KINGÂ Â Â Â Â Â Â Â Â Â Â Â 7839
MILLERÂ Â Â Â Â Â Â Â Â Â 7934
TURNERÂ Â Â Â Â Â Â Â Â Â 7844

6 rows selected.

SQL> select ename as "Full Name", empno as "ID" from emp where empno > 7800 order by ename;

Full NameÂ Â Â Â Â Â Â Â Â ID
---------- ----------
ADAMSÂ Â Â Â Â Â Â Â Â Â Â 7876
FORDÂ Â Â Â Â Â Â Â Â Â Â Â 7902
JAMESÂ Â Â Â Â Â Â Â Â Â Â 7900
KINGÂ Â Â Â Â Â Â Â Â Â Â Â 7839
MILLERÂ Â Â Â Â Â Â Â Â Â 7934
TURNERÂ Â Â Â Â Â Â Â Â Â 7844

6 rows selected.

SQL>Â