fork download
copy 
  1. -- your code goes herecreate table test (id number(3) not null);
  2.  
  3. create table product_category (
  4.    id number(20) not null,
  5.    name varchar2(80)  not null,
  6.    CONSTRAINT product_category_pk PRIMARY KEY (id)
  7. );
  8.  
  9. create table product (
  10.    id number(20) not null,
  11.    name varchar2(80)  not null,
  12.    price number(7, 2)  not null,
  13.    cat_id number(2) not null,
  14.    CONSTRAINT product_pk PRIMARY KEY (id),
  15.    CONSTRAINT fk_product_category FOREIGN KEY (cat_id) REFERENCES product_category(id)
  16. );
  17.  
  18. insert into product_category (id, name) values (1, 'Food');
  19. insert into product_category (id, name) values (2, 'Building');
  20. insert into product_category (id, name) values (3, 'Cars');
  21.  
  22. insert into product (id, name, price, cat_id) values (01, 'Coffee', 0.95, 1);
  23. insert into product (id, name, price, cat_id) values (02, 'Bread', 0.30, 1);
  24. insert into product (id, name, price, cat_id) values (03, 'Salt', 0.15, 1);
  25. insert into product (id, name, price, cat_id) values (04, 'Red_Brick', 22.30, 2);
  26. insert into product (id, name, price, cat_id) values (05, 'White_Brick', 22.10, 2);
  27. insert into product (id, name, price, cat_id) values (06, 'Half_Red_Brick', 11.15, 2);
  28. insert into product (id, name, price, cat_id) values (07, 'Half_White_Brick', 11.05, 2);
  29. insert into product (id, name, price, cat_id) values (08, 'Slow_Car', 3000.90, 3);
  30. insert into product (id, name, price, cat_id) values (09, 'Middle_Car', 4500.30, 3);
  31. insert into product (id, name, price, cat_id) values (10, 'Fast_Car', 6000.80, 3);
  32.  
  33.  
  34. /* Даны таблицы: 
  35.  product_category - категории продуктов:
  36.    id - номер категории;
  37.    name - имя категории;
  38.    
  39.  product - каталог продуктов и цен:
  40.    id - номер продукта;
  41.    name - имя продукта;
  42.    price - цена;
  43.    cat_id - номер категории;
  44.  
  45. Задание: 
  46.   Написать запрос для вывода списка продуктов, которые имеют цену > 10.00.
  47. Условия:
  48.   - Цена продукта > 10;
  49.   - Вывести только поля: id, name, price
  50.   - Отсортировать по возрастанию цены;
  51. */
  52.  
  53.  
  54.  
  55.  
  56.  
  57.  
  58. select Pepper from product;
  59.  
  60.  
  61.  
  62. insert into product(Id,Name,price,CAT_ID)values('50','Pepper','0.3','1');
  63.  
  64. commit;
  65.  
  66.  
  67. select * from product_category;
  68.  
  69.  
Success #stdin #stdout #stderr 0.01s 5272KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
1|Food
2|Building
3|Cars
stderr
copy 
Error: near line 58: no such column: Pepper
Error: near line 64: cannot commit - no transaction is active
https://ideone.com/DqT2Zg
language:
SQLite (sqlite 3.27.2)
created:
106 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!