OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » QUERY...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

QUERY... [message #7985]

Mon, 21 July 2003 04:14

Mubeen
Messages: 44
Registered: February 2003

Member

HI ALL,

HERE IS MY QUERY:-

ALTER TABLE EMP SET HIREDATE = '22/FEB/1981' WHERE EMPNO = 7521;

IT IS GIVING THE FOLLOWING ERROR

ORA-02000: missing UNUSED keyword

ANY HELP WILL BE APPRECIATED.

THANX & REGARDS

MUBEEN.

Report message to a moderator

Re: QUERY... [message #7986 is a reply to message #7985]

Mon, 21 July 2003 05:04

jigar
Messages: 74
Registered: July 2002

Member

I guess you want to update the column data...
if yes, use update statement rather than alter

Report message to a moderator

Re: QUERY... [message #8003 is a reply to message #7985]

Mon, 21 July 2003 23:40

Zia Khattak
Messages: 22
Registered: July 2003

Junior Member

SQL> update emp set HIREDATE = '22/FEB/1981' WHERE EMPNO = 7521;

1 row updated.

Report message to a moderator

Previous Topic:	Problem in retrieving top 5 emp
Next Topic:	how to send email with National Characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:56:43 CDT 2024