Question: how to change column name in oracle query?
Answer: Syntax(Oracle,MySQL,MariaDB): ALTER TABLE table_name RENAME TO new_table_name;
Columns can be also be given new name with the use of ALTER TABLE. Syntax(Oracle): ALTER TABLE table_name RENAME COLUMN old_name TO new_name;
Syntax(MySQL,MariaDB): ALTER TABLE table_name CHANGE COLUMN old_name TO new_name;