how can i insert 3 list box data in one column in database

[Rahulnsd]

hi,i use 3 list box in my form 1st for 'date' 2nd for 'month and 3rd for 'year' and i create only column in database to store date that user select from the above 3 list boxes......what should i write for insert
insert into table( )values( )?????
thanks

[Rabbit]

Build a date string from your variables and then use the TO_DATE function to convert it to a date. You can find more about the date function from oracle's documentation. http://docs.oracle.com/cd/B19306_01/...nctions183.htm

[Brahmendra]

Hi

You can insert like this

select to_date(2||'-'||'JAN'||'-'||13) from dual

insert into tablename (COLUMN123) values(to_date( column1||'-'||COLUMN2||'-'||COLUMN3))