Stack Overflow
Stack Overflow

Questions tagged [rowid]

210 questions
2
votes
4 answers

How can I turn the rowid column into a regular column?

I create a table and insert a row : CREATE TABLE people (first_name text NOT NULL, last_name text NOT NULL ); INSERT INTO people (first_name, last_name) VALUES ('John', 'Doe'); I execute: SELECT rowid as ID, first_name, last_name FROM people and…
ericg
  • 8,413
  • 9
  • 43
  • 77
2
votes
2 answers

PL/SQL: Update row based on ROWID

I am trying to update a row in a table which has no unique index. So, I selected the ROWID of the row I want to update and now I want to update the row like this: UPDATE MYTABLE SET MYCOLUMN = 0 WHERE ROWID = "AAAIWWAAFAAApwDADR" MYCOLUMN is of…
SlappyTheFish
  • 2,344
  • 3
  • 34
  • 41
2
votes
2 answers

row ID reset based on Value

I need to generate an ID based store and reset anytime the transaction type = 200. Below is an example for my data. StoreID TransactionID A 200 A 300 A 45 A 1 A 200 A …
Martin H
  • 100
  • 7
2
votes
1 answer

Create object type with rowid attributes

I am trying to create a type with the rowid data type, but I am getting this error because of the type I am trying to use: SQL> CREATE TYPE join_t IS OBJECT (inn rowid, out rowid ); / Warning: Type created with compilation errors. Even though…
Siqueira
  • 423
  • 1
  • 7
  • 29
2
votes
0 answers

How to add row number column to a view in SQLite?

In SQLite, I can add a row number column to an arbitrary table with select rowid,* from tab; for example - sqlite> create table tab(content); sqlite> insert into tab values('first row'); sqlite> insert into tab values('second row'); sqlite> insert…
user2309803
  • 541
  • 5
  • 15
2
votes
1 answer

oracle index on rowid column

Oracle documentation says Columns defined using the ROWID data type behave like other table columns: values can be updated, and so on. Can I create a index on a column defined using ROWID data type containing rowids ?
Bolimera Hannah
  • 195
  • 1
  • 2
  • 11
2
votes
2 answers

PL/SQL "WHERE CURRENT OF" vs "ROWID"

Why Oracle made "where current of" syntax when you can use "rowid"? Example: BEGIN FOR rec IN (SELECT t.column1, t.rowid rid FROM test_table) LOOP UPDATE test_table tb SET column1 = some_function(rec.column1) WHERE tb.rowid = rec.rid; END…
PolyMorph
  • 83
  • 2
  • 7
2
votes
1 answer

select every nth row in SQLite3

I am trying to select every nth row in SQL. I have been looking around Stack Overflow and piece together what I can based on my limited SQL knowledge. I have a table that has 81,225 rows. I am trying to select every 285th row in SQLite. What I am…
Nick Johnson
  • 85
  • 3
  • 9
2
votes
2 answers

ROWID as Parameters in PL/SQL

I am trying to create a helper stored proc to save on repeated code. I wrote the following stored procedure that takes the table name, status_id, and ROWID. PROCEDURE sp_update_stage_status(p_table_name IN VARCHAR2, …
greyfox
  • 6,426
  • 23
  • 68
  • 114
2
votes
1 answer

select rowid Oracle

Im trying to display the rowid pseudocolumn, but something strange happened, This is my query select rowid, rowid||'', rowid r from dual output: ROWID||'' R AAAAECAABAAAAgiAAA AAAAECAABAAAAgiAAA So why cant display rowid without alias…
54l3d
  • 3,913
  • 4
  • 32
  • 58
2
votes
2 answers

why can't we use ROWID as primary key?

According to Oracle Documentation You should not use ROWID as the primary key of a table. If you delete and reinsert a row with the Import and Export utilities, for example, then its rowid may change. If you delete a row, then Oracle may reassign…
Ravi
  • 30,829
  • 42
  • 119
  • 173
2
votes
5 answers

JQgrid - Get Row Number instead of ID

I am creating a JQGrid from a database table that does not contain a single field primary key. Therefore, the field i am supplying as id is not unique and the same one exists in several rows. Because of this, when passing a reference to the data…
mariojjsimoes
  • 31
  • 1
  • 1
  • 3
2
votes
3 answers

property 'row' not found on object of type 'NSIndexPath *' in iOS tableview

I tried to fetch row id of an item with the help of "didSelectRowAtIndexPath" in iOS. Code: - (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath{ indexPathRow=indexPath.row; …
Smitha
  • 6,110
  • 24
  • 90
  • 161
2
votes
1 answer

SQLite: Using ROWID in lieu of a timestamp

Can I use the ROWID in place of a timestamp in an SQLite table? I need to get the 50 most recent items of an SQLite table, I was thinking about using a separate timestamp field, but then I figured a bigger ROWID means a newer item, and the ROWID is…
sashoalm
  • 75,001
  • 122
  • 434
  • 781
2
votes
2 answers

Will unique RIDs ever "overflow"?

I am making an application to run on both SQL Server and PostgreSQL, so I am asking this question about both of them. What happens whenever you create a unique primary key(using a sequence or auto-increment type thing) and you hit over 4 billion…
Earlz
  • 62,085
  • 98
  • 303
  • 499
1 2
3
…
13 14