首页
Python
Java
前端
数据库
Linux
Chatgpt专题
开发者工具箱
oracle4专题
oracle4之PLSQL工具
PL/SQL块 declare begin --SQL语句 --直接写的SQL语句(DML/TCL) --间接写execute immediate <DDL/DCL命令字符串> --select 语句 <1>必须带有into子句 select empno into eno from emp
阅读更多...
oracle4 查询
select sum(price*qty) from books;select pub,sum(price*qty) from books group by pub;select pub,sum(price*qty) from books group by pub having sum(price)>50; select a1.count(a1) from aa group by a1 havi
阅读更多...