What Happens if I REST Enable a table with no Primary Key in ORDS?

thatjeffsmith ORDS 1 Comment

When you AUTO-REST enable table in ORDS, we publish a full API for you: We auto find your Primary Key Column and use that to address particular rows (items) in your table (collection.) But..what happens if you don’t have a primary key? CREATE TABLE no_keys (letter CHAR(1), letters VARCHAR2(25), numbers INTEGER);   INSERT INTO no_keys VALUES (’a’, ‘abc’, 1); INSERT …