Silahkan masukkan instruksi SQL untuk:
- Mengcreate TABEL SalesPerson (DDL)
- Memasukkan Data pada Tabel SalesPerson (DML)
Untuk SalesPerson diisi dengan 3 record saja.
Silahkan tuliskan instruksinya di bawah sini melalui comment
Blogged with the Flock Browser
Tags: pieceof code
on 
CREATE TABLE SalesPerson (
KdSales VARCHAR2(5) NOT NULL,
NmSales CHAR(50) NOT NULL ,
AlamatSales CHAR(300),
TelpSales CHAR(30),
PRIMARY KEY (”KDSALES”)
)
Insert Into SalesPerson VALUES (’SP001′, ‘Merinda’, ‘Jl. Sumur bor’, ‘654654897′);
Insert Into SalesPerson VALUES (’SP002′, ‘Janet’, ‘Jl. pisang batu’, ‘4567894′);
Insert Into SalesPerson VALUES (’SP003′, ‘Barel’, ‘Jl. kemakmuran’, ‘146549872′);
create table MsSales (
IDSales varchar2(20) primary key,
NamaSales varchar2(20))
insert into MsSales values (‘S1′,’Sales1′);
insert into MsSales values (‘S2′,’Sales2′);
insert into MsSales values (‘S3′,’Sales3′);
insert into MsSales values (‘S4′,’Sales4′);
insert into MsSales values (‘S5′,’Sales5′);
insert into MsSales values (‘S6′,’Sales6′);
@ doraemon,
Coba dibaca lagi soalnya.. krn untuk sales person butuhnya cuma 3 record saja.
Cheers,
Johan Setiawan
1000835360 / 06PGT
[Oracle 10g]
–DDL–
create table MsSalesPerson (
KodeSalesPerson varchar2(10) NOT NULL,
NamaSalesPerson varchar2(50) NOT NULL,
AlamatSalesPerson varchar2(100) NOT NULL,
TelpSalesPerson varchar2(15) NOT NULL,
TanggalUpdate DATE
);
–DML–
INSERT INTO MsSalesPerson VALUES (‘SP001′, ‘Mike’, ‘Jl. Ayam No.1′, 0857123456780, SYSDATE);
INSERT INTO MsSalesPerson VALUES (‘SP002′, ‘Steven’, ‘Jl. Bebek No.2′, 0857123456781, SYSDATE);
INSERT INTO MsSalesPerson VALUES (‘SP003′, ‘Rusli’, ‘Jl. Sapi No.3′, 0857123456782, SYSDATE);
1000842252 / 06PGT
~ORACLE~
CREATE TABLE salesperson
(
KdSP CHAR(5),
NmSP VARCHAR(20),
CONSTRAINT sp_pk PRIMARY KEY(KdSP)
);
INSERT INTO salesperson VALUES (‘S0001′,’X');
INSERT INTO salesperson VALUES (‘S0002′,’Y');
INSERT INTO salesperson VALUES (‘S0003′,’Z');
Kelas: 06PGT
Nim : 1000837265
–Create Table–
CREATE TABLE MsSalesPerson(
KdSalesPerson varchar(20) primary key,
NamaSalesPerson varchar(30),
AlamatSalesPerson varchar(100),
TelpSalesPerson varchar(20)
);
–Input Data–
INSERT INTO MsSalesPerson(KdSalesPerson, NamaSalesPerson, AlamatSalesPerson, TelpSalesPerson) VALUES(’SP0001′,’Benny’,’Jl.Taman Palem blok B2 no 12′,’9648211′);
INSERT INTO MsSalesPerson(KdSalesPerson, NamaSalesPerson, AlamatSalesPerson, TelpSalesPerson) VALUES(’SP0002′,’Jessica’,’Jl.Kebon Jeruk Raya no 18′,’08150225789′);
INSERT INTO MsSalesPerson(KdSalesPerson, NamaSalesPerson, AlamatSalesPerson, TelpSalesPerson) VALUES(’SP0003′,’Raymond’,’Jl.Kebayoran Baru no 08′,’08188861190′);
CREATE TABLE SalesP
(
SalesPID int NOT NULL,
LastName varchar(50) NOT NULL,
FirstName varchar(50) NOT NULL,
Address varchar(50) NOT NULL,
City varchar(50) NOT NULL,
CONSTRAINT product_pk PRIMARY KEY (SalesPID)
)
CREATE SEQUENCE seq_salesP
MINVALUE 001
START WITH 001
INCREMENT BY 1
NOCACHE
INSERT ALL
INTO SalesP (SalesPID,FirstName,LastName,Address,City)
VALUES (‘SP’+seq_salesP.nextval,’Micky’,'Wil’,'Sandang Street’,'Jakarta’)
INTO SalesP (SalesPID,FirstName,LastName,Address,City)
VALUES (‘SP’+seq_salesP.nextval,’Dean’,'Wil’,'Muala Street’,'Jakarta’)
INTO SalesP (SalesPID,FirstName,LastName,Address,City)
VALUES (‘SP’+seq_salesP.nextval,’Ric’,'Wil’,'Taisir Street’,'Jakarta’)
06PGT
1000836306
CREATE TABLE SalesP
(
SalesPID int NOT NULL,
LastName varchar(50) NOT NULL,
FirstName varchar(50) NOT NULL,
Address varchar(50) NOT NULL,
City varchar(50) NOT NULL,
CONSTRAINT product_pk PRIMARY KEY (SalesPID)
)
CREATE SEQUENCE seq_salesP
MINVALUE 001
START WITH 001
INCREMENT BY 1
NOCACHE
INSERT ALL
INTO SalesP (SalesPID,FirstName,LastName,Address,City)
VALUES (‘SP’+seq_salesP.nextval,’Micky’,'Wil’,'Sandang Street’,'Jakarta’)
INTO SalesP (SalesPID,FirstName,LastName,Address,City)
VALUES (‘SP’+seq_salesP.nextval,’Dean’,'Wil’,'Muala Street’,'Jakarta’)
INTO SalesP (SalesPID,FirstName,LastName,Address,City)
VALUES (‘SP’+seq_salesP.nextval,’Ric’,'Wil’,'Taisir Street’,'Jakarta’)
Novia Novianty
1000835556 / 06PGT
CREATE TABLE MsSales
{
Kdsales VARCHAR(10) NOT NULL,
NamaSales VARHCHAR(25) NOT NULL,
AlamatSales VARCHAR(50) NOT NULL,
CONSTRAINT Mssalespk PRIMARY KEY (Kdsales)
};
INSERT INTO MsSales VALUES (‘S001′,’Noph’, ‘Jl. Hj Senin no 27′);
INSERT INTO MsSales VALUES (‘S002′,’Lyvia’, ‘Jl. Keluarga no 39′);
INSERT INTO MsSales VALUES (‘S003′,’Felix’, ‘Jl. U no 6′);
ORACLE
======
CREATE TABLE SalesPerson
{
SP_id VARCHAR(5) NOT NULL,
SP_name VARCHAR(50),
SP_address VARCHAR(100),
SP_phone VARCHAR(15),
CONSTRAINT SP_pk PRIMARY KEY (SP_id)
};
INSERT INTO SalesPerson values (‘SP001′, ‘Sisil’, ‘Jl. Bawah no 77 Bekasi’, ’08184532323′);
INSERT INTO SalesPerson values (‘SP002′, ‘Dian’, ‘Jl. Kiri no 18 Jakbar’, ’081723565623′);
INSERT INTO SalesPerson values (‘SP003′, ‘Hendri’, ‘Jl. Kanan no 1 Jakbar’, ’02173868788′);
Nama : Mario
NIM : 1000836136
Kelas: 06PGT
msSales
=========
create table msSales
(
kdSales char(5) primary key,
namaSales varchar(20)
);
insert into msSales values(‘S001′,’Novi’);
insert into msSales values(‘S002′,’Dessy’);
insert into msSales values(‘S003′,’Januar’);
Marlene (1000867860)
06PGT
1000858370/I Putu Ananta Yogiswara/06PGT
CREATE TABLE salesperson(
KODE_SALES CHAR(5),
NAMA_SALES VARCHAR2(30),
ALAMAT_SALES VARCHAR2(30),
TELEPON_SALES VARCHAR2(20),
);
SQL> INSERT INTO salesperson VALUES(‘SP001′,’Putu Ananta’,'Jl ANGGREK RAYA NO:78′,’0815-14537896′);
SQL> INSERT INTO salesperson VALUES(‘SP002′,’Putu Aggi’,'Jl GALAXY NO:21′,’0813-9871234′);
SQL> INSERT INTO salesperson VALUES(‘SP003′,’Ayssid’,'Jl ETNIEZ NO:45′,’0816-98712313′);
Nim : 1000868075
Kelas : 06PGT
———- untuk mengcreate table ———-
CREATE TABLE MasterSales
(
KodeSales varchar(10)primary key,
NamaSales varchar(30),
AlamatSalesvarchar(30),
TeleponSales varchar(15)
);
———- untuk insert ———-
INSERT INTO MasterSales(KodeSales, NamaSales, AlamatSales, TeleponSales) VALUES(’S001′,’Bejo’,’Jl. Deso no 45’,’7634562343′);
INSERT INTO MasterSales(KodeSales, NamaSales, AlamatSales, TeleponSales) VALUES(’S002′,’Paijo’,’Jl. Kesemek no 123’,’2453614527′);
INSERT INTO MasterSales(KodeSales, NamaSales, AlamatSales, TeleponSales) VALUES(’S003′,’Sarimin’,’Jl. unimin no 90’,’6765498712′);
1000842624/06PGT
CREATE TABLE salesperson
(
KdSales CHAR(5) PRIMARY KEY,
NamaSales VARCHAR(20),
Alamat varchar(50)
);
INSERT INTO salesperson VALUES (’S001′,’a’,'xxx’);
INSERT INTO salesperson VALUES (’S002′,’b’,'xxx’);
INSERT INTO salesperson VALUES (’S003′,’c’,'xxx’);
CREATE TABLE MsSalesPerson (
SalesPersonNo VARCHAR2(5) NOT NULL,
SalesPersonName VARCHAR2(30) NOT NULL,
SalesPersonAddress VARCHAR2(50) NOT NULL,
Phone VARCHAR2(10) NOT NULL,
Email VARCHAR2(20) NOT NULL,
PRIMARY KEY(SalesPersonNo)
);
INSERT INTO MsProduct VALUES (‘P001′,’Cup 240 ml’,'Cup’,12000);
INSERT INTO MsProduct VALUES (‘P002′,’Botol 600 ml’,'Botol’,19000);
INSERT INTO MsProduct VALUES (‘P003′,’Botol 1500 ml’,'Botol’,19500);
INSERT INTO MsProduct VALUES (‘P004′,’Galon 19 l’,'Galon’,6000);
.. 1000878883 ..
create table SalesPerson (
idSP varchar(10) primary key
nameSP varchar(30),
addrSP varchar(50)
)
Insert all
Into SalesPerson (idSP,nameSP,addrSP) Values (SP0001,’Chad Michael Murray’,’Jl.Kemanggisan Barat No.2’)
Into SalesPerson (idSP,nameSP,addrSP) Values (SP0002,’Bethany Joy Lenz’,’Jl.Mahoni No.18 Ciputat’)
Into SalesPerson (idSP,nameSP,addrSP) Values (SP0003,’Hillary Burton’,’Jl.Tangerang Raya No.202’);
–Mengcreate TABEL SalesPerson (DDL)–
CREATE TABLE MsSalesPerson(
KodeSales varchar(5) primary key,
NamaSales varchar(30),
AlamatSales varchar(50)
);
–Memasukkan Data pada Tabel SalesPerson (DML)–
INSERT INTO MsSalesPerson VALUES (’S001′,’Clara’, ‘Jl. Manggis No.5′);
INSERT INTO MsSalesPerson VALUES (’S002′,’Bagus’, ‘Jl. Cipinang Lontar No.18′);
INSERT INTO MsSalesPerson VALUES (’S003′,’Suyanti’, ‘Jl. Green Garden No.12′);
NIM : 1000842290
Kelas : 06PGT
CREATE TABLE MsSalesPerson
(
KodeSalesPerson CHAR(5),
NamaSalesPerson VARCHAR2(30),
AlamatSalesPerson VARCHAR2(30),
TelpSalesPerson VARCHAR2(20),
CONSTRAINT salesperson_pk PRIMARY KEY(KodeSalesPerson)
);
INSERT INTO MsSalesPerson VALUES(‘SP001′,’Kurniawan’,'Jl. Binus No.11′,’021-6553456′);
INSERT INTO MsSalesPerson VALUES(‘SP002′,’Luci’,'Jl. Binus No.12′,’021-8956412′);
INSERT INTO MsSalesPerson VALUES(‘SP003′,’Mario Tegus’,'Jl. Binus No.13′,’021-9863451′);
NIM : 1000877211
NAMA : Mely
create table MsSalesPerson
(
kdsalesperson varchar2(5) not null primary key,
namasalesperson varchar2(100),
alamatsalesperson varchar2(100),
telpsalesperson varchar2(12)
);
insert into mssalesperson values (‘S001′,’A1′,’jl. kebon jeruk1′,’081912341111′);
insert into mssalesperson values (‘S002′,’A2′,’jl. kebon jeruk2′,’081912342222′);
insert into mssalesperson values (‘S003′,’A3′,’jl. kebon jeruk3′,’081912343333′);
insert into mssalesperson values (‘S004′,’A4′,’jl. kebon jeruk4′,’081912344444′);
Wunleng Prawijogo
1000839283 (06PGT)
Oracle
–Create Table–
CREATE TABLE MsSalesPerson
{
KdSales varchar(6) NOT NULL,
NamaSales varchar(30) NOT NULL,
Alamat varchar(100) NOT NULL,
NoTlp varchar(20),
CONSTRAINT mssalespk PRIMARY KEY (KdSales)
};
–Insert Datanya–
INSERT INTO MsSalesPerson VALUES (‘SP001′,’Wunleng’, ‘Jl. Hos Cokroaminoto no. 66′,’021-1111111′ );
INSERT INTO MsSalesPerson VALUES (‘SP002′,’Prawi Jogo’, ‘Jl. Kuburan no. 666′,’021-2222222′);
INSERT INTO MsSalesPerson VALUES (‘SP003′,’Leng Wun’, ‘Jl. Lari Pagi no. 101′,’021-2222222′);
create table SalesPerson
(
KdSalesPerson varchar2(10) Primary Key,
NamaSalesPerson varchar2(50),
AlamatSalesPerson varchar2(50),
TelpSalesPerson varchar2(50),
EmailSalesPerson varchar2(50) UNIQUE
);
insert into SalesPerson values (‘SP0001′,’Pavel’,’Jl. Buntu No. 8′,’08175551585′,’pavelnedved@yahoo.com’);
insert into SalesPerson values (‘SP0002′,’Gariel’,’Jl. Raya No. 6′,’08575558833′,’batigol@yahoo.com’);
insert into SalesPerson values (‘SP0003′,’Bambang’,’Jl. Tikus No. 55′,’08174465432′,’bampamung@yahoo.com’);
Julianto / 1000865262 / 06PGT
create table salesPerson
(
idSalesPerson varchar2(10) PRIMARY KEY,
nama varchar2(50),
alamat varchar2(50),
telp varchar2(50),
umur numeric,
email varchar2(50) UNIQUE
);
insert into salesPerson values(‘SP001′,’Supandy’,’Jl. Ahmad Yani No.8′,’08192345674′,24,’supandy@yahoo.com’);
insert into salesPerson values(‘SP002′,’Nicolas’,’Jl. Keluarga No.38′,’08194241095′,27,’nicolas@yahoo.com’);
insert into salesPerson values(‘SP003′,’Sudarman’,’Jl. Rusa No.68′,’08194345234′,26,’sudarman@yahoo.com’);
CREATE TABLE salesperson
(
KdSP CHAR(5),
NmSP VARCHAR(20),
CONSTRAINT sp_pk PRIMARY KEY(KdSP)
);
INSERT INTO salesperson VALUES (‘S0001′,’Silvia’);
INSERT INTO salesperson VALUES (‘S0002′,’Fransiska’);
INSERT INTO salesperson VALUES (‘S0003′,’Natalia’);
Nama : Rhio
NIM : 1000867942
kelas : 06PGT
Maap Pak, tadi saya lupa kasih tanda pengenal Pak… Jadi posting lagi degh… Hehe… ^_^
1000863824 / 06PGT
CREATE TABLE MsSalesPerson
(
KdSalesPerson VARCHAR2(5)
CONSTRAINT c_Sales_KdSalesPerson_nn NOT NULL
CONSTRAINT c_Sales_KdSalesPerson_pk PRIMARY KEY,
NamaSalesPerson VARCHAR2(20)
CONSTRAINT c_Sales_NamaSalesPerson_nn NOT NULL,
Alamat VARCHAR2(50)
CONSTRAINT c_Sales_Alamat_nn NOT NULL,
Telp VARCHAR2(12)
CONSTRAINT c_Sales_Telp_nn NOT NULL
)
INSERT INTO MsSalesPerson VALUES (‘S001’,’Andi’,’Jl.Haji Senin’,’0211211212’)
INSERT INTO MsSalesPerson VALUES (‘S002’,’Rudi’,’Jl.Haji Selasa’,’081888285695’)
INSERT INTO MsSalesPerson VALUES (‘S003’,’Kiki’,’Jl.Haji Rabu’,’085608115211’)
CREATE TABLE MsSalesPerson(
KodeSales CHAR (5) PRIMARY KEY,
NamaSales VARCHAR (30) NOT NULL,
AlamatSales VARCHAR (100) NOT NULL,
TelpSales VARCHAR(20) NOT NULL
);
INSERT INTO MsSalesPerson VALUES (‘SP001′, ‘Heri’, ‘Jln.Kedamaian’,’021-000111′);
INSERT INTO MsSalesPerson VALUES (‘SP001′, ‘Lucy’, ‘Jln.Ketentraman’,’021-222111′);
INSERT INTO MsSalesPerson VALUES (‘SP001′, ‘Asrie’, ‘Jln.Kemakmuran’,’021-000333′);
1000843015
06 PGT
DDL
Create table MsSales
(
KdSales char(5) primary key,
NamaSales varchar(25) not null
);
DML
insert into MsSales values (‘SL001′,’Luna’);
insert into MsSales values (‘SL002′,’Lina’);
insert into MsSales values (‘SL003′,’Lion’);
Erico 1000835650
06PGT
3
—-
CREATE TABLE MsSalesPerson
(
kodeSP VARCHAR2(6) PRIMARY KEY,
namaSP VARCHAR2(20)
);
INSERT INTO MsSalesPerson VALUES(‘SP0001′, ‘Mr. X’);
INSERT INTO MsSalesPerson VALUES(‘SP0002′, ‘Mr. Y’);
INSERT INTO MsSalesPerson VALUES(‘SP0003′, ‘Mr. Z’);
NIM : 1000837284
Nama : Ivan
Kelas: 06PGT
create table msSales
(
kdSales char(5) primary key not null,
namaSales varchar(50) not null,
alamatSales varchar(50)
);
insert into msSales values(‘sp001′,’SP1′,’Jln. A’);
insert into msSales values(‘sp002′,’SP2′,’Jln. B’);
insert into msSales values(‘sp003′,’SP3′,’Jln. C’);
Denni Efendi
06PGT
1000835751
CREATE TABLE MsSalesPerson
(
KdSales VARCHAR2(10) NOT NULL,
NamaSales VARCHAR2(50) NOT NULL,
Alamat VARCHAR2(100) NOT NULL,
Telp NUMBER,
Primary key(idKaryawan)
);
insert into MsSalesPerson values(‘SP001′,’Frans’,'Jl. Kenari 4′,’08163216541′);
insert into MsSalesPerson values(‘SP002′,’Kurdi’,'Jl. Bahagia 1′,’0818654321′);
insert into MsSalesPerson values(‘SP003′,’Tono’,'Jl. Surgawi 2′,’0888899654′);
erfan melanaga : (1000873503)
kelas : 06PGT
create table Sperson
(
idSperson varchar2(10) PRIMARY KEY,
nm varchar2(50),
alamat varchar2(50),
telp varchar2(50),
umur numeric,
email varchar2(50) UNIQUE
);
insert into Sperson values(‘SP001′,’susi’,’Jl. Binus1 No.8′,’08568925957′,24,’susi@yahoo.com’);
insert into Sperson values(‘SP002′,’susu’,’Jl. Binus2 No.38′,’08568925957′,27,’susu@yahoo.com’);
insert into Sperson values(‘SP003′,’Sudu’,’Jl. Binus3 No.68′,’08568925957′,26,’sudu@yahoo.com’);
NIM:1000847101 / 06 PGT
CREATE TABLE sales
(
KodeSales char(5) primary key,
NamaSales varchar(20),
AlamatSales varchar(30)
);
insert into sales VALUES (‘S0001′,’Budi’,'Jalan A NO 1′);
insert into sales VALUES (’S0002′,’Deni’,’Jalan B NO 7′);
insert into sales VALUES (’S0003′,’Nani’,’Jalan C NO 3′);
1000864543/06PGT
CREATE TABLE msSalesPerson (
KdSales VARCHAR2(5) NOT NULL,
Nama CHAR(30) NOT NULL ,
Alamat CHAR(40),
Telp CHAR(15),
PRIMARY KEY (”KdSales”)
)
Insert Into msSalesPerson VALUES (’S0001′, ‘ling’, ‘Jl. panjang’, ‘123456′);
Insert Into msSalesPerson VALUES (’S0002′, ‘wei’, ‘Jl. pendek’, ‘456789′);
Insert Into msSalesPerson VALUES (’S0003′, ‘chan’, ‘Jl. ada aja’, ‘146542′);
CREATE TABLE MsSalesPerson
(
KodeSalesPerson VARCHAR2(6) PRIMARY KEY NOT NULL,
NamaSalesPerson VARCHAR2(20),
AlamatSalesPerson VARCHAR2(50)
);
INSERT INTO MsSalesPerson VALUES(’SP0001′,‘Kaka’,‘Jl. Thamrin’);
INSERT INTO MsSalesPerson VALUES(’SP0002′,‘Lilo,‘Jl. Sudirman’);
INSERT INTO MsSalesPerson VALUES(’SP0003′,‘Mimi’,‘Jl. H.R. Rasuna Said’);
CREATE TABLE SalesPerson (
KdSP VARCHAR2(5) PRIMARY KEY,
NamaSP CHAR(50) NOT NULL ,
AlamatSP CHAR(100),
TelpSP CHAR(20),
)
Insert Into SalesPerson VALUES (’SP001′, ‘Budi’, ‘Jl Manggis no 1’, ‘089928381748′);
Insert Into SalesPerson VALUES (’SP002′, ‘Kelly’, ‘Jl Laksa no 46’, ‘0819267326472′);
Insert Into SalesPerson VALUES (’SP003′, ‘Mike’, ‘Jl Sinar no 26’, ‘99876543′);
Yusup Martinus Freddi/ 100848073/ 06PGT
CREATE TABLE MsSalePerson
(
KdSales CHAR(20) NOT NULL,
NamaSales VARCHAR(50) NOT NULL,
AlamatSales VARCHAR(100) NOT NULL,
NoTelpSales CHAR(25),
PRIMARY KEY (KdSales)
);
INSERT INTO MsSalesPerson VALUES(‘MP001′,’Michael’,'Jl. Sudirman no 4′,’0219482435′);
INSERT INTO MsSalesPerson VALUES(‘MP002′,’Vina’,'Jl. Harmony no 2′,’0212135632′);
INSERT INTO MsSalesPerson VALUES(‘MP003′,’Samy’,'Jl. Batusari no 45′,’0213424664′);
Sales
create table Sales
(
SalesID char(7) primary key not null,
SalesName varchar(30) not null,
SalesSex varchar(10) not null,
SalesDesc varchar(50)
)
insert into sales values (‘SL001′, ‘Deni’, ‘Male’, ‘Salesnya oke’);
insert into sales values (‘SL002′, ‘Doni’, ‘Male’, ‘Salesnya kurang oke’);
insert into sales values (‘SL003′, ‘Eryanti’, ‘Female’, ‘Salesnya cantik’);
CREATE TABLE MsSalesPerson(
KdSales CHAR(6) PRIMARY KEY,
NamaSales VARCHAR(25) NOT NULL,
TelpSales VARCHAR(15) NOT NULL,
EmailSales VARCHAR(30) NOT NULL,
AlamatSales VARCHAR(100) NOT NULL,
);
INSERT INTO MsSalesPerson VALUES (’SPN001′, ‘Rina’, ‘021-94556788’,’rina@gmail.com′, ‘jln.pegangsaan timur raya no.21′);
INSERT INTO MsSalesPerson VALUES (’SPN002′, ‘Rini’, ‘0838-99887766’,’rini@gmail.com’, ‘jln.pegangsaan timur raya no.22′ );
INSERT INTO MsSalesPerson VALUES (’SPN003′, ‘Rani’, ‘0811-345678’,’rani@gmail.com′, ‘jln.pegangsaan timur raya no.23′ );
1000879583 / 06PGT
CREATE TABLE MsSalesPerson (
KdsalesPerson VARCHAR(5) NOT NULL PRIMARY KEY,
NamaSalesPerson VARHCHAR(20),
AlamatSalesPerson VARCHAR(100),
TelpSalesPerson VARCHAR(15),
);
INSERT INTO MsSalesPerson VALUES (’S001′,’AAA’, ‘Jl. Kemanggisan no. 1′,021546234);
INSERT INTO MsSalesPerson VALUES (’S002′,’BBB’, ‘Jl. Kemanggisan no. 2′,021589745);
INSERT INTO MsSalesPerson VALUES (’S003′,’CCC’, ‘Jl. Kemanggisan no. 3′,021669874);
CREATE TABLE MsSalesPerson(
KodeSales CHAR (5) PRIMARY KEY,
NamaSales VARCHAR (30) NOT NULL,
AlamatSales VARCHAR (100) NOT NULL,
TelpSales VARCHAR(20) NOT NULL
);
INSERT INTO MsSalesPerson VALUES (‘SP001′, ‘Heri’, ‘Jln.Kedamaian’,’021-000111′);
INSERT INTO MsSalesPerson VALUES (‘SP002′, ‘Lucy’, ‘Jln.Ketentraman’,’021-222111′);
INSERT INTO MsSalesPerson VALUES (‘SP003′, ‘Asrie’, ‘Jln.Kemakmuran’,’021-000333′);
Maaf Pak, ada sedikit kesalahan pengisian kode di code sql sebelumnya
Heriyanto
1000836262
06PGT
Oracle
CREATE TABLE MsSalesPerson(
KodeSales CHAR(5) PRIMARY KEY,
NamaSales VARCHAR(30) NOT NULL,
AlamatSales VARCHAR(100) NOT NULL,
TeleponSales VARCHAR(20) NOT NULL
);
INSERT INTO MsSalesPerson VALUES (‘SP001′, ‘Jay’, ‘Jln Merdeka’,’08121231234′);
INSERT INTO MsSalesPerson VALUES (‘SP002′, ‘JJ’, ‘Jln Orchard’,’08561231234′);
INSERT INTO MsSalesPerson VALUES (‘SP003′, ‘Lun’, ‘Jln Mana’,’08181231234′);
NIM : 1000854946
06PGT
CREATE TABLE MsSalesPerson (
KodeSalesPerson VARCHAR2(5)
CONSTRAINT kdsp_pk PRIMARY KEY,
NamaSP VARCHAR2(25)
CONSTRAINT nama_sp_nn NOT NULL,
AlamatSP VARCHAR2(50)
CONSTRAINT alamat_sp_nn NOT NULL,
TelpSP VARCHAR2(12)
CONSTRAINT telp_sp_nn NOT NULL
);
INSERT INTO MsSalesPerson VALUES (‘SP001′,’Siapi’,'Jl.semen’,’021549871′);
INSERT INTO MsSalesPerson VALUES (‘SP002′,’Sibulan’,'Jl.Batu Bata’,’081933411229′);
INSERT INTO MsSalesPerson VALUES (‘SP003′,’Sicherry’,'Jl.CD-RW’,’021443322′);
1000860652
06PGT
CREATE TABLE MsSalesPerson (
KdSales CHAR(5) PRIMARY KEY,
NamaSales VARCHAR(50) NOT NULL,
AlamatSales VARCHAR(100) NOT NULL,
TelpSales VARCHAR(15) NOT NULL
);
INSERT INTO MsSalesPerson VALUES (’SP001′, ‘Jack’, ‘Jl. Barat no 1’, ‘3728940574′);
INSERT INTO MsSalesPerson VALUES (’SP002′, ‘Owen’, ‘Jl. Timur no 2’, ‘1039487503′);
INSERT INTO MsSalesPerson VALUES (’SP003′, ‘Freya’, ‘Jl. Selatan no 3’, ‘2930458739′);
CREATE TABLE MsSalesPerson (
SalesPersonId VARCHAR2(5) NOT NULL,
SalesPersonName VARCHAR2(25) NOT NULL,
SalesPersonAddress VARCHAR2(60) NOT NULL,
Phone VARCHAR2(15) NOT NULL,
Email VARCHAR2(25) NOT NULL,
PRIMARY KEY(SalesPersonId)
);
INSERT INTO MsProduct VALUES (’P001′,’Cup 240 ml’,’Cup’,12000);
INSERT INTO MsProduct VALUES (’P002′,’Botol 600 ml’,’Botol’,19000);
INSERT INTO MsProduct VALUES (’P003′,’Botol 1500 ml’,’Botol’,19500);
INSERT INTO MsProduct VALUES (’P004′,’Galon 19 l’,’Galon’,6000);
CREATE TABLE MsSalesPerson (
SalesPersonId VARCHAR2(5) NOT NULL,
SalesPersonName VARCHAR2(25) NOT NULL,
SalesPersonAddress VARCHAR2(60) NOT NULL,
Phone VARCHAR2(15) NOT NULL,
Email VARCHAR2(25) NOT NULL,
PRIMARY KEY(SalesPersonId)
);
INSERT INTO MsProduct VALUES (’P001′,’Cup 240 ml’,’Cup’,Rp.12000,00);
INSERT INTO MsProduct VALUES (’P002′,’Botol 600 ml’,’Botol’,Rp.19000,00);
INSERT INTO MsProduct VALUES (’P003′,’Botol 1500 ml’,’Botol’,Rp.19500,00);
INSERT INTO MsProduct VALUES (’P004′,’Galon 19 l’,’Galon’,Rp.6000,00);
Susanti
1000861503
06PGT
CREATE TABLE MsSales
(
KodeSales CHAR(5) PRIMARY KEY,
NamaSales VARCHAR(50),
AlamatSales VARCHAR(50),
TelpSales VARCHAR(20),
)
INSERT INTO MsSales (‘S0512′,’Anna’,'Jl.K.H Syahdan no.39E’,’08176577876′);
INSERT INTO MsSales (‘S0514′,’Benna’,'Jl.Kebon Jeruk Raya no.23′,’08150225342′);
INSERT INTO MsSales (‘S0515′,’Andi’,'Jl.Kemayoran Lama no.49A’,’081723940′);
1000835764
06PGT
maap pak yang 2 diatas saah post pak.. salah insertnya..
maap yach pak ampe posting 3x.. ^^
CREATE TABLE MsSalesPerson (
SalesPersonId VARCHAR2(5) NOT NULL,
SalesPersonName VARCHAR2(25) NOT NULL,
SalesPersonAddress VARCHAR2(60) NOT NULL,
Phone VARCHAR2(15) NOT NULL,
Email VARCHAR2(25) NOT NULL,
PRIMARY KEY(SalesPersonId)
);
INSERT INTO MsSalesPerson VALUES (’SP001, ‘A’, ‘Jln A’,’0811xxxxxxx,’a@a.com’);
INSERT INTO MsSalesPerson VALUES (’SP002, ‘B’, ‘Jln B’,’0812xxxxxxx,’b@b.com’);
INSERT INTO MsSalesPerson VALUES (’SP003, ‘C’, ‘Jln C’,’0813xxxxxxx,’c@c.com’);
Beny
1000867734
06PGT
- Mengcreate TABEL SalesPerson (DDL)
create table MsSales
(
KodeSales char(5) primary key not null,
NamaSales varchar(25),
AlamatSales varchar(40)
);
- Memasukkan Data pada Tabel SalesPerson (DML)
insert into MsSales values(’s0001′,’Ultimecia′,’Jl. Pejaten Mas’);
insert into MsSales values(’s0002′,Necron′,’Jl. Pertanian’);
insert into MsSales values(’s0003′,’Kuja′,’Jl. Thamrin’);
/* Andreyus – 1000839560 (06PGT) */
create table SalesPerson
(
KodeSalesPerson varchar2(10) primary key,
NamaSalesPerson varchar2(30),
AlamatSalesPerson varchar2(50),
TelpSalesPerson varchar2(30),
EmailSalesPerson varchar2(30)
);
insert into SalesPerson values(‘SP001′,’Diana Hirdes’,'Jl. Jembatan Lima no.93′,’22456789′,’hirdesabc@yahoo.com’);
insert into SalesPerson values(‘SP002′,’Nico Sulistyo’,'Jl. Van Lith no.23′,’55674567′,’vanvan@hotmail.com’);
insert into SalesPerson values(‘SP003′,’Welvin Iguna’,'Jl. Pademangan no.88′,’76543456′,’welviniguna@gmail.com’);
create table Sales
(
SalesID char(5) primary key not null,
SalesName varchar(30) not null,
SalesSex varchar(10) not null,
SalesDesc varchar(50)
);
INSERT INTO Sales VALUES (‘SL001′, ‘Hendra’, ‘Male’, ‘Sales OK’);
INSERT INTO Sales VALUES (‘SL002′, ‘Eryanti’, ‘Female’, ‘Sales cantik’);
INSERT INTO Sales VALUES (‘SL003′, ‘Limbad’, ‘Male’, ‘Sales kurang OK’);