SQL> connect
Enter user-name: sales
Connected.
SQL> select * from wilayah;
KODE_WILAYAH NAMA_WILAYAH
------------ ------------------------------
1 JAWA
2 SUMATERA
3 KALIMANTAN
4 SULAWESI
5 PAPUA
SQL> select * from pelanggan
2 ;
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
201 MERCU BUANA KOMPUTER
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
MEDAN BAIK 12
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
N M
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
202 Amikom komputer 123456
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
jl dr Angka
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
purwokerto 123 baik 12
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
n m
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID
----------------------------------- ---------- --------- ------------
KODE_WILAYAH
------------
KETERANGAN
--------------------------------------------------------------------------------
S P
- -
SQL> set linesize 200;
SQL> select * from pelanggan;
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
201 MERCU BUANA KOMPUTER
MEDAN BAIK 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
N M
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
202 Amikom komputer 123456
jl dr Angka
purwokerto 123 baik 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
n m
SQL> set line size 100;
SP2-0268: linesize option not a valid number
SQL> set linesize 100;
SQL> select * from pelanggan;
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
----------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
----------------------------------------------------------------------------------------------------
S P
- -
201 MERCU BUANA KOMPUTER
MEDAN BAIK 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
----------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
----------------------------------------------------------------------------------------------------
S P
- -
N M
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
----------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
----------------------------------------------------------------------------------------------------
S P
- -
202 Amikom komputer 123456
jl dr Angka
purwokerto 123 baik 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
----------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
----------------------------------------------------------------------------------------------------
S P
- -
n m
SQL> select * from jual;
ID_JUAL ID_PLG TGL TOTAL KODE_BRG
---------- ---------- ---------- ---------- ----------
1 201 05-10-2010 1000000
2 202 10-10-2010 100000
3 202 11-10-2010 50000
4 202 11-10-2010 7500000
5 202 11-10-2010 200000
SQL> select * from barang;
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL
---------- -------------------------------------------------- ---------- ----------
SATUAN KETERANGAN
------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000
PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000
PCS ASUS P5B Plus Viste Edt Ip965
10013 Asus Striker Extreme 1003 3760000
PCS ASUS STRIKER EXTREME vVIDIA
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL
---------- -------------------------------------------------- ---------- ----------
SATUAN KETERANGAN
------------------------- ------------------------------
10021 Biostar TForce %P965 1011 970000
PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000
PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000
PCS GIGABYTE GA-945PL-S3
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL
---------- -------------------------------------------------- ---------- ----------
SATUAN KETERANGAN
------------------------- ------------------------------
20106 Seagate 80GB 470000
PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000
PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000
PCS SEAGATE 250GB SATA-II
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL
---------- -------------------------------------------------- ---------- ----------
SATUAN KETERANGAN
------------------------- ------------------------------
20512 Seagate 500gb 1950000
PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000
PCS EPSON PHOTO R-230
11 rows selected.
SQL> set linesize 200;
SQL> edit
Wrote file afiedt.buf
1* select * from barang
SQL> /
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000 PCS ASUS P5B Plus Viste Edt Ip965
10013 Asus Striker Extreme 1003 3760000 PCS ASUS STRIKER EXTREME vVIDIA
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
20106 Seagate 80GB 470000 PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000 PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000 PCS SEAGATE 250GB SATA-II
20512 Seagate 500gb 1950000 PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
11 rows selected.
SQL> select * from pelanggan;
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
201 MERCU BUANA KOMPUTER
MEDAN BAIK 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
N M
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
202 Amikom komputer 123456
jl dr Angka
purwokerto 123 baik 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
n m
SQL> select * from jual;
ID_JUAL ID_PLG TGL TOTAL KODE_BRG
---------- ---------- ---------- ---------- ----------
1 201 05-10-2010 1000000
2 202 10-10-2010 100000
3 202 11-10-2010 50000
4 202 11-10-2010 7500000
5 202 11-10-2010 200000
SQL> select * from pelanggan;
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
201 MERCU BUANA KOMPUTER
MEDAN BAIK 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
N M
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
202 Amikom komputer 123456
jl dr Angka
purwokerto 123 baik 12 2
ID_PLG NAMA_PLG TELEPON_PLG
---------- -------------------------------------------------- ---------------
ALAMAT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
KOTA KODE_POS CREDIT_RA SALES_REP_ID KODE_WILAYAH
----------------------------------- ---------- --------- ------------ ------------
KETERANGAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
S P
- -
n m
SQL> select * from barang;
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000 PCS ASUS P5B Plus Viste Edt Ip965
10013 Asus Striker Extreme 1003 3760000 PCS ASUS STRIKER EXTREME vVIDIA
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
20106 Seagate 80GB 470000 PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000 PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000 PCS SEAGATE 250GB SATA-II
20512 Seagate 500gb 1950000 PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
11 rows selected.
SQL> select * from barang where kode_brg = 10011;
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
SQL> select * from barang where harga_jual < 2000000;
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
20106 Seagate 80GB 470000 PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000 PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000 PCS SEAGATE 250GB SATA-II
20512 Seagate 500gb 1950000 PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
9 rows selected.
SQL> select kode_brg, nama_brg, image_id,harga_jual,satuan,keterangan
2 from barang
3 where nama_brg ='Abit AB9-Pro';
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
SQL> edit
Wrote file afiedt.buf
1 select kode_brg, nama_brg, image_id,harga_jual,satuan,keterangan
2 from barang
3* where nama_brg ='Abit ab9-Pro'
SQL> /
no rows selected
SQL> select * from jual;
ID_JUAL ID_PLG TGL TOTAL KODE_BRG
---------- ---------- ---------- ---------- ----------
1 201 05-10-2010 1000000
2 202 10-10-2010 100000
3 202 11-10-2010 50000
4 202 11-10-2010 7500000
5 202 11-10-2010 200000
SQL> select * from jual where tgl >='11-oct-10';
select * from jual where tgl >='11-oct-10'
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
SQL> edit
Wrote file afiedt.buf
1* select * from jual where tgl >='11-sept-11'
SQL> /
select * from jual where tgl >='11-sept-11'
*
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
SQL> edit
Wrote file afiedt.buf
1* select * from jual where tgl >='01-sept-11'
SQL> /
select * from jual where tgl >='01-sept-11'
*
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
SQL> edit
Wrote file afiedt.buf
1* select * from jual where tgl >='1-sept-11'
SQL> /
select * from jual where tgl >='1-sept-11'
*
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
SQL> edit
Wrote file afiedt.buf
1* select * from jual where tgl >='01-jan-11'
SQL> /
no rows selected
SQL> select * from jual;
ID_JUAL ID_PLG TGL TOTAL KODE_BRG
---------- ---------- ---------- ---------- ----------
1 201 05-10-2010 1000000
2 202 10-10-2010 100000
3 202 11-10-2010 50000
4 202 11-10-2010 7500000
5 202 11-10-2010 200000
SQL> edit
Wrote file afiedt.buf
1* select * from jual where tgl <= '01-jan-11'
SQL> /
ID_JUAL ID_PLG TGL TOTAL KODE_BRG
---------- ---------- ---------- ---------- ----------
1 201 05-10-2010 1000000
2 202 10-10-2010 100000
3 202 11-10-2010 50000
4 202 11-10-2010 7500000
5 202 11-10-2010 200000
SQL> select * from barang;
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000 PCS ASUS P5B Plus Viste Edt Ip965
10013 Asus Striker Extreme 1003 3760000 PCS ASUS STRIKER EXTREME vVIDIA
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
20106 Seagate 80GB 470000 PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000 PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000 PCS SEAGATE 250GB SATA-II
20512 Seagate 500gb 1950000 PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
11 rows selected.
SQL> select * from barang where harga_jual in(1500000,2000000,970000);
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000 PCS ASUS P5B Plus Viste Edt Ip965
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
SQL> select nama_brg from barang where nama_brg like 's%';
no rows selected
SQL> edit
Wrote file afiedt.buf
1* select nama_brg from barang where nama_brg like 'S%'
SQL> /
NAMA_BRG
--------------------------------------------------
Seagate 80GB
Seagate 160GB
Seagate 250GB
Seagate 500gb
SQL> select nama_brg from barang like '_i%';
select nama_brg from barang like '_i%'
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> edit
Wrote file afiedt.buf
1* select nama_brg from barang where nama_brg like '_i%'
SQL> /
NAMA_BRG
--------------------------------------------------
Biostar TForce %P965
Gigabyte GA_P31S3L
Gigabyte GA_945PL_S3
SQL> select * from barang;
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000 PCS ASUS P5B Plus Viste Edt Ip965
10013 Asus Striker Extreme 1003 3760000 PCS ASUS STRIKER EXTREME vVIDIA
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
20106 Seagate 80GB 470000 PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000 PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000 PCS SEAGATE 250GB SATA-II
20512 Seagate 500gb 1950000 PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
11 rows selected.
SQL> select kode_brg, nama_brg
2 from barang
3 where nama_brg like '%\_%'escape'\;
ERROR:
ORA-01756: quoted string not properly terminated
SQL> edit
Wrote file afiedt.buf
1 select kode_brg, nama_brg
2 from barang
3* where nama_brg like '%\_%'escape''\
SQL> /
where nama_brg like '%\_%'escape''\
*
ERROR at line 3:
ORA-00911: invalid character
SQL> edit
Wrote file afiedt.buf
1 select kode_brg, nama_brg
2 from barang
3* where nama_brg like '%\_%'escape'\'
SQL> /
KODE_BRG NAMA_BRG
---------- --------------------------------------------------
10022 Gigabyte GA_P31S3L
10023 Gigabyte GA_945PL_S3
SQL> select * from barang;
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000 PCS ASUS P5B Plus Viste Edt Ip965
10013 Asus Striker Extreme 1003 3760000 PCS ASUS STRIKER EXTREME vVIDIA
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
20106 Seagate 80GB 470000 PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000 PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000 PCS SEAGATE 250GB SATA-II
20512 Seagate 500gb 1950000 PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
11 rows selected.
SQL> select nama_brg from barang where nama_brg like 'A%' and harga_jual >1000000;
NAMA_BRG
--------------------------------------------------
Abit AB9-Pro
ASUS P5B Plus Viste Edt
Asus Striker Extreme
SQL> edit
Wrote file afiedt.buf
1* select nama_brg,harga_jual from barang where nama_brg like 'A%' and harga_jual >1000000
SQL> /
NAMA_BRG HARGA_JUAL
-------------------------------------------------- ----------
Abit AB9-Pro 1500000
ASUS P5B Plus Viste Edt 2000000
Asus Striker Extreme 3760000
SQL> edit
Wrote file afiedt.buf
1 select nama_brg,harga_jual from barang
2* where nama_brg like 'A%' or harga_jual >1000000
SQL> /
NAMA_BRG HARGA_JUAL
-------------------------------------------------- ----------
Abit AB9-Pro 1500000
ASUS P5B Plus Viste Edt 2000000
Asus Striker Extreme 3760000
Seagate 500gb 1950000
Epson R-230 1300000
SQL> select * from barang where not (nama_barang like 'A%');
select * from barang where not (nama_barang like 'A%')
*
ERROR at line 1:
ORA-00904: "NAMA_BARANG": invalid identifier
SQL> edit
Wrote file afiedt.buf
1* select * from barang where not (nama_brg like 'A%')
SQL> /
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
20106 Seagate 80GB 470000 PCS SEAGATE 80GB 7200
20108 Seagate 160GB 540000 PCS SEAGATE 160GB SATA-II
20201 Seagate 250GB 700000 PCS SEAGATE 250GB SATA-II
20512 Seagate 500gb 1950000 PCS SEAGATE 500GB SATA-II
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
8 rows selected.
SQL> edit
Wrote file afiedt.buf
1* select * from barang where not (nama_brg like 'S%')
SQL> /
KODE_BRG NAMA_BRG IMAGE_ID HARGA_JUAL SATUAN KETERANGAN
---------- -------------------------------------------------- ---------- ---------- ------------------------- ------------------------------
10011 Abit AB9-Pro 1001 1500000 PCS ABIT AB9-PRO IP965
10012 ASUS P5B Plus Viste Edt 1002 2000000 PCS ASUS P5B Plus Viste Edt Ip965
10013 Asus Striker Extreme 1003 3760000 PCS ASUS STRIKER EXTREME vVIDIA
10021 Biostar TForce %P965 1011 970000 PCS BIOSTAR TFORCE P965
10022 Gigabyte GA_P31S3L 1012 1000000 PCS GIGABYTE GA-P31S3L
10023 Gigabyte GA_945PL_S3 1013 890000 PCS GIGABYTE GA-945PL-S3
30321 Epson R-230 1291 1300000 PCS EPSON PHOTO R-230
7 rows selected.
SQL> edit
Wrote file afiedt.buf
1* select kode_brg, nama_brg from barang where not (nama_brg like 'S%')
SQL> /
KODE_BRG NAMA_BRG
---------- --------------------------------------------------
10011 Abit AB9-Pro
10012 ASUS P5B Plus Viste Edt
10013 Asus Striker Extreme
10021 Biostar TForce %P965
10022 Gigabyte GA_P31S3L
10023 Gigabyte GA_945PL_S3
30321 Epson R-230
7 rows selected.
SQL> select nama_brg,harga_jual from barang where nama_brg like 'A%' and harga_jual >1000000 or nama_brg like 's%';
NAMA_BRG HARGA_JUAL
-------------------------------------------------- ----------
Abit AB9-Pro 1500000
ASUS P5B Plus Viste Edt 2000000
Asus Striker Extreme 3760000
SQL> edit
Wrote file afiedt.buf
1 select nama_brg,harga_jual from barang
2 where nama_brg like 'A%' and harga_jual >1000000
3* or nama_brg like 'S%'
SQL> /
NAMA_BRG HARGA_JUAL
-------------------------------------------------- ----------
Abit AB9-Pro 1500000
ASUS P5B Plus Viste Edt 2000000
Asus Striker Extreme 3760000
Seagate 80GB 470000
Seagate 160GB 540000
Seagate 250GB 700000
Seagate 500gb 1950000
7 rows selected.
SQL> select nama_brg, harga_jual from barang order by harga_jual asc;
NAMA_BRG HARGA_JUAL
-------------------------------------------------- ----------
Seagate 80GB 470000
Seagate 160GB 540000
Seagate 250GB 700000
Gigabyte GA_945PL_S3 890000
Biostar TForce %P965 970000
Gigabyte GA_P31S3L 1000000
Epson R-230 1300000
Abit AB9-Pro 1500000
Seagate 500gb 1950000
ASUS P5B Plus Viste Edt 2000000
Asus Striker Extreme 3760000
11 rows selected.
SQL> edit
Wrote file afiedt.buf
1* select nama_brg, harga_jual from barang order by harga_jual desc
SQL> /
NAMA_BRG HARGA_JUAL
-------------------------------------------------- ----------
Asus Striker Extreme 3760000
ASUS P5B Plus Viste Edt 2000000
Seagate 500gb 1950000
Abit AB9-Pro 1500000
Epson R-230 1300000
Gigabyte GA_P31S3L 1000000
Biostar TForce %P965 970000
Gigabyte GA_945PL_S3 890000
Seagate 250GB 700000
Seagate 160GB 540000
Seagate 80GB 470000
11 rows selected.
SQL> select nama_brg, harga_jual
2 , harga_jual * 0.01 as "Diskon",
3 harga_jual - (harga_jual * 0.01) as "Harga_Sekarang"
4 from barang
5 order by "Harga_Sekarang";
NAMA_BRG HARGA_JUAL Diskon Harga_Sekarang
-------------------------------------------------- ---------- ---------- --------------
Seagate 80GB 470000 4700 465300
Seagate 160GB 540000 5400 534600
Seagate 250GB 700000 7000 693000
Gigabyte GA_945PL_S3 890000 8900 881100
Biostar TForce %P965 970000 9700 960300
Gigabyte GA_P31S3L 1000000 10000 990000
Epson R-230 1300000 13000 1287000
Abit AB9-Pro 1500000 15000 1485000
Seagate 500gb 1950000 19500 1930500
ASUS P5B Plus Viste Edt 2000000 20000 1980000
Asus Striker Extreme 3760000 37600 3722400
11 rows selected.
SQL> select kode_brg,nama_brg,harga_jual
2 from barang
3 order by kode_brg,harga_brg desc;
order by kode_brg,harga_brg desc
*
ERROR at line 3:
ORA-00904: "HARGA_BRG": invalid identifier
SQL> edit
Wrote file afiedt.buf
1 select kode_brg,nama_brg,harga_jual
2 from barang
3* order by kode_brg,harga_jual desc
SQL> /
KODE_BRG NAMA_BRG HARGA_JUAL
---------- -------------------------------------------------- ----------
10011 Abit AB9-Pro 1500000
10012 ASUS P5B Plus Viste Edt 2000000
10013 Asus Striker Extreme 3760000
10021 Biostar TForce %P965 970000
10022 Gigabyte GA_P31S3L 1000000
10023 Gigabyte GA_945PL_S3 890000
20106 Seagate 80GB 470000
20108 Seagate 160GB 540000
20201 Seagate 250GB 700000
20512 Seagate 500gb 1950000
30321 Epson R-230 1300000
11 rows selected.
SQL> edit
Wrote file afiedt.buf
1 select kode_brg,nama_brg,harga_jual
2 from barang
3* order by nama_brg,harga_jual desc
SQL> /
KODE_BRG NAMA_BRG HARGA_JUAL
---------- -------------------------------------------------- ----------
10011 Abit AB9-Pro 1500000
10012 ASUS P5B Plus Viste Edt 2000000
10013 Asus Striker Extreme 3760000
10021 Biostar TForce %P965 970000
30321 Epson R-230 1300000
10023 Gigabyte GA_945PL_S3 890000
10022 Gigabyte GA_P31S3L 1000000
20108 Seagate 160GB 540000
20201 Seagate 250GB 700000
20512 Seagate 500gb 1950000
20106 Seagate 80GB 470000
11 rows selected.
SQL> select kode_brg, nama_brg
2 ,harga_jual,
3 satuan
4 from barang
5 order by 2 desc;
KODE_BRG NAMA_BRG HARGA_JUAL SATUAN
---------- -------------------------------------------------- ---------- -------------------------
20106 Seagate 80GB 470000 PCS
20512 Seagate 500gb 1950000 PCS
20201 Seagate 250GB 700000 PCS
20108 Seagate 160GB 540000 PCS
10022 Gigabyte GA_P31S3L 1000000 PCS
10023 Gigabyte GA_945PL_S3 890000 PCS
30321 Epson R-230 1300000 PCS
10021 Biostar TForce %P965 970000 PCS
No comments:
Post a Comment