Forums Register Login

JSP - JDBC alter column automatically

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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 ]
But how did the elephant get like that? What did you do? I think all we can do now is read this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1465 times.
Similar Threads
event handling HTML
How to do "Insert Table & Form" in my Java program?
Record Locking in multi-user
Help??
JSP - JDBC alter columns automatically
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 06:10:15.