Salim berbagi…. tempat belajar dan berinteraksi….


Union & Union All
May 19, 2010, 12:42 AM
Filed under: ORACLE, Sistem Informasi

UNION is a SQL set operation that returns all rows from two different select statements, and then eliminates any duplicate rows from the result set.

For example, the below query will return all rows from table_A and table_B (no duplicates):

SELECT * FROM table_A
UNION
SELECT * FROM table_B;

UNION ALL is a SQL set operation that returns all rows from two different select statements. Unlike with Union, duplicate rows are NOT removed from the result set. As a result, UNION ALL is faster than a UNION.

For example, the below query will return all rows from table_A and table_B (may contain duplicate rows):

SELECT * FROM table_A
UNION ALL
SELECT * FROM table_B;


Kisi-Kisi UAS Oracle I
May 17, 2010, 11:36 PM
Filed under: Sistem Informasi

Berikut kisi-kisi UAS mata kuliah Oracle I, jurusan Sistem Informasi, semester genap 2010.

– Oracle Built in Function

– Date Conversion

– Aggregate Function

– DML: Update

– DML: Insert table from select statement



Query from Multiple Table
May 5, 2010, 8:21 AM
Filed under: Sistem Informasi

Silakan download update materi Oracle I – Query from Multiple Table.

4 – Query With Multiple Table



Tips Skripsi – Teknik Informatika / Sistem Informasi
March 15, 2010, 2:17 AM
Filed under: Sistem Informasi, Teknik Informatika

Untuk rekan-rekan mahasiswa jurusan Teknik Informatika atau Sistem Informasi, artikel berikut sangat bemanfaat untuk dijadikan panduan dan penyemangat untuk mempersiapkan tahapan skripsi. Artikel ini ada di http://skripsi-tugasakhir.blogspot.com/2007/07/tips-untuk-mengerjakan-skripsi-teknik.html

Tips skripsi



Kisi – Kisi UTS – SI – Oracle 1
March 12, 2010, 12:57 AM
Filed under: Sistem Informasi

Berikut kisi – kisi UTS untuk mata kuliah Oracle 1, STMIK Bani Saleh Bekasi jurusan Sistem Informasi, tahun akademik 2010 / 2011:

– Table

– Sequence

– Index

– Unique Constraint

– Grant / Revoke

Pelajari lebih detail mengenai fungsi dan kegunaan, syntax pembuatan, dll.

Good luck !



Step by Step Installation – Oracle Database 9.2.0 (Windows)
March 10, 2010, 2:16 AM
Filed under: Sistem Informasi, Teknik Informatika

Berisi tentang:

– Langkah – langkah install database Oracle di windows

-Setting tnsname

-Test koneksi ke database Oracle

Step by Step Installation – Oracle Database 9.2.0 (Windows)



Materi ORACLE I untuk Sistem Informasi STMIK Bani Saleh Bekasi
February 3, 2010, 2:19 AM
Filed under: KAMPUS, Sistem Informasi

Silakan download file-file di bawah ini sebagai referensi mata kuliah Oracle I

SI – ORACLE – SQL Guide Line

Oracle_RDBMS_&_SQL_Tutorial_(Very_good)

Presentation2

Presentation3

Presentation4

2 – Demo

4 – SQL With Multiple Table

5 – Exercise

6 – DML

Buku Pegangan Oracle DBA