altering the table [message #270673] |
Thu, 27 September 2007 14:08  |
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 #270676 is a reply to message #270673] |
Thu, 27 September 2007 14:15   |
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 #270683 is a reply to message #270673] |
Thu, 27 September 2007 14:30   |
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 #270690 is a reply to message #270687] |
Thu, 27 September 2007 15:03   |
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 #270697 is a reply to message #270673] |
Thu, 27 September 2007 15:34  |
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.
|
|
|