Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ISMEROSOK(Nev, Telefon, eMail, SzDat, Kozeli)
- Pl.
- Kiss Janos 0725262829 kj@yahoo.com 1998-03-25 1
- Nagy Anna 0744454689 na@citromail.hu 1999-09-01 0
- drop table Ismerosok
- CREATE TABLE Ismerosok
- (
- Kulcs NUMBER(4) PRIMARY KEY,
- Nev VARCHAR2(50) NOT NULL,
- Telefon VARCHAR2(12),
- eMail VARCHAR2(50),
- SzDat DATE DEFAULT SYSDATE-18*365,
- Kozeli NUMBER(1) CHECK(Kozeli BETWEEN 0 AND 1),
- Uzenet Varchar2(50)
- )
- GRANT INSERT ON Ismerosok TO PUBLIC
- INSERT INTO RO_M0054_SQL01_S06.Ismerosok
- VALUES (1031, 'Gal Otto', '0754475884', 'gal.otto1000@gmail.com', '03/Feb/1998', 1, 'Ghelinca')
- SELECT * FROM Ismerosok`
- ALTER TABLE Ismerosok ADD Uzenet Varchar2(50) NOT NULL
- ALTER TABLE Ismerosok ADD Kulcs NUMBER(5) PRIMARY KEY
- UPDATE RO_M0054_SQL01_T01.Ismerosok
- SET Kulcs = 103
- WHERE Nev= 'Gal Otto'
- VALUES ('Gal Otto', '0754475884', 'gal.otto1000@gmail.com', '03/Feb/1998', 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement