<div>
You can rename a column using the CREATE TABLE command with the AS clause. For example, the following statement re-creates the table STATIC, renaming a column from OLDNAME to NEWNAME: <br />
<br />
CREATE TABLE temporary (newname, col2, col3) <br />
&nbsp; &nbsp; AS SELECT oldname, col2, col3 FROM static <br />
DROP TABLE static <br />
RENAME temporary TO static; <br />
<br />

</div>


You can rename a column using the CREATE TABLE command with the AS clause. For example, the following statement re-creates the table STATIC, renaming a column from OLDNAME to NEWNAME:

CREATE TABLE temporary (newname, col2, col3)
    AS SELECT oldname, col2, col3 FROM static
DROP TABLE static
RENAME temporary TO static;



<div>
try this:<br />
<br />
alter table &lt;table_name&gt; rename column &lt;old&gt; to &lt;new&gt;;
</div>


try this:

alter table <table_name> rename column <old> to <new>;

<div>
Note: The &quot;rename column&quot; syntax will work in Oracle 9i, not 8i.
</div>


Note: The "rename column" syntax will work in Oracle 9i, not 8i.

<div>
<div class="content wysiwyg-content">
hello guys,<br />
is it possible for me to delete or rename the column name in the table (oracle 8i). if that possible, can anyone give the idea on how to do it.<br />
<br />
TQ
</div>
</div>


hello guys,
is it possible for me to delete or rename the column name in the table (oracle 8i). if that possible, can anyone give the idea on how to do it.

TQ

delete/rename column in oracle 8i

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.