This is a question driven by curiosity. I am learning Oracle database and Oracle database handles Blob data in a separate tablespace, which I believe reduces overhead while trying to read large Blob ...
Is it a bad practice to rely on an auto-incrementing primary key to sort rows in a table? A coworker and I were having an argument about this subject. We need to be able to find the last-inserted row ...
I'm not sure of the right syntax to use. Is it select * from tlb where flag is NULL or select * from tlb where flag = NULL Is the answer the same for oracle, sqlserver and Postgres?
I always thought the largest scale of banks use Oracle. However, there is no proof they really use Oracle instead of Mysql or PostgreSQL, nobody knows the secret. Any idea what they really use? Can ...
So I am interested in working towards are few specific certs. Namely Oracle 11g, MySQL, and Java. I know there are tons of books out there, and I do plan to hit up my local library on these subjects ...