0 / 0 / 0
Регистрация: 07.12.2019
Сообщений: 295
|
|
|
1
|
Оракл курсор
07.07.2020, 16:49. Показов 445. Ответов 0
--Создайте последовательный курсор, который указывает на то, сколько каждый американский магазин продал книг за прошлый год
| Oracle 11 SQL | 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| DECLARE CURSOR USA_shopsales IS SELECT NAME_SHOP,NAME_COUNTRY,ID_SHOP
FROM COUNTRY,SHOPS,SALES
WHERE NAME_COUNTRY LIKE 'USA' AND ID_SHOP=ID_SHOP AND ID_COUNTRY=ID_COUNTRY AND DATE_OF_SALE BETWEEN DATE '07.07.2019'AND '07.07.2020';
BEGIN
OPEN USA_shopsales;
LOOP
FETCH USA_shopsales INTO NAME_SHOP,NAME_COUNTRY,ID_SHOP;
IF USA_shopsales%notfound THEN
dbms_output._put.line('no shops selected');
ELSIF USA_shopsales%found THEN
total_rows:=sql%rowcount;
dbms_output._put.line(NAME_SHOP||''||NAME_COUNTRY||''||ID_SHOP);
END IF;
END LOOP;
CLOSE USA_shopsales;
END; |
|
помогите доделать курсор
Добавлено через 37 минут
выдает такую ошыбку:
| Oracle 11 SQL | 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| Error starting AT line : 2 IN command -
DECLARE CURSOR USA_shops IS SELECT NAME_SHOP,NAME_COUNTRY,ID_SHOP
FROM COUNTRY,SHOPS,SALES
WHERE NAME_COUNTRY LIKE 'USA'AND ID_SHOP=ID_SHOP AND ID_COUNTRY=ID_COUNTRY;
BEGIN
OPEN USA_shopsales;
LOOP
FETCH USA_shops INTO NAME_SHOP,NAME_COUNTRY,ID_SHOP;
exitUSA_shops%notfound;
dbms_output._put.line('no shops selected');
IF DATE_OF_SALE BETWEEN DATE '07.07.2019' AND '07.07.2020'THEN
total_rows:=sql%rowcount;
dbms_output._put.line(NAME_SHOP||' '||NAME_COUNTRY||' '||ID_SHOP);
END IF;
END LOOP;
CLOSE USA_shops;
END;
Error report -
ORA-06550: line 0, COLUMN 0:
PLS-00801: internal error [10902]
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action: |
|
0
|
(
