Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP - JDBC alter column automatically

 
Arun Vethadas .T
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello
In my JSP project,i'm using oracle database
In that table i have few columns like name,no,and for the date column everytime i click a button add date , a new column will create in the same database table,and next time click the button one more column will create in the table,like that n column for a user. suppose another user add the
same date in his record set ,he add more then other fellow how will create the column automatically. i want that sql query or give some
idea how to do that in oracle tables.
help me pls.
thanks,
Arun.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ALTER TABLE table
ADD (column datatype [DEFAULT expr]
[,column datatype]....);
eg.
ALTER TABLE customer
ADD (hiredate DATE)

Jamie
[ February 21, 2002: Message edited by: Jamie Robertson ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic