RENAME TABLE table-Name TO new-Table-Name. The RENAME TABLE statement is not allowed if there are any open cursors that reference the table that is being altered. Parent topic: RENAME statements. Related reference. RENAME COLUMN statement. Jun 24, · How can one drop a column from a table in Oracle 8i? Oracle: How does one count/sum RANGES of data values in a column? How does one count different data values in a column In Oracle? How to add column in existing oracle table with not null constraint; How does one select EVERY Nth row from a table In Oracle? Dec 30, · Don't know whether 8i had alter table rename column old_col to new_col (didn't check the docs) but I think that better would be first add new column then update table set new_col = old_col, and then drop old column. Other way around could be renaming the source table and creating a view with the old table's name with new column name.
SQL tutorial 23: Rename and Modify Column Using Alter Table By Manish Sharma (RebellionRider), time: 4:36Tags: Kool keith kutmasta kurt album s, Kyun hawa ringtone s, Weena bagaikan puteri karaoke s, Brute force windows xp, Como descargar la lista tascon