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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSP - JDBC alter column automatically
 
Similar Threads
Help??
event handling HTML
JSP - JDBC alter columns automatically
Record Locking in multi-user
How to do "Insert Table & Form" in my Java program?