-
Changing dateType of a column
i need to change the datType of a column:
below the code i thought will work but it is not.
alter table emp rename column insert_time to time_value1 date default (sysdate)
----------------------------------------------------------------
i know the above query is wrong,can any one provide a good solution
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|