Questions tagged [database-view]
64 questions
-1
votes
1 answer
Android database view in room
I have some sqlite error in database view in room :
@Entity(tableName = "customers")
data class Customer(@PrimaryKey val id: Int, val name : String, val add : String, val gen:
String ="Hi")
@Entity(tableName = "gender")
data class Gender…
JSONParser
- 1,112
- 2
- 15
- 30
-1
votes
1 answer
Shall I use @DatabaseView in Room with LiveData?
Its working if run query through main thread.
If I try to get DatabaseView with Livedata POJO, Its throwing error
java.lang.IllegalArgumentException: Cannot add the same observer with different lifecycles
at…
AvisSiva
- 707
- 1
- 9
- 17
-2
votes
2 answers
SQL: How to create a database view from tables with OneToMany Relationship?
There are three available tables and columns:
Core - EmpID, EmpName
1, Yagga Boshu
External - ExternalEmpID, ExternalDeptName
1 , Capegemini
Position - EmpID, Dept P/S
1, IT Primary
1, Finance …
fatherazrael
- 5,511
- 16
- 71
- 155
-2
votes
1 answer
Creating view in oracle using multiple queries
I have 2 tables:
create table my_users
( userid number,
username varchar(20)
);
create table all_users
( userid number,
username varchar(20)
);
I want to create a view which is equivalent to:
select * from all_users;
MINUS
select * from…
Alok
- 63
- 1
- 10