Tagged Questions
0
votes
1answer
286 views
Find ID columns with null value in oracle database
I need a way to iterate through all tables in tablespace "T_ECOS" and find all ID with null value in oracle database
Any suggestion?
1
vote
2answers
463 views
Can I implement a 'gapless' identity column in Oracle?
In SQL Server it is so easy to write:
create table #tmp (
id integer identity(1,1) primary key,
message varchar(256)
);
When I try to migrate this to Oracle, I end up with:
CREATE ...
