Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Sqlplus Alter question
Hi.
I'm working in a database that has a table called
payroll_transaction_master. When I use
sql> describe payroll_transaction_master
I get a nice listing of that table.
When I attempt the following
SQL> alter table payroll_transaction_master add job_function integer;
I get
alter table payroll_transaction_master add job_function integer
*
ERROR at line 1:
ORA-00942: table or view does not exist
Have I entered the command incorrectly? Hope this isn't too trivial. I'm an Oracle newbie.
Thanks,
Martin Meadows
Received on Sun Mar 01 1998 - 00:00:00 CST
![]() |
![]() |