{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:09:42 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 fname,lname,ssn,salary from employee;

FNAME      LNAME                       SSN     SALARY
---------- -------------------- ---------- ----------
John       Smith                 123456789      30000
Franklin   Wong                  333445555      40000
Alicia     Zelaya                999887777      25000
Jennifer   Wallace               987654321      43000
Ramesh     Narayan               666884444      38000
Joyce      English               453453453      25000
Ahmad      Jabbar                987987987      25000
James      Borg                  888665555      55000

8 rows selected.

SQL> select pno, sum(hours) from works_on group by pno;

       PNO SUM(HOURS)
---------- ----------
        30         55
         1       52.5
         2       37.5
         3         50
        20         25
        10         55

6 rows selected.

SQL> select max(salary),dno from employee group by dno order by dno;

MAX(SALARY)        DNO
----------- ----------
      55000          1
      43000          4
      40000          5

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} sqlplus /

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 24 15:09:42 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> /* create a password for your oracle database - this is a comment */ 
SQL>  
SQL> /* ops$gt1234a is the Oracle username - gt1234a is your acme user ID */ 
SQL> /* mypassword is the password you are assigning - must start with a letter
SQL>    and may contain numbers and letters up to 30 characters    */ 
SQL> 
SQL> alter user ops$gt1234a identified by mypassword; 
User altered.

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:132} sqlplus 
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 24 15:57:33 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: ops$gt1234a  
Enter password:   


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

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:133} exit  
Connection to acme closed.