8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 1/13

1. MEMULAI SQL*PLUSStart,run,CMD,klik ok.ketik sqlplus,lalu input username dan pass.

2. SQL > alter user HR account unlock;

3. SQL > alter user HR identifed by HR;

4. CONNECT [user name/password] men!"u#un!kan aplikasi den!an data#aseConne$t %&/%&

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 2/13

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 3/13

3. E EC[ TE] men-alankan se#ua" perinta" 5(/S ( satu #aris2

Dibahas pada PL SQL.SQL>!"!#

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 4/13

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 5/13

<. )[55END] te=t menam#a"kan spesi ikasi te=t pada ak"ir perinta" S ( di #u er.SQL> select $ %ro& e&ployees;

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 6/13

>?. append w"ere irst@name A BSusan 2

>>. C[%)N E] meru#a" karakter/strin! 1an! lama den!an 1an! #aru.> . S ( 7 sele$t 0 rom emplo1ees w"ere irst@name A BSusan 2>F. S ( 7 $/Susan/5at2

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 7/13

>4. :[N5 T] te=t serupa den!an append.

Sele$t 0 rom emplo1ees2:nput w"ere irst@name A Bsusan 2

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 8/13

>'. ([:ST] memperli"atkan list perinta" 1an! terdapat pada #u er sele$t 0 rom emplo1ees2 input w"ere irst@name A BSusan 2 (:ST

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 9/13

'(. select $ %ro& e&ployees;input )here last*na&e + ,#a&brault-;

input and salary >+ ' ; L/S0 DE( F2 (:ST

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 10/13

>6. S[T)&T] ile@name[.e=t] men-alankan perinta" sql pada suatu ile 1uat fle &ypraktek.s l pada %older D 4 berisi select $ %ro& re5ions;

S06R0 D 4&ypraktek.s l;

>8. E[D:T] [ ile@name[.e=t]] men!edit suatu ile #erisi perinta" sql .

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 11/13

ED:T D 9m1praktek.sql2

><. S)G[E] ile@name[.e=t] [C&E)TEH&E5()CEH)55END] men1impan perinta" sql pada #u er ke suatuile.

sele$t 0 rom emplo1ees2S ( 7 S)GE D 9m1praktek.sql )55END2

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 12/13

?. S5OO( ile@name[.e=t] di!unakan untuk merekam seluru" aktiIitas sqlplus dan "asiln1a. Juatla" ile #u er.sql pada older D atau older 1an! anda ke"endaki.S5OO( D 9#u er.sql2ED:T D 9#u er.sql2

>. D:SCONNECT memutuskan "u#un!an aplikasi den!an data#aseS (7 dis$onne$t

. 5)SSKO&D [username] men!!anti password5assword %&

8/19/2019 laporan awal 100315

http://slidepdf.com/reader/full/laporan-awal-100315 13/13

(aporan )wal 5en!enalan S (

5ertemuan

Disusun ole"

Litria sari

*>F> ?46+

Sistem :n ormasi

5oliteknik STM:, ak;5us

?>3