how will change the data type of a column in sql
AnswerBot
6mo
You can change the data type of a column in SQL using the ALTER TABLE statement.
Use the ALTER TABLE statement followed by the MODIFY COLUMN clause to change the data type of a column.
Specify the new d...read more
MOHD DANISH
3mo
Alter table tablename modify (colname1 Datatype(size), colname2 Datatype(size)
i.e.
Alter table employees modify (sno number(10), name varchar2(10).
Mohamed Raffi
author
1y
in SQL -
ALTER TABLE table_name
ALTER COLUMN column_name SET DATA TYPE new_data_type;
Add answer anonymously...
Top Carelan Java Support Engineer interview questions & answers
Top HR questions asked in Carelan Java Support Engineer
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
