Home » SQL & PL/SQL » SQL & PL/SQL » Need INSERT Query (Oracle 9i Query)
Need INSERT Query [message #313603] Sun, 13 April 2008 22:39 Go to next message
arunprabhu29917
Messages: 15
Registered: September 2006
Location: Tamilnadu
Junior Member

Hi,

How to write insert query? so that the particular column gets incremented by 1,everytime while inserting the other records in that table.

Best,
Arun K
Re: Need INSERT Query [message #313604 is a reply to message #313603] Sun, 13 April 2008 22:41 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
SQL Experts
Advanced Oracle SQL questions - Complex queries, DML and DDL statements. Newbies should not post to this forum!
Newbies should not post to this forum!
Newbies should not post to this forum!
Newbies should not post to this forum!
Re: Need INSERT Query [message #313606 is a reply to message #313603] Sun, 13 April 2008 23:11 Go to previous message
kecd_deepak
Messages: 52
Registered: December 2007
Member
Hello,
HINT: Use Sequence for that particular Column.
Previous Topic: how can I get bind values for another session? There are conditions..
Next Topic: Order by is killing performance
Goto Forum:
  


Current Time: Sun Dec 04 18:56:10 CST 2016

Total time taken to generate the page: 0.08436 seconds