Home » SQL & PL/SQL » SQL & PL/SQL » columns
columns [message #20423] Wed, 22 May 2002 19:00 Go to next message
Syed Zaki Hyder
Messages: 2
Registered: May 2002
Junior Member
after droping the column from the table,i want to add
the same column at same place,How it is possble.
reply as soon as posbl.

Report message to a moderator

Re: columns [message #20424 is a reply to message #20423] Wed, 22 May 2002 23:08 Go to previous messageGo to next message
P
Messages: 29
Registered: May 2002
Junior Member
alter table table_name column_name datatype (length)

Report message to a moderator

Re: columns [message #20429 is a reply to message #20423] Thu, 23 May 2002 04:23 Go to previous message
Tariq lakho
Messages: 3
Registered: May 2002
Junior Member
You can't add the same column on the same place.
it will always add at the bottom, i mean after last column.

Report message to a moderator

Previous Topic: Re: Connecting to Oracle 8i...
Next Topic: Re: Backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 15:15:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.