1 / 7

DDL, DML, VIEW

DDL, DML, VIEW. DDL. Create Alter Drop. DML. Insert INSERT Into Nama_Table ( Nama_kolom1, Nama_kolom2,…) values ( nilai1, nilai2,…) Update UPDATE Nama_tabel SET Nama_kolom = value WHERE Kondisi. Delete DELETE From Nama_tabel Where Kondisi Select

shlomo
Download Presentation

DDL, DML, VIEW

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DDL, DML, VIEW

  2. DDL • Create • Alter • Drop

  3. DML • Insert INSERT Into Nama_Table ( Nama_kolom1, Nama_kolom2,…) values ( nilai1, nilai2,…) • Update UPDATE Nama_tabel SET Nama_kolom=value WHERE Kondisi

  4. Delete DELETE From Nama_tabel Where Kondisi • Select Select Nama_filed from nama_table Select * from Nama_table

  5. Query antar table • SELECT Nama_tabel1.nama_kolom1,nama_tabel2.nama_kolom2,… from nama_tabel1, Nama_tabel2,… Where Nama_tabel_induk.Primary key=nama_tabel_transaksi.foreign key and …

  6. VIEW • Adalah sebuah table virtual yang isi/nilai didalamnya didefinisikan melalui perintah query. • Sintaks: Create View Nama_view As Ekspresi select

  7. Contoh: • create view vpegawai • as select * from peg • Cara menampilakan view sama dengan menampilkan table. • Select * from vpegawai

More Related