Home » Developer & Programmer » Forms » addition of column (form 6i)
addition of column [message #296777] Tue, 29 January 2008 00:58 Go to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear All

I have 1 table called sv_warr and it contains 1000 of records and multiple colunm .

I have a radio button on that table column name "claim_type" that contains 2 values "L"and "I".

My user requirement is in case of "I" the system display a list of values and if the user select one value then the system once again display a list of values and again user select the desired value.means 2 input entered into the sytem against "I" value.

In case of "L" no list of value display.

Kindly advice can i insert 2 column in my table or do some thing else.

One more thing 90 % cases are "L" means if i add 2 column in my table then 90 % null value inserted.

Kindly advice can i add 2 column in my table or use separate table for storing that type of data.


Regards


Zuhair
Re: addition of column [message #297020 is a reply to message #296777] Tue, 29 January 2008 23:11 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Yes you can add more columns to a table. Look at http://www.orafaq.com/forum/m/275844/67467/?srch=two+LOV#msg_275844 for how to have multiple 'chained' LOVs.

David
Previous Topic: How to execute ALTER SYSTEM command from Developer
Next Topic: cursor appearance
Goto Forum:
  


Current Time: Tue Dec 03 18:46:27 CST 2024