数据库学习之一:在Oraclesqldeveloper上运行SQL必知必会脚本(三)

2014-11-24 07:55:38 · 作者: · 浏览: 13
rderItems(order_num, order_item, prod_id, quantity, item_price) VALUES(20009, 2, 'BNBG02', 250, 2.49); INSERT INTO OrderItems(order_num, order_item, prod_id, quantity, item_price) VALUES(20009, 3, 'BNBG03', 250, 2.49); 运行脚本后:

\

之后简单查询下:

SELECT prod_name

FROM Products;
输出如下:

\

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~THE END---------------------------------------------------------------------------------