ddl dml view
Download
Skip this Video
Download Presentation
DDL, DML, VIEW

Loading in 2 Seconds...

play fullscreen
1 / 7

DDL, DML, VIEW - PowerPoint PPT Presentation


  • 113 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' DDL, DML, VIEW' - shlomo


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
slide2
DDL
  • Create
  • Alter
  • Drop
slide3
DML
  • Insert

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

  • Update

UPDATE Nama_tabel SET Nama_kolom=value WHERE Kondisi

slide4
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 …

slide6
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
ad