ABOUT WRITER

Hello, my name is Getto Serafim. Born as a child who will never be satisfied and always wants to try something.

Maybe I am already far behind the others. When others have succeeded in creating the web but I just started it. I used to try to make it but it didn't work. Do not understand?? Not a reason because others also do not understand how to create a blog / web. If they are asked, how do you make it? The answer is, "I taught myself". It all makes the spirit of enthusiasm for me to keep trying and not give up.

FAILED?? Not yet, yesterday's failure did not make me become discouraged but made learning. At least I know the basics of creating a blog and when I try it again it doesn't become foreign. When I haven't started making the web anymore, I don't keep quiet but I keep learning ways to create a good web that is also interesting so that it provides benefits to readers and writers of course.

A good job and most liked is a paid hobby. I have a hobby of drawing as well as writing. I don't want it all to just be in vain in my life, then I pour it in my personal blog. For me now, this is an investment or I am sowing and one day I can reap. My goal is to become a successful business woman. Seeing now more and more competitors and difficult to match, I tried something different, also competing in sportsmanship.

In my current environment, starts from word of mouth me being known as a design child. So, if anyone needs to design for an event or activity they can contact me directly. Customer demand is not normal, of course they want something different than others, this also makes me continue to not stop learning to find new knowledge.

It all started with small things, I started with image design but now there are many requests to make videos and websites as well as databases. This is not easy but I try to understand the manufacturing process and even master it. This is also the reason for me to keep on fighting to be able to reach my dreams.

Thank you for all who have supported and helped me. 😊😇

MEMBUAT DATABASE MENGGUNAKAN ORACLE VM VIRTUALBOX

Oracle VM VirtualBox adalah perangkat lunak virtualisasi, yang dapat digunakan untuk mengeksekusi sistem operasi "tambahan" di dalam sistem operasi "utama". Sebagai contoh, jika seseorang mempunyai sistem operasi MS Windows yang terpasang di komputernya, maka seseorang tersebut dapat pula menjalankan sistem operasi lain yang diinginkan di dalam sistem operasi MS Windows.

Dan sekarang, kita akan membuat database menggunakan Oracle VM Virtualbox.

Masuk ke dalam hak akses admin dan membuat user baru

• Jalankan Virtualbox, klik Next 
• Masuk ke hak akses dan membuat user baru

sqlplus sys/oracle as sysdba; è masuk ke dalam hak akses admin

create user toko identified by 1234; è membuat user baru dengan nama toko menggunakan password 1234

grant connect to toko; è memberikan hak akses koneksi kepada toko

grant resource to toko; è memberikan hak akses resource kepada toko

exit è keluar dari hak akses admin

Membuat table, field, dan record

sqlplus toko/1234; è masuk ke dalam user toko menggunakan password 1234

create table è Membuat tabel (customer, barang, beli)

sql > create table customer (

            id_cust varchar (5),

            nama varchar (20),

            alamat varchar (50)

            );

sql > create table barang (

            id_brg varchar (5),

            nama_brg varchar (50),

            brand varchar (20),

jenis_brg varchar (20),

harga number (20)

            );

sql > create table beli (

            id_cust varchar (5),

            nama_brg varchar (50),

            kode_belanja varchar (20),

tgl_beli date,

total number (20)

            );

drop table customer; è menghapus tabel customer dikarenakan adanya kesalahan

insert into è memasukkan data ke dalam tabel (customer, barang, dan beli)

insert into barang values (‘A001’,’Tiner’,’Nippon’,’Cair’,’120000’);

insert into barang values (‘A002’,’Cat’,’Avitex’,’Cair’,’150000’);

insert into customer values (‘C001’,’Abel’,’Markoni’);

insert into customer values (‘C002’,’Bela’,’Sepinggan’);

insert into beli values (‘C001’,’Tiner’,’KB01’,’1-January-2019’,’120000’);

insert into beli values (‘C002’,’Cat’,’KB02’,’2-January-2019’,’150000’);

Menentukan line size dan menampilkan data dari tabel

set linesize 120; è menentukan line size

select * from è menampilkan data dari tabel customer, barang, dan beli

select * from barang;

select * from customer;

select * from beli;

Sekian dan semoga bermanfaat.. 😊