{acmex:gt1234a:129} . oraenv ORACLE_SID = [gt1234a] ? public {acmex:gt1234a:130} sqlplus / SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 24 15:20:29 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> select * from cat; TABLE_NAME TABLE_TYPE ------------------------------ ----------- DEPARTMENT TABLE EMPLOYEE TABLE PROJECT TABLE WORKS_ON TABLE DEPENDENT TABLE DEPT_LOCATIONS TABLE 6 rows selected. SQL> desc department; Name Null? Type ----------------------------------------- -------- ---------------------------- DNAME CHAR(20) DNUMBER NOT NULL NUMBER(1) MGRSSN NUMBER(9) MGRSTARTDATE DATE SQL> select * from department; DNAME DNUMBER MGRSSN MGRSTARTD -------------------- ---------- ---------- --------- Research 5 333445555 22-MAY-88 Administration 4 987654321 01-JAN-95 Headquarters 1 888665555 19-JUN-81 SQL> select * from department where dnumber = &dnumber; Enter value for dnumber: 4 old 1: select * from department where dnumber = &dnumber new 1: select * from department where dnumber = 4 DNAME DNUMBER MGRSSN MGRSTARTD -------------------- ---------- ---------- --------- Administration 4 987654321 01-JAN-95 SQL> Select sysdate from dual; SYSDATE --------- 24-MAY-06 SQL> select fname,lname, (sysdate-bdate)/364 AS age from employee order by age; FNAME LNAME AGE ---------- -------------------- ---------- Joyce English 33.9303572 Ahmad Jabbar 37.2820056 Alicia Zelaya 38.4770605 Franklin Wong 40.5979396 John Smith 41.5127748 Ramesh Narayan 43.8396979 Jennifer Wallace 65.1501374 James Borg 68.7710165 8 rows selected. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options {acmex:gt1234a:131}