-
Notifications
You must be signed in to change notification settings - Fork 0
/
hw_14.sql
103 lines (79 loc) · 2.13 KB
/
hw_14.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
/* ---------- TASK 1 ---------- */
CREATE TABLE test200 (
id INTEGER,
name1 VARCHAR2(25),
name2 VARCHAR2(25),
address1 VARCHAR2(25),
address2 VARCHAR2(25)
);
SELECT * FROM test200;
/* ---------- TASK 2 ---------- */
UPDATE test200 SET &col = &val WHERE id = &id_val;
SET VERIFY OFF;
SET VERIFY ON;
/* ---------- TASK 3 ---------- */
SELECT * FROM test200
WHERE name1 = '&&val1' AND name2 = '&val1'
AND address1 = '&&val2' AND address2 = '&val2';
/* ---------- TASK 4 ---------- */
UNDEFINE val1;
UNDEFINE val2;
DEFINE;
/* -------------------------------------------------------------------------- */
SELECT first_name, last_name, salary
FROM employees
WHERE employee_id = 130;
SELECT first_name, last_name, salary
FROM employees
WHERE employee_id = &ID;
SELECT first_name, last_name, salary
FROM employees
WHERE employee_id = &abc;
SELECT first_name, last_name, salary
FROM employees
WHERE first_name = &name;
SELECT first_name, last_name, salary
FROM employees
WHERE first_name = '&name';
SELECT first_name, last_name, salary
FROM employees
WHERE first_name = '&name'
AND salary > &sal;
SELECT first_name, last_name, salary
FROM employees
WHERE first_name LIKE '%&bukva%'
AND last_name LIKE '%&bukva%';
SELECT first_name, last_name, salary
FROM employees
WHERE first_name LIKE '%&&bukva%'
AND last_name LIKE '%&bukva%';
SELECT first_name, last_name, salary
FROM employees
WHERE first_name LIKE '%&&bukva2%'
AND last_name LIKE '%&bukva2%';
SELECT first_name, last_name, &col FROM employees;
SELECT first_name, last_name, &col1 FROM employees
ORDER BY &col2;
SELECT first_name, last_name, &&col FROM employees
ORDER BY &col;
SELECT &prodoljenie;
SELECT &select_list
FROM &table_name
WHERE &conditions
ORDER BY &col;
SELECT &select_list
FROM &table_name
WHERE &conditions
ORDER BY &col5;
SELECT * FROM students;
UPDATE students SET &col3 = &value WHERE &condition;
SELECT first_name, last_name, salary
FROM employees
WHERE first_name LIKE '%&&bukva%'
AND last_name LIKE '%&bukva%';
UNDEFINE bukva;
DEFINE;
DEFINE bukva = a;
SET DEFINE OFF;
SET DEFINE ON;
/* -------------------------------------------------------------------------- */