Questions tagged [rowid]
210 questions
1
vote
2 answers
Oracle: Inner Row Source of Nested Loop - Incorrect Estimated Rows?
My understanding is that the estimated number of rows in an explain plan for the inner row source of a nested loop join reflects the number of rows for just one iteration of that nested loop.
In the following example, step 6 of the explain plan is…
Alex Bartsmon
- 471
- 4
- 9
1
vote
1 answer
How to limit the number of rows deleted in a query using rowid and first in Informix
I can do this statement to get a rowid list:
select first 1000 rowid from table1 where last_update < today-30;
but I can't use it as a subquery for a delete statement:
delete from table1
where rowid in ( select first 1000 rowid from table1
…
Kate T
- 11
- 1
1
vote
1 answer
SQLite Selecting the first row who has a NULL in a column and changing that column to a different value
Hello I have a somewhat unique problem I need to select the first row that has NULL in the Status column and change its value to the text (processing)
To clarify I will use SQLite in a program that will need to process entries in a database.
The…
Enigma
- 31
- 3
1
vote
4 answers
R: How to start a new sub_id each time a new sequence begins
Suppose I have data as follows:
tibble(
A = c(1, 2, 2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4, 4, 5),
B = c(1, 1, 2, 1, 2, 3, 1, 2, 1, 1, 1, 2, 3, 4, 1, 1),
)
i.e.,
# A tibble: 16 x 2
A B
1 1 1
2 2 1
3 …
James Bejon
- 189
- 5
1
vote
1 answer
[EFCore 5, SQLite3]: how to create table without ROWID
I have a model with non-integer primary key. TEXT can't be a alias for ROWID and sqlite creates a ROWID column automatically.
I can disable ROWID when I make a scheme manually, but in EF I do not know how to do it.
EF creates table like this:
CREATE…
Alex A.
- 422
- 3
- 12
1
vote
2 answers
Group By and Create an Column Index in R
I have a data set of users who attempt a set of math problems. They are randomly given a hint(s) to solve the problem (hint.flag). I want to find out how soon a user gets the "correct" answer (Correctness) for each problem after seeing the FIRST…
NewBee
- 990
- 1
- 7
- 26
1
vote
1 answer
Insert new row containing a row id
I need to insert a new row with a new rowID. Does oracle do this automatically or is there something i need to use. I know with sequences you can do mysequence.nextVal or something similar. Is there anything like this for rowID?
auwall
- 743
- 2
- 8
- 9
1
vote
1 answer
The last inserted rowid of a specific table in SQLite3
Is there a way to get the last inserted rowid of a specific table in SQLite3? There is a function last_insert_rowid which returns the rowid of the most recent successful INSERT into a rowid table or virtual table. However, I want to know whether…
Benjamin Du
- 1,391
- 1
- 17
- 25
1
vote
1 answer
Issue with finding row ID in a data table in R
I have a data frame like below. How can I get the row id when all elements are present in a data table.
For example,
Table:
L001 044 N 004 E 036 NA NA NA NA NA NA
L001 086 N 016 E 016 NA NA NA NA NA NA
L001 092 N …
NUdu
- 173
- 6
1
vote
1 answer
How to store Oracle Rowid in Java bean
I am calling a stored procedure that is returning the rowid for a list of rows. I am having trouble with storing the actual rowid value in Java so I can then later use that rowid for a follow up update statement.
For example :
Select name, age,…
Stoutg
- 13
- 4
1
vote
3 answers
Reset rowid field after deleting rows
I'm using an sqlite database, and i want to reset rowid field after deleting rows. my table doesn't have a primary key or a specified Id, i'm only using the default rowid given by sqlite.
NOM TYPE CL VAL SP TP
"test1" …
Nadjib Bendaoud
- 546
- 1
- 8
- 19
1
vote
1 answer
Retrieve multiple rowids in SQLite insert or update, using JavaScript
I know SQLite have last_insert_rowid() function. I'd like to create a similar function but I want to retrieve an array of indexes, each one coming from an insert or update into my db.
To be clearer, I have a populated table like this (name is…
Zappescu
- 1,429
- 2
- 12
- 25
1
vote
1 answer
How to find rowid of a variable? sqlite3
I am making a username password program using sqlite and I want to check if a username is in the database (I've already done this) then I want to find the row id of said username. This will be a username that the user has input. I know how to find…
Samboy T
- 43
- 3
- 8
1
vote
1 answer
How to get the rowid of a word in the database sqlite3?
I am trying to get the rowid of a username in sqlite3, i have got the basics of it but when ever i run it i get somthing like 'sqlite3.Cursor object at 0x03885660' and it changes every time i run it with the same username. I know it is because i…
Samboy T
- 43
- 3
- 8
1
vote
1 answer
Informix: How to get the rowid of the last insert statement
This is an extension of a question I asked before: C#: How do I get the ID number of the last row inserted using Informix
I am writing some code in C# to insert records into the informix db using the .NET Informix driver. I was able to get the id of…
myermian
- 31,823
- 24
- 123
- 215