Technical Notes
We're all on the same page!
Showing posts with label
primary key
.
Show all posts
Showing posts with label
primary key
.
Show all posts
Friday, 23 March 2018
ORA-02270 solution
›
Preparation SQL> create table A (id number, soid number); SQL> create table B (id number); Action SQL> alter table A add...
Friday, 19 January 2018
How to define primary key on existed table?
›
e.g. steps; lock table -> add new column for primary key -> update data with counter -> define sequence -> define trigger -...
Wednesday, 25 October 2017
ORA-02266 solution
›
Action A table has a PK (Primary Key) B table has a FK (Foreign Key) and referenced to A table's PK -> User tries to truncate tab...
›
Home
View web version