📄 604.txt
字号:
ORA-00933: SQL 命令未正确结束
SQL> select distinct s1.name from student s1,(select lid as ld from student) s2 where s1.id = s2.ld;
NAME
--------------------
jacky
lucy
好
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
EMP TABLE
BONUS TABLE
SALGRADE TABLE
STUDENT TABLE
SQL> select name ,age a from student where age > 20 order by age;
NAME A
-------------------- ---------------------------------------
lucy 23
好 23
lucy 23
jacky 40
SQL> select * from student;
ID NAME SEX AGE LID
--------------------------------------- -------------------- --- --------------------------------------- ---------------------------------------
1 andy 男 18 2
2 jacky 女 40 2
3 lucy 女 23 4
4 好 男 23 4
5 lucy 女 23 3
SQL> select * from student order by age;
ID NAME SEX AGE LID
--------------------------------------- -------------------- --- --------------------------------------- ---------------------------------------
1 andy 男 18 2
3 lucy 女 23 4
4 好 男 23 4
5 lucy 女 23 3
2 jacky 女 40 2
SQL> select '该班的学生名字为：'|| name from student;
'该班的学生名字为：'||NAME
--------------------------------------
该班的学生名字为：andy
该班的学生名字为：jacky
该班的学生名字为：lucy
该班的学生名字为：好
该班的学生名字为：lucy
SQL> select * from student group by sex;
select * from student group by sex
ORA-00979: 不是 GROUP BY 表达式
SQL> select sex from student group by sex;
SEX
---
男
女
SQL> select sex '性别' , count(*) from student group by sex;
select sex '性别' , count(*) from student group by sex
ORA-00923: 未找到要求的 FROM 关键字
SQL> select sex '性别' , count(*) '人数' from student group by sex;
select sex '性别' , count(*) '人数' from student group by sex
ORA-00923: 未找到要求的 FROM 关键字
SQL> select sex , count(*) '人数' from student group by sex;
select sex , count(*) '人数' from student group by sex
ORA-00923: 未找到要求的 FROM 关键字
SQL> select sex ,count(id) from student group by sex;
SEX COUNT(ID)
--- ----------
男 2
女 3
SQL> select sex ,count(id),id from student group by sex;
select sex ,count(id),id from student group by sex
ORA-00979: 不是 GROUP BY 表达式
SQL> select sex ,count(id) 人数 from student group by sex;
SEX 人数
--- ----------
男 2
女 3
SQL>
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as scott
SQL> select * from student;
ID NAME SEX AGE LID
--------------------------------------- -------------------- --- --------------------------------------- ---------------------------------------
1 andy 男 18 2
2 jacky 女 40 2
3 lucy 女 23 4
4 好 男 23 4
5 lucy 女 23 3
SQL> select * from student where id in (select lid from student);
ID NAME SEX AGE LID
--------------------------------------- -------------------- --- --------------------------------------- ---------------------------------------
2 jacky 女 40 2
3 lucy 女 23 4
4 好 男 23 4
SQL> select e.name from student e;
NAME
--------------------
andy
jacky
lucy
好
lucy
SQL> select s1.name from student s1,student s2 s1.id = s2.lid;
select s1.name from student s1,student s2 s1.id = s2.lid
ORA-00933: SQL 命令未正确结束
SQL> select s1.name from student s1,student s2 where s1.id = s2.lid;
NAME
--------------------
jacky
jacky
好
好
lucy
SQL> select distinct s1.name from student s1,student s2 where s1.id = s2.lid;
NAME
--------------------
jacky
lucy
好
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
14 rows selected
SQL> select * from dept;
DEPTNO DNAME LOC
------ -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> select * from emp ,dept;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO DEPTNO DNAME LOC
----- ---------- --------- ----- ----------- --------- --------- ------ ------ -------------- -------------
7369 SMITH CLERK 7902 1980-12-17 800.00 20 10 ACCOUNTING NEW YORK
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30 10 ACCOUNTING NEW YORK
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30 10 ACCOUNTING NEW YORK
7566 JONES MANAGER 7839 1981-4-2 2975.00 20 10 ACCOUNTING NEW YORK
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30 10 ACCOUNTING NEW YORK
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30 10 ACCOUNTING NEW YORK
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10 10 ACCOUNTING NEW YORK
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20 10 ACCOUNTING NEW YORK
7839 KING PRESIDENT 1981-11-17 5000.00 10 10 ACCOUNTING NEW YORK
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30 10 ACCOUNTING NEW YORK
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20 10 ACCOUNTING NEW YORK
7900 JAMES CLERK 7698 1981-12-3 950.00 30 10 ACCOUNTING NEW YORK
7902 FORD ANALYST 7566 1981-12-3 3000.00 20 10 ACCOUNTING NEW YORK
7934 MILLER CLERK 7782 1982-1-23 1300.00 10 10 ACCOUNTING NEW YORK
7369 SMITH CLERK 7902 1980-12-17 800.00 20 20 RESEARCH DALLAS
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30 20 RESEARCH DALLAS
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30 20 RESEARCH DALLAS
7566 JONES MANAGER 7839 1981-4-2 2975.00 20 20 RESEARCH DALLAS
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30 20 RESEARCH DALLAS
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30 20 RESEARCH DALLAS
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO DEPTNO DNAME LOC
----- ---------- --------- ----- ----------- --------- --------- ------ ------ -------------- -------------
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10 20 RESEARCH DALLAS
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20 20 RESEARCH DALLAS
7839 KING PRESIDENT 1981-11-17 5000.00 10 20 RESEARCH DALLAS
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30 20 RESEARCH DALLAS
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20 20 RESEARCH DALLAS
7900 JAMES CLERK 7698 1981-12-3 950.00 30 20 RESEARCH DALLAS
7902 FORD ANALYST 7566 1981-12-3 3000.00 20 20 RESEARCH DALLAS
7934 MILLER CLERK 7782 1982-1-23 1300.00 10 20 RESEARCH DALLAS
7369 SMITH CLERK 7902 1980-12-17 800.00 20 30 SALES CHICAGO
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30 30 SALES CHICAGO
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30 30 SALES CHICAGO
7566 JONES MANAGER 7839 1981-4-2 2975.00 20 30 SALES CHICAGO
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30 30 SALES CHICAGO
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30 30 SALES CHICAGO
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10 30 SALES CHICAGO
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20 30 SALES CHICAGO
7839 KING PRESIDENT 1981-11-17 5000.00 10 30 SALES CHICAGO
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30 30 SALES CHICAGO
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20 30 SALES CHICAGO
7900 JAMES CLERK 7698 1981-12-3 950.00 30 30 SALES CHICAGO
7902 FORD ANALYST 7566 1981-12-3 3000.00 20 30 SALES CHICAGO
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO DEPTNO DNAME LOC
----- ---------- --------- ----- ----------- --------- --------- ------ ------ -------------- -------------
7934 MILLER CLERK 7782 1982-1-23 1300.00 10 30 SALES CHICAGO
7369 SMITH CLERK 7902 1980-12-17 800.00 20 40 OPERATIONS BOSTON
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30 40 OPERATIONS BOSTON
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30 40 OPERATIONS BOSTON
7566 JONES MANAGER 7839 1981-4-2 2975.00 20 40 OPERATIONS BOSTON
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30 40 OPERATIONS BOSTON
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30 40 OPERATIONS BOSTON
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10 40 OPERATIONS BOSTON
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20 40 OPERATIONS BOSTON
7839 KING PRESIDENT 1981-11-17 5000.00 10 40 OPERATIONS BOSTON
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30 40 OPERATIONS BOSTON
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20 40 OPERATIONS BOSTON
7900 JAMES CLERK 7698 1981-12-3 950.00 30 40 OPERATIONS BOSTON
7902 FORD ANALYST 7566 1981-12-3 3000.00 20 40 OPERATIONS BOSTON
7934 MILLER CLERK 7782 1982-1-23 1300.00 10 40 OPERATIONS BOSTON
56 rows selected
SQL> select * from emp where deptno = (select deptno from dept where dname='SALES');
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7900 JAMES CLERK 7698 1981-12-3 950.00 30
6 rows selected
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -