好奇於生命中曾經出現過的人~
可能已成相見如同陌路~
他們的現況充滿神秘~
有d可能仲讀緊書...
有d可能已經o係社會打滾左幾年~
本著人類求知精神click 入哩d 人o既XANGA~
好多已經停止更新或者Friend Lock~

SET VERIFY ON
SET ECHO ON

ACCEPT low_date DATE FORMAT 'MM/DD/YYYY' -
PROMPT 'Please enter the low date range ("MM/DD/YYYY"):'

ACCEPT high_date DATE FORMAT 'MM/DD/YYYY' -
PROMPT 'Please enter the high date range ("MM/DD/YYYY"):'

COLUMN EMPLOYEES FORMAT A25

SELECT ename || ',' || job EMPLOYEES, hiredate
   FROM emp
   WHERE hiredate BETWEEN TO_DATE('&low_date','MM/DD/YYYY')
     AND TO_DATE('&high_date','MM/DD/YYYY');

SET VERIFY OFF
SET ECHO OFF

T11q1.sql :
COLUMN view_name FORMAT A20
COLUMN text FORMAT A40
select view_name, text
     from user_views;

t11q1a.sql
CREATE VIEW emp_EF AS
   SELECT empno, ename EMPLOYEE, deptno
   FROM emp;

select * from emp_EF;

T11q5a.sql
CREATE VIEW DEPT_20b AS
  SELECT empno EMPLOYEE_ID, ename EMPLOYEE,
         deptno DEPARTMENT_ID
  FROM emp
  WHERE deptno = 20

T11q7.sql
UPDATE dept_20b
   SET department_id = 30
   WHERE employee = 'SMITH';

T11q8.sql
CREATE VIEW salary_YY AS
   SELECT ename employee, dname department,
          sal Salary, grade
   FROM emp e, dept d, salgrade s
   WHERE e.deptno = d.deptno
     AND e.sal BETWEEN s.losal AND s.hisal;

describe user_tables

select table_name from user_tables;

desc emp

c/ename/ename,/

c/salary/sal

c/ANNUAL SALARY/"ANNUAL SALARY"

save c:\p1q5.sql

c:\pp1q5.sql

@c:\pp1q5.sql

@D:\07009513a\Desktop\p1q5.sql

select ename || ',' || job "Employee and Title"

p1q5)
SELECT empno, ename,
sal * 12 "ANNUAL SALARY"
FROM emp
/
desc dept
select * from dept;