Oracle - How to add a record to table ?

admin

Administrator
Staff member
I can display a form for a record to be added, using ocicolumnname etc. My question is how do I go through and insert this record to the database ? How do I get a list of the fields so that I can do something like insert into table values (field1_number,'field2_varchar'...). I want this to be dynamic, so that I dont have to change the codes If I added a another column to a table.
Notes the different column types, where you dont have to quote around for number type etc.
Thanks.
 
Back
Top