I am back with a beginners question

From: Murali D Boyapati <mboyapat_at_udecc.engr.udayton.edu>
Date: Fri, 10 Jun 1994 00:48:04 GMT
Message-ID: <Cr5ow6.4rv_at_udecc.engr.udayton.edu>

 This is the table that I tried in my sqlplus account and also the error is shown below. This table is exactly an example from the oracle/sqlplus on line help and I am stuck du to this error

---

SQL> create table staff (

  2     empno   number          not null        primary key,
  3     ename   char(20)        not null        check (ename = upper),
  4     job     char(10),
  5     mgr     number          references scott.staff(empno),
  6     hiredat date            check (hiredate >= sysdate -7),
  7     sal     number(10,2)    check (sal>800),
  8     comm    number(9,2)     default null,
  9     deptno  not null        references scott.dept(deptno)
 10    )
 11     pctfree 5 pctused 75
 12  ;
        empno   number          not null        primary key,
            *

ERROR at line 2:
ORA-00911: invalid character

---

        if someone could help, i will gladly work as oracle programmer in his/her firm under him ( just kidding )

				thanks
					murali	

Received on Fri Jun 10 1994 - 02:48:04 CEST