If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
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
CREATE TABLE SalesPerson {
KdSales VARCHAR(5) PRIMARY KEY,
NameSales CHAR(50) NOT NULL ,
AddSales CHAR(60)NOT NULL,
PhoneSales CHAR(20) NOT NULL,
};
Insert Into SalesPerson VALUES (’SP001′, ‘Steve’, ‘Jl Udara no 3’, ‘089924444048′);
Insert Into SalesPerson VALUES (’SP002′, ‘Samuel’, ‘Jl Kopi no 40’, ‘0818267323244′);
Insert Into SalesPerson VALUES (’SP003′, ‘Tenny’, ‘Jl Sinar no 26’, ‘99846500′);
F.Melissa Luis
1000843154
06PBT
CREATE TABLE MsSalesPerson (
KdSales VARCHAR(5)PRIMARY KEY,
NamaSales VARCHAR (25) NOT NULL,
Telp VARCHAR (12) NOT NULL,
Email VARCHAR (25)
);
INSERT INTO MsCustomer VALUES (‘S0001′,’Sally’,'08988789456′,’sally@mail.com’);
INSERT INTO MsCustomer VALUES (‘S0002′,’Lorenzo’,'081319878455′,’lorenzo@mail.com’);
INSERT INTO MsCustomer VALUES (‘S0003′,’Proney’,'08785456987′,’proney@mail.com’);
Desy Ayu Puspita /06PGT/1000885200
CREATE TABLE MsSalesPerson (
KdsalesPerson VARCHAR(5) NOT NULL PRIMARY KEY,
NamaSalesPerson VARHCHAR(30),
AlamatSalesPerson VARCHAR(100),
TelpSalesPerson VARCHAR(12),
);
INSERT INTO MsSalesPerson VALUES (’S001′,’Abi’, ‘Jl. Anggur no. 1′,0215308211);
INSERT INTO MsSalesPerson VALUES (’S002′,’Abu’, ‘Jl. Jeruk no. 2′,0215432166);
INSERT INTO MsSalesPerson VALUES (’S003′,’Aki’, ‘Jl. Mangga no. 3′,021654344);
CREATE TABLE SalesPerson (
KdSales VARCHAR2(5) NOT NULL,
NmSales VARCHAR(50) NOT NULL ,
AlamatSales VARCHAR(200),
TelpSales INT(30),
PRIMARY KEY (”KdSales”)
)
Insert Into SalesPerson VALUES (’KSP001′, ‘Pieter’, ‘Jl. jalan01’, ‘654633397′);
Insert Into SalesPerson VALUES (’KSP002′, ‘Ganteng’, ‘Jl. jalan02’, ‘4222894′);
Insert Into SalesPerson VALUES (’KSP003′, ‘Lho’, ‘Jl. jalan02’, ‘14123472′);
Kelompok SQL 06PBT
CREATE TABLE Sales
{
Kdsales VARCHAR(5) NOT NULL,
NamaSales VARHCHAR(25) NOT NULL,
AlamatSales VARCHAR(50) NOT NULL,
PRIMARY KEY (Kdsales)
constraint Sales check (len(KdBoneka) = 5),
constraint Sales2 check (KdBoneka like ‘KS[0-9][0-9][0-9]‘)
};
INSERT INTO MsSales VALUES (’KS001′,’Awan’, ‘Jl. Syadan no 5′);
INSERT INTO MsSales VALUES (’KS002′,’Deki’, ‘Jl. Angrek no 5′);
INSERT INTO MsSales VALUES (’KS003′,’Peter’, ‘Jl. U no 5′);
DESY AYU P /1000885200/06PGT
create table SalesPerson (
KdSalesPerson varchar(8) primary key,
NamaSalesPerson varchar(30),
AlamatSalesPerson varchar(50)
)
INSERT INTO SalesPerson (KdSalesPerson,NamaSalesPerson,AlamatSalesPerson) VALUES (SP0001,’Hardi’ ,’Tomang’)
INSERT INTO SalesPerson (KdSalesPerson,NamaSalesPerson,AlamatSalesPerson)) VALUES (SP0002,’Sri’,’Pondok Gede’)
INSERT INTO SalesPerson (KdSalesPerson,NamaSalesPerson,AlamatSalesPerson)) VALUES (SP0003,’Nur’,’Cilandak’);