|
from 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 departm
|
|
|
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
|
|
|
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.
|
|
|
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문을 작성하여라.
SELECT AVG(2014 - to_number(SUBSTR(Birth_date,1,2)))
FROM (
SELECT SID, Name, Birth_date
FROM student1
union
SELECT SID, Name, Year_birth || \'/\'|| Month_birth || \'/\'|| Day_birth
FROM student2
) 2장 연습문제 1번, 6번
1. E-R 모델과 E-R 다이어그램에 대해 설명하
|
|
메뉴펼치기
