need help for oracle insertion

[kittu532]

Hi,
Here i have to insert the values into a table which contains one autoincrement field.This field have to be automatically increment when we insert some values into that table................And plz giv me if there are any links..............i will be very thankful if u could help me.....................................

[debasisdas]

To auto-increment the field value, create a SEQUENCE and use sequencename.nextval in the insert statment.

Hope that helps you in solving your problem.

[kittu532]

shall we use that in java.i mean shall we can write triggers in java ..............

[Saii]

shall we use that in java.i mean shall we can write triggers in java ..............

i think java has some inbuilt class that wraps oracle sequences but not sure. Alternatively, you can do the "insert into table" using a procedure and then use sequence.nextval in the proc and execute this proc in your java application

[debasisdas]

shall we use that in java.i mean shall we can write triggers in java ..............

u can use the sequence with in the sql statment or can call from with in a procedure.

so far as the trigger is concerned, triggers are part of Databse U can't write trigger in Java.

U can't call a trigger explicitely. trigger FIRES automatically when the dependent EVENT on which the trigger is based is executed. It might be directly through any sql statment or from any procedure.

[kittu532]

Thank you very much.........

And if possible could you provide clear information regarding those things....I will be very thankful if u help me................