Tag Info

New answers tagged

0

I believe SQL table should have plural names. It simply reads much better. A table of book records should be called books. The ORM should use the same convention. The Books object is a collection, and presides over all records in the Books Table. A Book object presides over a single record. This makes coding more natural. select name, ...


2

The answer to your question is that it won't let you. Oracle is stricter than other RDBMSes and you'll get an ORA-00904: invalid identifier if you try a CREATE TABLE with a reserved word. However, you can force it to do so by surrounding the name in quotes, for example: CREATE TABLE a ( "date" date ); ... But in doing so, you're essentially admitting ...



Top 50 recent answers are included