backup of one table's data before deleteing its all data

[sara440]

i want to take backup of one table(tables's data) of database, on hard disk or cd.i have a button "backup" on my form that should ask for backup when clicked.(it should allow to take backup on Cd).

i m form from which attendance of students is entered.so when session ends ( like for example session of class(MBA) is 2005 -2007),

i want to delete attendance of this class which exists in "student_attend ance" table.On my "Atteandanc e enterence form" i have two buttons named "delete" and " backup"but before deleting i want to press backup button to take backup (on CD or Hard disk or in any word ,excel file).

Tell me any solution
i have no idea of backup.
reply waiting
thanks

[Saii]

You can write and save data from this table to a file on button click.

[debasisdas]

Are u using oracle Forms or any other front end tool ?

[sara440]

Are u using oracle Forms or any other front end tool ?

i m using forms6i and oracle8i
please tell me step by step solution

thnks

[sara440]

You can write and save data from this table to a file on button click.

what is the procedure of writing and saving data on the file from table.

using developer6i and oracle8i
plz tell me
thanks
waiting

[debasisdas]

what is the procedure of writing and saving data on the file from table.

Do you know how to call a batch file (.BAT) from form 6i ?

[sara440]

Do you know how to call a batch file (.BAT) from form 6i ?

no i have no idea
plz tell me procedure to follow
i really need its solution

thanks
sara