SQL> sysdate
SP2-0042: unknown command "sysdate" - rest of line ignored.
SQL> select sysdate from dual;
SYSDATE
---------
20-FEB-24
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 17-DEC-08 800
20
7499 ALLEN SALESMAN 7698 20-FEB-11 1600 300
30
7521 WARD SALESMAN 7698 22-FEB-11 1250 500
30
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7566 JONES MANAGER 7839 02-APR-07 2975
20
7654 MARTIN SALESMAN 7698 28-SEP-10 1250 1400
30
7698 BLAKE MANAGER 7839 01-MAY-10 2850
30
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7782 CLARK MANAGER 7839 09-JUN-09 2450
10
7788 SCOTT ANALYST 7566 09-DEC-12 3000
20
7839 KING PRESIDENT 17-NOV-07 5000
10
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7844 TURNER SALESMAN 7698 11-SEP-12 1500 0
30
7876 ADAMS CLERK 7788 12-JAN-13 1100
20
7900 JAMES CLERK 7698 03-DEC-10 950
30
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- --------- ---------- ----------
DEPTNO
----------
7902 FORD ANALYST 7566 03-DEC-11 3000
20
7934 MILLER CLERK 7782 23-JAN-12 1300
10
14 rows selected.
SQL> select empno matricule, ename nom,job poste,hiredate "date d'embauche"
2 from emp;
MATRICULE NOM POSTE date d'em
---------- ---------- --------- ---------
7369 SMITH CLERK 17-DEC-08
7499 ALLEN SALESMAN 20-FEB-11
7521 WARD SALESMAN 22-FEB-11
7566 JONES MANAGER 02-APR-07
7654 MARTIN SALESMAN 28-SEP-10
7698 BLAKE MANAGER 01-MAY-10
7782 CLARK MANAGER 09-JUN-09
7788 SCOTT ANALYST 09-DEC-12
7839 KING PRESIDENT 17-NOV-07
7844 TURNER SALESMAN 11-SEP-12
7876 ADAMS CLERK 12-JAN-13
MATRICULE NOM POSTE date d'em
---------- ---------- --------- ---------
7900 JAMES CLERK 03-DEC-10
7902 FORD ANALYST 03-DEC-11
7934 MILLER CLERK 23-JAN-12
14 rows selected.
SQL> select ename||' a un salaire de '||sal "Employe avec salaire
2 from emp;
ERROR:
ORA-01740: missing double quote in identifier
SQL> select ename||" a un salaire de "||sal "Employe avec salaire
2 from emp;
ERROR:
ORA-01740: missing double quote in identifier
SQL> select ename||' a un salaire de '||sal "Employe avec salaire"
2 from emp;
Employe avec salaire
-------------------------------------------------------------------
SMITH a un salaire de 800
ALLEN a un salaire de 1600
WARD a un salaire de 1250
JONES a un salaire de 2975
MARTIN a un salaire de 1250
BLAKE a un salaire de 2850
CLARK a un salaire de 2450
SCOTT a un salaire de 3000
KING a un salaire de 5000
TURNER a un salaire de 1500
ADAMS a un salaire de 1100
Employe avec salaire
-------------------------------------------------------------------
JAMES a un salaire de 950
FORD a un salaire de 3000
MILLER a un salaire de 1300
14 rows selected.
SQL> describe dept;
Name Null? Type
----------------------------------------- -------- ----------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME NOT NULL VARCHAR2(14)
LOC VARCHAR2(13)
SQL> select deptno||','||dname||','||loc "THE_OUTPUT"
2 from dept;
THE_OUTPUT
---------------------------------------------------------------------
10,ACCOUNTING,NEW YORK
20,RESEARCH,DALLAS
30,SALES,CHICAGO
40,OPERATIONS,BOSTON
SQL> select ename, job, hiredate
2 from emp
3 where to_char( hiredate,'fm dd month yyyy') between "20 fevrier 2010" and "1 mai 2012"
4 order by hiredate;
where to_char( hiredate,'fm dd month yyyy') between "20 fevrier 2010" and "1 mai 2012"
ERROR at line 3:
ORA-00904: "1 mai 2012": invalid identifier
SQL> select ename, job, hiredate
2 from emp
3 where to_char( hiredate,'fm dd month yyyy') between '20 fevrier 2010' and '1 mai 2012'
4 order by hiredate;
no rows selected
SQL> select ename, job, hiredate
2 from emp
3 where hiredate between 10-feb-10 and 1-may-12
4 order by hiredate;
where hiredate between 10-feb-10 and 1-may-12
ERROR at line 3:
ORA-00904: "MAY": invalid identifier
SQL> select ename, job, hiredate
2 from emp
3 where hiredate between '10-feb-10' and '1-may-12'
4 order by hiredate;
ENAME JOB HIREDATE
---------- --------- ---------
BLAKE MANAGER 01-MAY-10
MARTIN SALESMAN 28-SEP-10
JAMES CLERK 03-DEC-10
ALLEN SALESMAN 20-FEB-11
WARD SALESMAN 22-FEB-11
FORD ANALYST 03-DEC-11
MILLER CLERK 23-JAN-12
7 rows selected.
SQL> select select ename, hiredate
2 from emp
3 where hiredate between '10-feb-10' and '1-may-12'
4 ;
select select ename, hiredate
*
ERROR at line 1:
ORA-00936: missing expression
SQL> select ename, hiredate
2 from emp
3 where hiredate between '1-feb-10' and '31-dec-10';
ENAME HIREDATE
---------- ---------
MARTIN 28-SEP-10
BLAKE 01-MAY-10
JAMES 03-DEC-10
SQL> select sysdate from dual;
SYSDATE
---------
20-FEB-24
SQL> describe dept;
Name Null? Type
----------------------------------------- -------- ----------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME NOT NULL VARCHAR2(14)
LOC VARCHAR2(13)
SQL> desc dept;
Name Null? Type
----------------------------------------- -------- ----------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME NOT NULL 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 emp;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NOT NULL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
SQL> select empno,ename,job,hiredate from emp;
EMPNO ENAME JOB HIREDATE
---------- ---------- --------- ---------
7369 SMITH CLERK 17-DEC-08
7499 ALLEN SALESMAN 20-FEB-11
7521 WARD SALESMAN 22-FEB-11
7566 JONES MANAGER 02-APR-07
7654 MARTIN SALESMAN 28-SEP-10
7698 BLAKE MANAGER 01-MAY-10
7782 CLARK MANAGER 09-JUN-09
7788 SCOTT ANALYST 09-DEC-12
7839 KING PRESIDENT 17-NOV-07
7844 TURNER SALESMAN 11-SEP-12
7876 ADAMS CLERK 12-JAN-13
EMPNO ENAME JOB HIREDATE
---------- ---------- --------- ---------
7900 JAMES CLERK 03-DEC-10
7902 FORD ANALYST 03-DEC-11
7934 MILLER CLERK 23-JAN-12
14 rows selected.
SQL> select ename ||' a un salaire de '|| sal "emplye avec salaire" from emp;
emplye avec salaire
-------------------------------------------------------------------
SMITH a un salaire de 800
ALLEN a un salaire de 1600
WARD a un salaire de 1250
JONES a un salaire de 2975
MARTIN a un salaire de 1250
BLAKE a un salaire de 2850
CLARK a un salaire de 2450
SCOTT a un salaire de 3000
KING a un salaire de 5000
TURNER a un salaire de 1500
ADAMS a un salaire de 1100
emplye avec salaire
-------------------------------------------------------------------
JAMES a un salaire de 950
FORD a un salaire de 3000
MILLER a un salaire de 1300
14 rows selected.
SQL> select dname,deptno,loc
2 ;
ERROR at line 2:
ORA-00923: FROM keyword not found where expected
SQL> select dname||','||deptno||','||loc as "THE_OUTPUT"
2 from dept;
THE_OUTPUT
---------------------------------------------------------------------
ACCOUNTING,10,NEW YORK
RESEARCH,20,DALLAS
SALES,30,CHICAGO
OPERATIONS,40,BOSTON
SQL> select ename ,sal,comm
2 from emp
3 where comm <> 0 or comm <> NULL
4 order by sal,comm DESC;
ENAME SAL COMM
---------- ---------- ----------
MARTIN 1250 1400
WARD 1250 500
ALLEN 1600 300
SQL> select ename
2 where ename like'%T%T%' and deptno = 20 ou mgr = 7566;
where ename like'%T%T%' and deptno = 20 ou mgr = 7566
ERROR at line 2:
ORA-00923: FROM keyword not found where expected
SQL> select ename
2 from emp
3 where ename like'%T%T%' and deptno = 20 ou mgr = 7566;
where ename like'%T%T%' and deptno = 20 ou mgr = 7566
ERROR at line 3:
ORA-00933: SQL command not properly ended
SQL> select ename
2 from emp
3 where ename like'%T%T%' and deptno = 20 or mgr =7566;
ENAME
----------
SCOTT
FORD
SQL> select ename
2 from emp
3 where job like'sales%'
4 order by comm/sal;
no rows selected
SQL> select ename
2 from emp
3 where job like'SALES%'
4 order by comm/sal;
ENAME
----------
TURNER
ALLEN
WARD
MARTIN
SQL> select ename
2 from emp
3 where nval(comm,0)<0.25*sal;
where nval(comm,0)<0.25*sal
ERROR at line 3:
ORA-00904: "NVAL": invalid identifier
SQL> select ename
2 from emp
3 where nvl(comm,0)<0.25*sal;
ENAME
----------
SMITH
ALLEN
JONES
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
JAMES
FORD
ENAME
----------
MILLER
12 rows selected.
SQL> select ename,sal,comm
2 from emp
3 where nvl(comm,0) <= 0.1*sal;
ENAME SAL COMM
---------- ---------- ----------
SMITH 800
JONES 2975
BLAKE 2850
CLARK 2450
SCOTT 3000
KING 5000
TURNER 1500 0
ADAMS 1100
JAMES 950
FORD 3000
MILLER 1300
11 rows selected.
SQL> select job
2 from emp
3 ;
JOB
---------
CLERK
SALESMAN
SALESMAN
MANAGER
SALESMAN
MANAGER
MANAGER
ANALYST
PRESIDENT
SALESMAN
CLERK
JOB
---------
CLERK
ANALYST
CLERK
14 rows selected.
SQL> select sysdate from dual;
SYSDATE
---------
20-FEB-24
SQL> select ename,job,hiredate
2 from emp
3 where hiredate between '20-FEB-10' and '01-MAY-12'
4 order by hiredate;
ENAME JOB HIREDATE
---------- --------- ---------
BLAKE MANAGER 01-MAY-10
MARTIN SALESMAN 28-SEP-10
JAMES CLERK 03-DEC-10
ALLEN SALESMAN 20-FEB-11
WARD SALESMAN 22-FEB-11
FORD ANALYST 03-DEC-11
MILLER CLERK 23-JAN-12
7 rows selected.
SQL>
SQL> select ename,hiredate
2 from emp
3 where hiredate between '01-JAN-10' and '31-DEC-10';
ENAME HIREDATE
---------- ---------
MARTIN 28-SEP-10
BLAKE 01-MAY-10
JAMES 03-DEC-10
SQL> select ename,sal,comm
2 from emp
3 where comm is not null
4 order by sal desc,comm desc;
ENAME SAL COMM
---------- ---------- ----------
ALLEN 1600 300
TURNER 1500 0
MARTIN 1250 1400
WARD 1250 500
SQL> select ename
2 from emp
3 where ename like '%T%T%' and deptno = 20 or mgr = 7566;
ENAME
----------
SCOTT
FORD
SQL> select ename, comm/SAL AS "ratio" from emp where job="SALESMAN" order by ratio desc;
select ename, comm/SAL AS "ratio" from emp where job="SALESMAN" order by ratio desc
ERROR at line 1:
ORA-00904: "RATIO": invalid identifier
SQL> select ename, comm/SAL AS "ratio" from emp where job="SALESMAN" order by comm/SAL
desc;
select ename, comm/SAL AS "ratio" from emp where job="SALESMAN" order by comm/SAL desc
ERROR at line 1:
ORA-00904: "SALESMAN": invalid identifier
SQL> select ename, comm/SAL AS "ratio" from emp where job='SALESMAN' order by comm/SAL
desc;
ENAME ratio
---------- ----------
MARTIN 1.12
WARD .4
ALLEN .1875
TURNER 0
SQL> select ename
2 from emp
3 where comm< 0.25 *sal;
ENAME
----------
ALLEN
TURNER
SQL> SELECT DISTINCT job "poste"
2 FROM emp
3 WHERE deptno = 30;
poste
---------
SALESMAN
CLERK
MANAGER
SQL> select ename,job,sal
2 from emp
3 where job IN ('CLERK','ACCOUNT') and sal NOT IN (1000,3000,5000);
ENAME JOB SAL
---------- --------- ----------
SMITH CLERK 800
ADAMS CLERK 1100
JAMES CLERK 950
MILLER CLERK 1300
SQL> select ename nom,sal salaire,comm commission
2 from emp
3 where comm>0.1*sal;
NOM SALAIRE COMMISSION
---------- ---------- ----------
ALLEN 1600 300
WARD 1250 500
MARTIN 1250 1400
SQL> select ename, empno, sal, sal*1.15 as 'NEW SALARY'
2 from emp;
select ename, empno, sal, sal*1.15 as 'NEW SALARY'
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select ename, empno, sal, round(sal*1.15) 'NEWSALARY' from emp;
select ename, empno, sal, round(sal*1.15) 'NEWSALARY' from emp
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select ename, empno, sal, round(sal*1.15) NEWSALARY from emp;
ENAME EMPNO SAL NEWSALARY
---------- ---------- ---------- ----------
SMITH 7369 800 920
ALLEN 7499 1600 1840
WARD 7521 1250 1438
JONES 7566 2975 3421
MARTIN 7654 1250 1438
BLAKE 7698 2850 3278
CLARK 7782 2450 2818
SCOTT 7788 3000 3450
KING 7839 5000 5750
TURNER 7844 1500 1725
ADAMS 7876 1100 1265
ENAME EMPNO SAL NEWSALARY
---------- ---------- ---------- ----------
JAMES 7900 950 1093
FORD 7902 3000 3450
MILLER 7934 1300 1495
14 rows selected.
SQL> select ename, empno, sal, round(sal*1.15) NEWSALARY, round(sal*0,15) increase
2 from emp;
ENAME EMPNO SAL NEWSALARY INCREASE
---------- ---------- ---------- ---------- ----------
SMITH 7369 800 920 0
ALLEN 7499 1600 1840 0
WARD 7521 1250 1438 0
JONES 7566 2975 3421 0
MARTIN 7654 1250 1438 0
BLAKE 7698 2850 3278 0
CLARK 7782 2450 2818 0
SCOTT 7788 3000 3450 0
KING 7839 5000 5750 0
TURNER 7844 1500 1725 0
ADAMS 7876 1100 1265 0
ENAME EMPNO SAL NEWSALARY INCREASE
---------- ---------- ---------- ---------- ----------
JAMES 7900 950 1093 0
FORD 7902 3000 3450 0
MILLER 7934 1300 1495 0
14 rows selected.
SQL> select ename, empno, sal, round(sal*1.15) NEWSALARY, round(NEWSALARY-sal) increase
2 from emp;
select ename, empno, sal, round(sal*1.15) NEWSALARY, round(NEWSALARY-sal) increase
ERROR at line 1:
ORA-00904: "NEWSALARY": invalid identifier
SQL> select ename, empno, sal, round(sal*1.15) as "NEWSALARY", round(NEWSALARY-sal) increase
2 from emp;
select ename, empno, sal, round(sal*1.15) as "NEWSALARY", round(NEWSALARY-sal) increase
ERROR at line 1:
ORA-00904: "NEWSALARY": invalid identifier
SQL> select ename, empno, sal, round(sal*1.15) as "NEWSALARY", round(sal*1,15-sal)
2 as "increase" from emp;
ENAME EMPNO SAL NEWSALARY increase
---------- ---------- ---------- ---------- ----------
SMITH 7369 800 920 0
ALLEN 7499 1600 1840 0
WARD 7521 1250 1438 0
JONES 7566 2975 3421 0
MARTIN 7654 1250 1438 0
BLAKE 7698 2850 3278 0
CLARK 7782 2450 2818 0
SCOTT 7788 3000 3450 0
KING 7839 5000 5750 0
TURNER 7844 1500 1725 0
ADAMS 7876 1100 1265 0
ENAME EMPNO SAL NEWSALARY increase
---------- ---------- ---------- ---------- ----------
JAMES 7900 950 1093 0
FORD 7902 3000 3450 0
MILLER 7934 1300 1495 0
14 rows selected.
SQL> select ename, empno, sal, round(sal*1.15) as "NEWSALARY", round(sal*1.15-sal)
2 as "increase" from emp;
ENAME EMPNO SAL NEWSALARY increase
---------- ---------- ---------- ---------- ----------
SMITH 7369 800 920 120
ALLEN 7499 1600 1840 240
WARD 7521 1250 1438 188
JONES 7566 2975 3421 446
MARTIN 7654 1250 1438 188
BLAKE 7698 2850 3278 428
CLARK 7782 2450 2818 368
SCOTT 7788 3000 3450 450
KING 7839 5000 5750 750
TURNER 7844 1500 1725 225
ADAMS 7876 1100 1265 165
ENAME EMPNO SAL NEWSALARY increase
---------- ---------- ---------- ---------- ----------
JAMES 7900 950 1093 143
FORD 7902 3000 3450 450
MILLER 7934 1300 1495 195
14 rows selected.
SQL> select ename, round((sysdate-hiredate)/30.44) as "months_worked" from emp
2 order by months_worked ;
order by months_worked
ERROR at line 2:
ORA-00904: "MONTHS_WORKED": invalid identifier
SQL> select ename, round(months_between(sysdate,hiredate)) as "months_worked" from emp
order by months_wor^Z
2 select ename, round(months_between(sysdate,hiredate)) as "months_worked" from emp order
by months_worked from emp;
select ename, round(months_between(sysdate,hiredate)) as "months_worked" from emp order by
months_wor→
ERROR at line 1:
ORA-00911: invalid character
SQL> select ename, round(months_between(sysdate,hiredate)) as "months_worked" from emp
order by worked_months ;
select ename, round(months_between(sysdate,hiredate)) as "months_worked" from emp order by
worked_months
*
ERROR at line 1:
ORA-00904: "WORKED_MONTHS": invalid identifier
SQL> select ename, round(months_between(sysdate,hiredate)) as "months_worked" from emp
order by months_worked ;
select ename, round(months_between(sysdate,hiredate)) as "months_worked" from emp order by
months_worked
ERROR at line 1:
ORA-00904: "MONTHS_WORKED": invalid identifier
SQL> select ename, round(months_between(sysdate,hiredate)) as months_worked from emp ;
ENAME MONTHS_WORKED
---------- -------------
SMITH 182
ALLEN 156
WARD 156
JONES 203
MARTIN 161
BLAKE 166
CLARK 176
SCOTT 134
KING 195
TURNER 137
ADAMS 133
ENAME MONTHS_WORKED
---------- -------------
JAMES 159
FORD 147
MILLER 145
14 rows selected.
SQL> select ename, round(months_between(sysdate,hiredate)) as months_worked order by
months_worked;
select ename, round(months_between(sysdate,hiredate)) as months_worked order by
months_worked
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select ename, round(months_between(sysdate,hiredate)) as months_worked order by
months_worked desc;
select ename, round(months_between(sysdate,hiredate)) as months_worked order by
months_worked desc
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select ename, round(months_between(sysdate,hiredate)) as months_worked from emp order
by months_worked desc;
ENAME MONTHS_WORKED
---------- -------------
JONES 203
KING 195
SMITH 182
CLARK 176
BLAKE 166
MARTIN 161
JAMES 159
ALLEN 156
WARD 156
FORD 147
MILLER 145
ENAME MONTHS_WORKED
---------- -------------
TURNER 137
SCOTT 134
ADAMS 133
14 rows selected.
SQL> select concat(concat(ename,' veut '), 3*sal) "Salaire de rêve" from emp;
Salaire de rêve
--------------------------------------------------------
SMITH veut 2400
ALLEN veut 4800
WARD veut 3750
JONES veut 8925
MARTIN veut 3750
BLAKE veut 8550
CLARK veut 7350
SCOTT veut 9000
KING veut 15000
TURNER veut 4500
ADAMS veut 3300
Salaire de rêve
--------------------------------------------------------
JAMES veut 2850
FORD veut 9000
MILLER veut 3900
14 rows selected.
SQL> select ename , LPAD(sal,15,'$') as Salary from emp ;
ENAME SALARY
---------- ------------------------------------------------------------
SMITH $$$$$$$$$$$$800
ALLEN $$$$$$$$$$$1600
WARD $$$$$$$$$$$1250
JONES $$$$$$$$$$$2975
MARTIN $$$$$$$$$$$1250
BLAKE $$$$$$$$$$$2850
CLARK $$$$$$$$$$$2450
SCOTT $$$$$$$$$$$3000
KING $$$$$$$$$$$5000
TURNER $$$$$$$$$$$1500
ADAMS $$$$$$$$$$$1100
ENAME SALARY
---------- ------------------------------------------------------------
JAMES $$$$$$$$$$$$950
FORD $$$$$$$$$$$3000
MILLER $$$$$$$$$$$1300
14 rows selected.
SQL> select ename, round(months_between(sysdate,hiredate)) as months_worked from emp order
by months_worked desc;
ENAME MONTHS_WORKED
---------- -------------
JONES 203
KING 195
SMITH 182
CLARK 176
BLAKE 166
MARTIN 161
JAMES 159
ALLEN 156
WARD 156
FORD 147
MILLER 145
ENAME MONTHS_WORKED
---------- -------------
TURNER 137
SCOTT 134
ADAMS 133
14 rows selected.
SQL> select ename , sal+NVL(comm,0) "SAL+COMM"
2 from emp;
ENAME SAL+COMM
---------- ----------
SMITH 800
ALLEN 1900
WARD 1750
JONES 2975
MARTIN 2650
BLAKE 2850
CLARK 2450
SCOTT 3000
KING 5000
TURNER 1500
ADAMS 1100
ENAME SAL+COMM
---------- ----------
JAMES 950
FORD 3000
MILLER 1300
14 rows selected.
SQL>
SQL> select ename,sal,hirdate
2 from emp
3 where
SQL> select ename,sal,hiredate
2 from emp
3 where substr(to_char(hiredate),8,2)in('10','11');
ENAME SAL HIREDATE
---------- ---------- ---------
ALLEN 1600 20-FEB-11
WARD 1250 22-FEB-11
MARTIN 1250 28-SEP-10
BLAKE 2850 01-MAY-10
JAMES 950 03-DEC-10
FORD 3000 03-DEC-11
6 rows selected.
SQL> select ename , sal , hiredate
2 from emp
3 where extract(year from hiredate) between 2010 and 2011;
ENAME SAL HIREDATE
---------- ---------- ---------
ALLEN 1600 20-FEB-11
WARD 1250 22-FEB-11
MARTIN 1250 28-SEP-10
BLAKE 2850 01-MAY-10
JAMES 950 03-DEC-10
FORD 3000 03-DEC-11
6 rows selected.
