Contoh Program NetPrice menggunakan eclipse

buat file pada directory /res/layout/netprice.xml

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical" >

    <TableLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content" >

        <TableRow
            android:id="@+id/tableRow1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" >

            <TextView
                android:id="@+id/textView1"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:layout_marginLeft="80dp"
                android:gravity="center"
                android:text="@string/judul"
                android:textAppearance="?android:attr/textAppearanceLarge" />

        </TableRow>

        <TableRow
            android:id="@+id/tableRow2"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" >

            <TextView
                android:id="@+id/textView2"
                android:layout_width="0dp"
                android:layout_height="wrap_content"
                android:layout_weight="0.75"
                android:text="@string/nb"
                android:layout_marginRight="30dp"
                android:textAppearance="?android:attr/textAppearanceMedium" />

            <EditText
                android:id="@+id/editBarang"
                android:inputType="text"
                android:layout_width="0dp"
                android:layout_weight="0.75"
                android:layout_height="wrap_content"
                android:ems="10" />

        </TableRow>

Instalasi basis data Oracle XE 10.2.0 di Ubuntu 32 bit

Langkah Pertama :
Silakan unduh dahulu paket perangkat lunak basis data Oracle 10.2 di sini

Langkah Kedua
 abiyasa@abiyasa : ~$ sudo apt-get install libaio1

Kemudian Langkah Ketiga :
Instalasi paket basis data Oracle 10.2
abiyasa@abiyasa:~$ sudo dpkg -i Downloads/oracledb10

Langkah Keempat :
abiyasa@abiyasa:~$ sudo /etc/init.d/oracle-xe configure

 
Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express 
Edition.  The following questions will determine whether the database should 
be starting upon system boot, the ports it will use, and the passwords that 
will be used for database accounts.  Press <Enter> to accept the defaults. 
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"
 
Keterangan 

• Specify the HTTP port that will be used for Oracle Application Express [8080]: <tekan enter>
• Specify a port that will be used for the database listener [1521]: <tekan enter>
• Specify a password to be used for database accounts. Note that the same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after initial configuration: <masukkan kata sandi>
• Confirm the password: <masukkan kata sandi lagi untuk verifikasi>
• Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]: <tekan enter> 

Kemudian jalankan oracle tersebut :
http://127.0.0.1:8080/apex
 
 

 *sumber : http://wiki.stmik-kharisma.ac.id

 

Membuat View Menggunakan Oracle

create view MHSVV10
AS SELECT NIM, NAMA_MHS
from MAHASISWA
where KODE_JUR=''NAP';

membuat database dan tabel di mysql

Insert into anggota (nomor,nama,email,alamat,kota)values(100,'Bacink','bacinkah@yahoo.com','warungbambu','karawang');
Query OK, 1 row affected (0.00 sec)
 dan untuk melihat hasilnya adalah
select * from anggota;
hasilnya akan seperti ini