Tag Info

New answers tagged


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, ...


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