Notes

a)CREATE USER engineer
IDENTIFIED BY beu2018;
b)GRANT CREATE SESSION, CREATE TABLE, CREATE INDEX
TO engineer;
c)GRANT UNLIMITED TABLESPACE
TO engineer;
d)GRANT SELECT, UPDATE, DELETE
ON employees
TO engineer;
====================================================


a)SELECT * FROM advisor
INNER JOIN student
ON advisor.advisor_id=student.advisor_id;

b)SELECT * FROM advisor
NATURAL JOIN student;
yadaki qisaltmaq ucun ashagidaki kimi yaza bilerik:
SELECT adv.advisor_id, sdv.s_id, sdv.s_name FROM advisor adv
INNER JOIN student sdv
ON adv.advisor_id=sdv.advisor_id;


c) SELECT * FROM advisor
LEFT OUTER JOIN student
ON advisor.advisor_id = student.advisor_id;

==============

SELECT * FROM advisor
RIGHT OUTER JOIN student
ON advisor.advisor_id = student.advisor_id;


SELECT * FROM advisor, student
WHERE advisor.advisor_id = student.advisor_id; // eQUI JOIN




==============================
3cu sual

a) CREATE VIEW my_view
AS
SELECT s_name
FROM student
WHERE s_name LIKE 'A%';

b)CREATE SYNONYM Telebe
FOR student;

c)CREATE SEQUENCE adv_no_seq
START WITH 100
INCREMENT BY 1;
=================================================================

YYYY 1996
MM 05
DD 27
===========
YEAR nineteen and ninety six
MONTH SEPTEMBER
DAY FRIDAY
==============
MON SEP
DY FRI