• 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 ]
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!