CREATE TABLE _Student(
ID NUMBER PRIMARY KEY,
Familiya VARCHAR2(100),
Imya VARCHAR2(100),
OtchestvоVARCHAR2(100),
Data_rojdeniya DATE,
Mesto_rojdeniya VARCHAR2(200),
Nazvanie_univ VARCHAR2(100),
Gruppa VARCHAR2(20));
INSERT INTO _Student VALUES(1, 'Алиев', 'Одил', 'Олимович', '10.11.1997', 'город Ташкент', 'ТУИТ', '219-16');
Select * From _Student;
DELETE From_Student WHERE id=3;
UPDATE _Student SET IMYA='Азизжон' WHERE IMYA='Одил';
ALTER TABLE _Student ADD STIPEND VARCHAR2(20);
Do'stlaringiz bilan baham: |