TUGAS ORACLE BUAT BESOK

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Linda>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sen Jun 2 17:52:38 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> CREATE TABLE PENERBIT( kdpenerbit char(4) primary key, nama_penerbit varchar2(100) not null, kota varchar2(50) not null);

Table created.


SQL> CREATE TABLE BUKU( isbn char(13) Primary key, Judul_buku varchar2(200) Not null, pengarang varchar2(200) Not null, penerbit char(4) Not null CONSTRAINT penerbit_fk REFERENCES penerbit(kdpenerbit), thterbit number(4) Not null, jns_buku char(1) CONSTRAINT jenis_buku_ck CHECK (jns_buku IN('F','N','U','D')) );

Table created.

SQL> insert into PENERBIT values ('0001','Elexmedia','Jakarta');

1 row created.

SQL> insert into PENERBIT values ('0002','Andi Ofset','Yogyakarta');

1 row created.

SQL> insert into BUKU values ('12312312312','oracleXE','Budi santoso','0001','2007','N');

1 row created.

SQL> insert into BUKU values ('2342342341','Chinmi 3','Maekawa','0001','2007','F');

1 row created.

SQL> insert into BUKU values ('1541541542','Linux','wawan','0002','2007','U');

1 row created.

SQL> insert into BUKU values ('33322233311','Red hat','Wina','0001','2008','U');

1 row created.

SQL> select * from BUKU;

ISBN
-------------
JUDUL_BUKU
--------------------------------------------------------------------------------
PENGARANG
--------------------------------------------------------------------------------
PENE   THTERBIT J
---- ---------- -
12312312312
oracleXE
Budi santoso
0001       2007 N


ISBN
-------------
JUDUL_BUKU
--------------------------------------------------------------------------------
PENGARANG
--------------------------------------------------------------------------------
PENE   THTERBIT J
---- ---------- -
2342342341
Chinmi 3
Maekawa
0001       2007 F


ISBN
-------------
JUDUL_BUKU
--------------------------------------------------------------------------------
PENGARANG
--------------------------------------------------------------------------------
PENE   THTERBIT J
---- ---------- -
1541541542
Linux
wawan
0002       2007 U


ISBN
-------------
JUDUL_BUKU
--------------------------------------------------------------------------------
PENGARANG
--------------------------------------------------------------------------------
PENE   THTERBIT J
---- ---------- -
33322233311
Red hat
Wina
0001       2008 U


SQL> select * from PENERBIT;

KDPE
----
NAMA_PENERBIT
--------------------------------------------------------------------------------
KOTA
--------------------------------------------------
0001
Elexmedia
Jakarta

0002
Andi Ofset
Yogyakarta

KDPE
----
NAMA_PENERBIT
--------------------------------------------------------------------------------
KOTA
--------------------------------------------------


SQL>