Suresh Yadagiri

Empower Every one and Sharing Knowledge

Thursday, September 23, 2010

How do you add column and modify its size in oracle?

alter table student add
address varchar2(20);

alter table student MODIFY
address varchar2(40);
Posted by Suresh Yadagiri at 10:38 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2020 (1)
    • ►  February (1)
  • ►  2013 (17)
    • ►  July (17)
  • ►  2012 (16)
    • ►  September (2)
    • ►  August (11)
    • ►  July (2)
    • ►  June (1)
  • ►  2011 (68)
    • ►  November (2)
    • ►  October (1)
    • ►  September (7)
    • ►  August (10)
    • ►  April (3)
    • ►  March (34)
    • ►  February (11)
  • ▼  2010 (29)
    • ►  November (2)
    • ►  October (7)
    • ▼  September (10)
      • Is oracle creating an index when we create a prima...
      • How do you add column and modify its size in oracle?
      • How do you delete duplicate rows using row ID conc...
      • How to find top n salaries in Oracle table?
      • SQL loader control file example
      • what is Oracle database control file?
      • what is SQL Loader?
      • What we check while dropping column?
      • Can create a table as with NULL fields?
      • How companies got named?
    • ►  August (10)
  • ►  2009 (1)
    • ►  May (1)

About Me

My photo
Suresh Yadagiri
I am Sr J2EE and Liferay developer. Having Good knowledge on Data Warehousing (Informatica and Teradata), Oracle database programming and Administration.
View my complete profile
Simple theme. Powered by Blogger.