aspose file tools*
The moose likes JDBC and the fly likes JSP - JDBC alter column automatically Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JSP - JDBC alter column automatically" Watch "JSP - JDBC alter column automatically" New topic
Author

JSP - JDBC alter column automatically

Arun Vethadas .T
Ranch Hand

Joined: Dec 13, 2001
Posts: 36
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

Joined: Jul 09, 2001
Posts: 1879

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 ]
 
Consider Paul's rocket mass heater.
 
subject: JSP - JDBC alter column automatically