• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

?INSERT in Oracle9i /Java w/ StringBuffer append?

How do I insert a record into Oracle using Java.  For example I have the keyi an SSN. I have to place an letter into a field and place a date into another field. The record is written for the first time.
Thank you in advance    
1 Solution
what do you mean by w/ StringBuffer append?

The insert is simple:
insert into table(SSN, updated) values('111-11-1111', to_date('12/12/2005', 'mm/dd/yyyy'))

Using parameters would be better:
insert into table(SSN, updated) values(?, ?)
where the values ?, ? are set by parameters:
coolgemAuthor Commented:
I was trying to do the INSERT in Java using the StringBuffer java class.  

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now