create table "tes"
( "nama" varchar2(20) not null enable,
"nim" varchar2(20) not null enable,
"jurusan" varchar2(20) not null enable,
constraint "tes_pk" primary key ("nama") enable
)
insert into TES(nama,nim,jurusan) values ('uyab','20121070311255','informatika')
drop table "tes"
alter table alat modify id_alat varchar2(30)
alter table alat rename column nama to nama_alat
alter table fasilitas rename to alat
update transaksi set bayar= '150000'
where no_transaksi ='Tr003'
DELETE FROM KARYAWAN
WHERE ID_KARYAWAN ='K003'
SELECT TANGGAL,SUM(BAYAR) AS TOTAL FROM TRANSAKSI GROUP BY TANGGAL
select id_member, nama_member,alamat_member from member where nama_member like 'S%' order by id_member asc
