SQL tutorial 23: Rename and Modify Column Using Alter Table By Manish Sharma (RebellionRider)

How to Rename a column of a table using alter table and
How to modify a column of a table using alter table
Modify means
How to change datatype of a column and how to change size/width of a column

YouTube Video on How to create database

Tool used in this tutorial is SQL Developer.
This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training.

Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage

Contacts
E-Mail
Twitter
Instagram
Facebook.
Linkedin.

Thanks for liking, commenting, sharing and watching more of our videos

[MahadiHasanshimul]

Thanks you brother for your wonderful presentation.

[softeng]

PLEASE TELL ME HOW TO CHANGE DATA TYPE OF COLUMN IN A TABLE WITHOUT DELETE DATA IN COLUMN

[gayathri]

Hi manish, if you have data in that column how we can modify the column datatype ? Can you explain please.

[balapanurusateesh]

Sir which journals is used for oracle fusion, oracle application & adf would you suggest for me sir

[ramchinthakayala]

HI, Pls tell me, how to add a column in between two columns of the existing table?

[franklyn]

if I have a table called Tablita, where have a Primary key field called campitoClave, and also that by mistake is a foreign field,
How do I stop it from being foreign?

[gudipatitssarma]

when i am select command to display emp table hiredate is displayed as -2005 ie complete ate it is not displaying how to set it

[tyesharay]

I have misspelled a column name in student table can you show me how to change to correct spelling

[ahsanulhaque]

please write me
how to create new database with user and password?
Thanks....

[ramsrini]

Hi Sir,

When I am trying to rename column, I am getting this error.Plz advise

ALTER TABLE demo RENAME test_id to test_name
Error report -
ORA-14155: missing PARTITION or SUBPARTITION keyword
14155. - "missing PARTITION, PARTITIONS, SUBPARTITION, or SUBPARTITIONS keyword"
*Cause: The keyword PARTITION, PARTITIONS, SUBPARTITION, or SUBPARTITIONS was
expected but none were supplied.
*Action: Supply the missing keyword.

[archanawathore]

Hi, the script is nor showing in the link you shared