Re: Sqlplus Alter question

From: Dave McRae <dmcrae_at_pcug.org.au>
Date: 1998/03/04
Message-ID: <6dimf5$uba$1@bomb.dynamite.com.au>#1/1

GDay Martin,
Strange error! But you do have the syntax out (at least you would using SQL Worksheet :) ).
Try..

alter table payroll_transaction_master add (job_function integer)

--
David McRae                    dmcrae_at_dynamite.com.au
Canberra                            02 6239 4247


Martin Meadows wrote in message <34F9F42B.63F8_at_indy.net>...


>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 Wed Mar 04 1998 - 00:00:00 CST