Ddl dml view
This presentation is the property of its rightful owner.
Sponsored Links
1 / 7

DDL, DML, VIEW PowerPoint PPT Presentation


  • 51 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Ddl dml view

DDL, DML, VIEW


Ddl dml view

DDL

  • Create

  • Alter

  • Drop


Ddl dml view

DML

  • Insert

    INSERT Into Nama_Table ( Nama_kolom1, Nama_kolom2,…) values ( nilai1, nilai2,…)

  • Update

    UPDATE Nama_tabel SET Nama_kolom=value WHERE Kondisi


Ddl dml view

  • Delete

    DELETE From Nama_tabel Where Kondisi

  • Select

    Select Nama_filed from nama_table

    Select * from Nama_table


Query antar table

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 …


Ddl dml view

VIEW

  • Adalah sebuah table virtual yang isi/nilai didalamnya didefinisikan melalui perintah query.

  • Sintaks:

    Create View Nama_view

    As Ekspresi select


Contoh

Contoh:

  • create view vpegawai

  • as select * from peg

  • Cara menampilakan view sama dengan menampilkan table.

  • Select * from vpegawai


  • Login