| using of rowid [message #8743] |
Tue, 23 September 2003 04:02  |
Bipul
Messages: 11
Registered: June 2003
|
Junior Member |
|
|
|
can we insert values in table using Rownum and Rowid,If yes ,how can we do?plz send me syntax.
|
|
|
|
| Re: using of rowid [message #8747 is a reply to message #8743] |
Tue, 23 September 2003 07:39  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Bipul,
You may be able to do this,but pls do see my earlier post about Rowids,ordering of rows.
Dont rely on Oracle's implicit ordering or conversions.Its not consistent and the implementation is subject to change.
Rownums are dynamically assigned to rows as they are returned from a result set.
And as you saw in the example,Oracle may NOT always create a NEW rowid for new inserts.It chooses a data block to insert based on pctused,freelists,pctfree etc..
Just my 2 cents..
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
