@P:\wkuzak\konfig @P:\wkuzak\demobld7 SQL*Plus: Release 8.0.6.0.0 - Production on Sob Lut 21 09:32:29 2009 (c) Copyright 1999 Oracle Corporation. All rights reserved. Po章czony z: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select * soil 2 ; select * soil * ERROR w linii 1: ORA-00923: FROM keyword not found where expected SQL> desc emp; Nazwa Null? Typ ------------------------------- -------- ---- EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NOT NULL NUMBER(2) SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO --------- ---------- --------- --------- -------- --------- --------- --------- 7839 KING PRESIDENT 81/11/17 5000 10 7698 BLAKE MANAGER 7839 81/05/01 2850 30 7782 CLARK MANAGER 7839 81/06/09 2450 10 7566 JONES MANAGER 7839 81/04/02 2975 20 7654 MARTIN SALESMAN 7698 81/09/28 1250 1400 30 7499 ALLEN SALESMAN 7698 81/02/20 1600 300 30 7844 TURNER SALESMAN 7698 81/09/08 1500 0 30 7900 JAMES CLERK 7698 81/12/03 950 30 7521 WARD SALESMAN 7698 81/02/22 1250 500 30 7902 FORD ANALYST 7566 81/12/03 3000 20 7369 SMITH CLERK 7902 80/12/17 800 20 7788 SCOTT ANALYST 7566 82/12/09 3000 20 7876 ADAMS CLERK 7788 83/01/12 1100 20 7934 MILLER CLERK 7782 82/01/23 1300 10 14 wierszy zosta這 wybranych. SQL> desc dept; Nazwa Null? Typ ------------------------------- -------- ---- DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13) SQL> select * from dept; DEPTNO DNAME LOC --------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> desc salgrade; Nazwa Null? Typ ------------------------------- -------- ---- GRADE NUMBER LOSAL NUMBER HISAL NUMBER SQL> select * from salgrade; GRADE LOSAL HISAL --------- --------- --------- 1 700 1200 2 1201 1400 3 1401 2000 4 2001 3000 5 3001 9999 SQL> select * from * 2 ; select * from * * ERROR w linii 1: ORA-00903: invalid table name SQL> select * from *; select * from * * ERROR w linii 1: ORA-00903: invalid table name SQL> select ename, sal from mp; select ename, sal from mp * ERROR w linii 1: ORA-00942: table or view does not exist SQL> select ename, sal from emp; ENAME SAL ---------- --------- KING 5000 BLAKE 2850 CLARK 2450 JONES 2975 MARTIN 1250 ALLEN 1600 TURNER 1500 JAMES 950 WARD 1250 FORD 3000 SMITH 800 SCOTT 3000 ADAMS 1100 MILLER 1300 14 wierszy zosta這 wybranych. SQL> select ename, sal, 12*sal+nvl dochody 2 from emp; select ename, sal, 12*sal+nvl dochody * ERROR w linii 1: ORA-00904: "NVL": invalid identifier SQL> select ename, sal, 12*sal+comn dochody 2 from emp; select ename, sal, 12*sal+comn dochody * ERROR w linii 1: ORA-00904: "COMN": invalid identifier SQL> select ename, sal, 12*sal+comn dochody 2 from emp; select ename, sal, 12*sal+comn dochody * ERROR w linii 1: ORA-00904: "COMN": invalid identifier SQL> select ename, sal, 12*sal+comm dochody 2 from emp; ENAME SAL DOCHODY ---------- --------- --------- KING 5000 BLAKE 2850 CLARK 2450 JONES 2975 MARTIN 1250 16400 ALLEN 1600 19500 TURNER 1500 18000 JAMES 950 WARD 1250 15500 FORD 3000 SMITH 800 SCOTT 3000 ADAMS 1100 MILLER 1300 14 wierszy zosta這 wybranych. SQL> select ename, sal, 12*sal+nvl(comm, 0) dochody 2 from emp; ENAME SAL DOCHODY ---------- --------- --------- KING 5000 60000 BLAKE 2850 34200 CLARK 2450 29400 JONES 2975 35700 MARTIN 1250 16400 ALLEN 1600 19500 TURNER 1500 18000 JAMES 950 11400 WARD 1250 15500 FORD 3000 36000 SMITH 800 9600 SCOTT 3000 36000 ADAMS 1100 13200 MILLER 1300 15600 14 wierszy zosta這 wybranych. SQL> select 'dupa' from emp; 'DUP ---- dupa dupa dupa dupa dupa dupa dupa dupa dupa dupa dupa dupa dupa dupa 14 wierszy zosta這 wybranych. SQL> select count(*) from emp; COUNT(*) --------- 14 SQL> select count(comm) from emp; COUNT(COMM) ----------- 4 SQL> select count(*)-count(comm) nulle 2 from emp; NULLE --------- 10 SQL> select count(*)-count(comm) nulle 2 from emp 3 order by ename; NULLE --------- 10 SQL> select ename, count(*)-count(comm) nulle 2 from emp 3 order by ename; select ename, count(*)-count(comm) nulle * ERROR w linii 1: ORA-00937: not a single-group group function SQL> select ename, sal 2 from emp 3 where sal>=2500; ENAME SAL ---------- --------- KING 5000 BLAKE 2850 JONES 2975 FORD 3000 SCOTT 3000 SQL> select ename, sal 2 from emp 3 where sal>=1000 and sal <=3000; ENAME SAL ---------- --------- BLAKE 2850 CLARK 2450 JONES 2975 MARTIN 1250 ALLEN 1600 TURNER 1500 WARD 1250 FORD 3000 SCOTT 3000 ADAMS 1100 MILLER 1300 11 wierszy zosta這 wybranych. SQL> select ename, sal from emp where sal between 1000 and 3000; ENAME SAL ---------- --------- BLAKE 2850 CLARK 2450 JONES 2975 MARTIN 1250 ALLEN 1600 TURNER 1500 WARD 1250 FORD 3000 SCOTT 3000 ADAMS 1100 MILLER 1300 11 wierszy zosta這 wybranych. SQL> ed Zapisano plik afiedt.buf 1* select ename, sal from emp where sal between 1000 and 3000 SQL> ; 1* select ename, sal from emp where sal between 1000 and 3000 SQL> SQL> select ename, sal, 12*sal+nvl(comm, 0) dochody 2 from emp 3 where dochody>20000; where dochody>20000 * ERROR w linii 3: ORA-00904: "DOCHODY": invalid identifier SQL> select ename, sal, 12*sal+nvl(comm, 0) dochody 2 from emp 3 where 12*sal+nvl(comm, 0)>20000; ENAME SAL DOCHODY ---------- --------- --------- KING 5000 60000 BLAKE 2850 34200 CLARK 2450 29400 JONES 2975 35700 FORD 3000 36000 SCOTT 3000 36000 6 wierszy zosta這 wybranych. SQL> select ename from emp where ename like 'M%'; ENAME ---------- MARTIN MILLER SQL> select ename from emp where ename like 'M%' or '%M%'; select ename from emp where ename like 'M%' or '%M%' * ERROR w linii 1: ORA-00920: invalid relational operator SQL> select ename from emp where ename like 'M%' or ename like '%M%'; ENAME ---------- MARTIN JAMES SMITH ADAMS MILLER SQL> select ename from emp where ename > 'M'; ENAME ---------- MARTIN TURNER WARD SMITH SCOTT MILLER 6 wierszy zosta這 wybranych. SQL> select * from emp where ename like '$M%'; nie wybrano 瘸dnych wierszy SQL> select * from emp where ename like '#M%'; nie wybrano 瘸dnych wierszy SQL> select * from emp where ename like ' M%'; nie wybrano 瘸dnych wierszy SQL> select * from emp where ename like '_M%'; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO --------- ---------- --------- --------- -------- --------- --------- --------- 7369 SMITH CLERK 7902 80/12/17 800 20 SQL> slect * from emp where comm!=null; nieznane polecenie pocz靖ek "slect * fr..." - reszta linii pomijana. SQL> select * from emp where comm != null; nie wybrano 瘸dnych wierszy SQL> select * from emp where comm like ' '; nie wybrano 瘸dnych wierszy SQL> select * from emp where comm like ''; nie wybrano 瘸dnych wierszy SQL> select * from emp where comm like null; nie wybrano 瘸dnych wierszy SQL> select * from emp where comm is not null; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO --------- ---------- --------- --------- -------- --------- --------- --------- 7654 MARTIN SALESMAN 7698 81/09/28 1250 1400 30 7499 ALLEN SALESMAN 7698 81/02/20 1600 300 30 7844 TURNER SALESMAN 7698 81/09/08 1500 0 30 7521 WARD SALESMAN 7698 81/02/22 1250 500 30 SQL>