plsqL复习
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了plsqL复习,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2263字,纯文字阅读大概需要4分钟。
内容图文
![plsqL复习](/upload/InfoBanner/zyjiaocheng/449/5f715f5be2ad4e458c1527784c5e59f0.jpg)
$147 $5
SELECT c.customer_id cust_id, o.order_id ord_id, c.gender
FROM customers c
JOIN orders o
ON c.customer_id = o.customer_id ;
CUST_ID ORD_ID G
--------- --------- -
$147 $2450 F
$147 $2425 F
$147 $2385 F
$147 $2366 F
$147 $2396 F
$148 $2451 M
$148 $2426 M
$148 $2386 M
$148 $2367 M
3.Group by语句:
SELECT c.customer_id, COUNT(o.order_id) AS orders_ct
FROM customers c
JOIN orders o
ON c.customer_id = o.customer_id
WHERE gender = ‘F‘
GROUP BY c.customer_id;
CUSTOMER_ID ORDERS_CT
----------- ---------
$123 $1
$147 $5
$107 $4
$154 $1
$169 $1
$104 $4
$105 $4
$146 $5
$156 $1
$166 $1
$103 $4
11 rows selected.
4.Select列表:
SELECT c.customer_id,
c.cust_first_name || ‘‘ || c.cust_last_name,
(SELECT e.last_name
FROM hr.employees e
WHERE e.employee_id = c.account_mgr_id) acct_mgr
FROM oe.customers c;
CUSTOMER_ID C.CUST_FIRST_NAME||‘‘||C.CUST_LAST_NAME ACCT_MGR
----------- ---------------------------------------- -------------------------
$147 IshwaryaRoberts Russell
$148 GustavSteenburgen Russell
$149 MarkusRampling Russell
$150 GoldieSlater Russell
$151 DivineAykroyd Russell
$152 DieterMatthau Russell
$153 DivineSheen Russell
$154 FredericGrodin Russell
$155 FredericoRomero Russell
5.INSERT语句:
INSERT INTO hr.jobs
(job_id, job_title, min_salary, max_salary)
VALUES
(‘IT_PM‘, ‘Project Manager‘, 5000, 11000);
1 row created.
SQL> commit;
Commit complete.
6.多表查询:
SQL> select * from large_customers;
no rows selected
SQL> select * from medium_customers;
no rows selected
SQL> select * from small_customers;
no rows selected
INSERT ALL WHEN sum_orders < 10000 THEN INTO small_customers WHEN sum_orders >= 10000 AND sum_orders < 100000 THEN INTO medium_customers ELSE INTO large_customers
SELECT customer_id, SUM(order_total) sum_orders
FROM orders
GROUP BY customer_id;
plsqL复习
标签:oracle
本文系统来源:http://7642644.blog.51cto.com/7632644/1658515
内容总结
以上是互联网集市为您收集整理的plsqL复习全部内容,希望文章能够帮你解决plsqL复习所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。