Search
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
0
418 views
Sign In
Upload
Join
RELATED TITLES
0
Tugas Mandiri 3 Basis Data LanjutFungsi Baris Tunggal - Agung Priyo Sembodo - 7411030854
Uploaded by Agung Menggapai Mimpi
Save
Embed
Share
Print
Tugas Mandiri 10 Basis Data
1
Download
of 6
Tugas Mandiri 11 Basis Data
Tugas Mandiri 5 Basis Data
Search document
TUGAS MANDIRI 3 (FUNGSI BARIS TUNGGAL) BASIS DATA LANJUT
Sheet Music
Nama Mahasiswa NRP Jurusan Kelas Mata Kuliah Dosen Pengajar
1.
: Agung Priyo Sembodo Sembodo : 7411030854 : D3 PJJ – Teknik Informatika : 2 Informatika B : Basis Data Lanjut : Rengga Asmara, S.Kom
Buat query untuk menampilkan tanggal hari ini dan beri judul „TANGGAL‟
Jawab :
a.
Source Code SQL> Select sysdate as "TANGGAL" "TANGGAL" 2 From dual;
b.
Capture Output
Master2. your semester withnama, Scribd Tampilkan nomer pegawai, gaji dan gaji setelah dinaikkan 15% Read Free Foron 30this Days Sign up to vote title & The New York Times Useful Not useful Special offer for students: Only $4.99/month.
Cancel anytime.
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
0
418 views
Sign In
Upload
Join
RELATED TITLES
0
Tugas Mandiri 3 Basis Data LanjutFungsi Baris Tunggal - Agung Priyo Sembodo - 7411030854
Uploaded by Agung Menggapai Mimpi
Save
Embed
Share
Print
1
Download
b.
3.
Tugas Mandiri 10 Basis Data
of 6
Tugas Mandiri 11 Basis Data
Tugas Mandiri 5 Basis Data
Search document
Capture Output
Tampilkan nama pegawai, tanggal mulai bekerja dan tampilan tanggal hari Senin setelah 6 bulan dia bekerja (beri judul REVIEW). Format untuk tanggal, misal : “Monday, the Twenty-Fourth of May, 1982”
Jawab :
a.
Source Code
You're Reading a Preview
SQL> Select ename, hiredate, Unlock full access with a free trial. 2 To_Char(Next_Day(Add_Months(hiredate,6), 'MONDAY'), '"MONDAY THE" FMDDSPTH "OF" MONTH "," Trial YYYY') as REVIEW Download With Free 3 From emp; b.
Capture Output
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
0
418 views
Sign In
Upload
Join
RELATED TITLES
0
Tugas Mandiri 3 Basis Data LanjutFungsi Baris Tunggal - Agung Priyo Sembodo - 7411030854
Uploaded by Agung Menggapai Mimpi
Save
Embed
Share
Print
1
Download
4.
Tugas Mandiri 10 Basis Data
of 6
Tugas Mandiri 11 Basis Data
Tugas Mandiri 5 Basis Data
Search document
Untuk tiap pegawai tampilkan nama pegawai, hitung jumlah bulan pegawai terseb bekerja, lakukan pembulatan keatas (round)
Jawab :
a.
Source Code
SQL> Select ename, Round(months_between(sysdate,hiredate)) Bulan_Bekerja 2 From emp; b.
Capture Output
You're Reading a Preview Unlock full access with a free trial.
5.
Download With Free Trial Buat query yang bisa menampilkan informasi dalam satu kolom yang berisi informasi gajinya sebulan tapi ingin <3 kali gaji> beri judul kolom “GAJI IMPIAN”
Jawab :
Master your semester with Scribd a. Source Code Read Free Foron 30this Days Sign up to vote title SQL> Select ename ||' gajinya ' || sal ||' sebulan tapi ingin ' || sal*3 as "GajiSebu & The New York Times Useful Not useful 2 From emp; Special offer for students: Only $4.99/month.
Cancel anytime.
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
0
418 views
Sign In
Upload
Join
RELATED TITLES
0
Tugas Mandiri 3 Basis Data LanjutFungsi Baris Tunggal - Agung Priyo Sembodo - 7411030854
Uploaded by Agung Menggapai Mimpi
Save
Embed
Share
Print
1
Download
b.
6.
Tugas Mandiri 10 Basis Data
of 6
Tugas Mandiri 11 Basis Data
Tugas Mandiri 5 Basis Data
Search document
Capture Output
Tampilkan Buat query untuk menampilkan nama dan gaji dengan format 15 panjangnya, rata kiri dan kolom yang kosong diisi dengan „$‟, beri label “GAJI”
Jawab :
a. Source Code SQL> Select ename, LPAD(sal,15,'$') You're ReadingGAJI a Preview 2 From emp;
Unlock full access with a free trial.
b.
Capture Output
Download With Free Trial
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
0
418 views
Sign In
Upload
Join
RELATED TITLES
0
Tugas Mandiri 3 Basis Data LanjutFungsi Baris Tunggal - Agung Priyo Sembodo - 7411030854
Uploaded by Agung Menggapai Mimpi
Save
Embed
Share
Print
Tugas Mandiri 10 Basis Data
1
Download
of 6
Tugas Mandiri 11 Basis Data
Tugas Mandiri 5 Basis Data
Search document
Jawab :
a. Source Code SQL> Select ename, length(ename) as PANJANG 2 From emp 3 Where ename LIKE 'J%' or ename LIKE 'A%' or ename LIKE 'M%'; b.
Capture Output
You're Reading a Preview Unlock full access with a free trial.
8.
Free Trial Buat query yang menampilkanDownload nama danWith jumlah komisi, jika komisi sama dengan ganti dengan keterangan “Tidak ada Komisi” dan beri judul „Komisi‟.
Jawab : Master your semester with Scribd a. Source Code Read Free Foron 30this Days Sign up to vote title SQL>Times Select Ename, NVL(To_Char(comm), 'TIDAK KOMISI') as KO & The New York Useful ADA useful Not
2 $4.99/month. From emp; Special offer for students: Only
Cancel anytime.
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
0
418 views
Sign In
Upload
Join
RELATED TITLES
0
Tugas Mandiri 3 Basis Data LanjutFungsi Baris Tunggal - Agung Priyo Sembodo - 7411030854
Uploaded by Agung Menggapai Mimpi
Save
Embed
Share
Print
1
Download
b.
9.
Tugas Mandiri 10 Basis Data
of 6
Tugas Mandiri 11 Basis Data
Tugas Mandiri 5 Basis Data
Search document
Capture Output
Buat query yang menampilkan nama pegawai dan jumlah gaji yang ditampilkan symbol „*‟, tiap satu „*‟ mewakili ratusan dollar. Jawab :
a. Source Code SQL> Select ename, RPAD(sal,10, '*') GAJI 2 From emp; b.
Capture Output
You're Reading a Preview Unlock full access with a free trial.
Download With Free Trial
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join