File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JSP - JDBC alter column automatically" Watch "JSP - JDBC alter column automatically" New topic

JSP - JDBC alter column automatically

Arun Vethadas .T
Ranch Hand

Joined: Dec 13, 2001
Posts: 36
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.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

ADD (column datatype [DEFAULT expr]
[,column datatype]....);
ALTER TABLE customer
ADD (hiredate DATE)

[ February 21, 2002: Message edited by: Jamie Robertson ]
I agree. Here's the link:
subject: JSP - JDBC alter column automatically
It's not a secret anymore!