|
om my_employee
8.18
savepoint lab8_18
8.19
delete my_employee
8.20
select * from my_employee
8.21
rollback to lab8_18
8.22
select * from my_employee
8.23
commit
9.1
create table dept
(id number(7),name varchar2(25));
desc dept
9.2
insert into dept
select department_id, department_name from departmen
|
|
|
to_char(hire_date,'yyyy'),'1995',1,0)) "1995", sum(decode(to_char(hire_date,'yyyy'),'1996',1,0)) "1996", sum(decode(to_char(hire_date,'yyyy'),'1997',1,0)) "1997", sum(decode(to_char(hire_date,'yyyy'),'1998',1,0)) "1998" from employees
5.12
select job_id as "job"
,sum(decode(department_id, 20, salary
|
|
|
to be the Microsoft Windows? 2000 operating system, and the use of Microsoft SQL Server 2000, and Oracle?9i™ Database Server Release 1.
Overview
Understanding the features of the Microsoft? SQL Server and Oracle9i Database can be a daunting task. This white paper discusses the features of
|
|
|
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Apr 7 11:10:44 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Clusters options
JServer Release 9.2.
|
|
|
SQL and PL/SQL
1Z0-013 : Oracle 8: Database Administration
1Z0-014 : Oracle 8: Performance Tuning Workshop
1Z0-015 : Oracle 8: Backup and Recovery Workshop
1Z0-016 : Oracle 8: Network Administration
OCA
iZ0-007 : Introduction to Oracle9i: SQL
iZ0-031 : Oracle 9i Database: Fundamentals I
|
|
메뉴펼치기
