Home » SQL & PL/SQL » SQL & PL/SQL » altering the table
altering the table [message #270673] Thu, 27 September 2007 14:08 Go to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
Hi
i am unable to alter a newly created table in oracle.I have to change the properties of a column value.When i click edit button,the fields are not active.I tried to give additional privilege to this user as 'alter table' which didn't give any result. Any ideas?Thanks.

cheers
ryju
Re: altering the table [message #270675 is a reply to message #270673] Thu, 27 September 2007 14:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Those who live by the GUI, die by the GUI.
SQL always works for me.
Re: altering the table [message #270676 is a reply to message #270673] Thu, 27 September 2007 14:15 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
I have another problem too.For a date/time data type, is date data type is sufficient to hold both date and time values or timestamp is required.Thanks
Cheers
Ryju
Re: altering the table [message #270679 is a reply to message #270673] Thu, 27 September 2007 14:17 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
i have no choice other than GUI i have to do in that way.Can anyone help me?

[mod-edit] illiterate IM speak words removed.

[Updated on: Thu, 27 September 2007 15:01] by Moderator

Report message to a moderator

Re: altering the table [message #270680 is a reply to message #270673] Thu, 27 September 2007 14:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
How can I help you when I don't have your GUI?
Re: altering the table [message #270683 is a reply to message #270673] Thu, 27 September 2007 14:30 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
Just curious which GUI do you use as you did not specify it.
However I bet it contains HELP item on the right side of the menu bar...

For your second question:
Oracle SQL Reference (part of Oracle documentation, foung eg.online on http://tahiti.oracle.com)
Chapter 2 Basic Elements of Oracle SQL
Datatypes
Oracle Built-in Datatypes
DATE Datatype + TIMESTAMP Datatype
Re: altering the table [message #270685 is a reply to message #270673] Thu, 27 September 2007 14:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you want to learn why you are having problems altering a table, you can start by reading the following CAREFULLY!
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/security.htm#g24279
Re: altering the table [message #270686 is a reply to message #270673] Thu, 27 September 2007 14:42 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
i am using oracle j developer.i couldnt find out from help.Anyway thanks.
Re: altering the table [message #270687 is a reply to message #270673] Thu, 27 September 2007 14:45 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
thanks bro.I altered the table with sql.
Re: altering the table [message #270690 is a reply to message #270687] Thu, 27 September 2007 15:03 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
First:

RyjuRaju wrote on Thu, 27 September 2007 15:17
i have no choice other than GUI i have to do in that way.Can anyone help me?


Then:

RyjuRaju wrote on Thu, 27 September 2007 15:45
thanks bro.I altered the table with sql.


How is that possible?
Re: altering the table [message #270695 is a reply to message #270690] Thu, 27 September 2007 15:30 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Don't believe in miracles.

Rely on them.
Re: altering the table [message #270697 is a reply to message #270673] Thu, 27 September 2007 15:34 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I was thinking that if there was no choice but to use his tool, then he must be doing a homework assignment, and was going to move the post to the homework section.
Previous Topic: Interesting SQL Nesting query
Next Topic: PL SQL - In Operator Issue
Goto Forum:
  


Current Time: Mon Feb 17 18:59:55 CST 2025