Using a SQL*PLUS command, change the column first_name to employee_id.?

Question

What SELECT statement should I write

In oracle language
Thanks in advance

Answer 1

From Oracle 9i release 2 you can use a change column name command.

The format is
ALTER TABLE tab_name RENAME old_col TO new_col;

You can check it out on http://www.techonthenet.com/sql/tables/alter_table.php

Answer 2

You could change the output like this:

SELECT first_name AS employee_id FROM some_table

That will change the output anyway. If you want to change the actual table though, you'll probably have to use the MAKETABLE SQL command to define the table first, and then update that table with the INSERT command using outputted results from a previous query.