摘要:
db2 "export to /odsdata/spsp.sql of del lobs to /odsdata lobfile sp.del modified by lobsinfile select text from syscat.routines where routineschema='O 阅读全文
摘要:
--游标的属性SQL> set serveroutput onSQL> declare --声明 2 var_ename varchar2(50);--声明变量,用来存储员工姓名 3 var_job varchar2(50); 4 cursor cur_emp 定义游标,检索指定属性的记录 5 is 阅读全文
摘要:
select * from dept1;create table injon asselect d1.deptno as d1no,d1.dname as d1name,d1.loc as d1loc,--查询表dept1的数据 d2.deptno as d2no, d2.dname as d2na 阅读全文
摘要:
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 Connected as SCOTT@ORCL SQL> set serveroutput onSQL> declare 2 var_name1 varcha 阅读全文
摘要:
--1,单行子查询--查看工资高于工号为7566员工的所有员工信息select * from empwhere sal>(select sal from emp where empno=7566);--2,子查询空值、多值问题--如果子查询未返回任何行,则主查询也不会返回任何结果select * f 阅读全文