Skip to main content
Justin Cave's user avatar
Justin Cave's user avatar
Justin Cave's user avatar
Justin Cave
  • Member for 13 years, 3 months
  • Last seen this week
67 votes
Accepted

Why not use a table instead of a materialized view?

51 votes
Accepted

Best practices on common person fields (Name, email, address, gender etc...)

26 votes

What is the difference between Oracle's VARCHAR and VARCHAR2 datatypes?

24 votes
Accepted

Is commit necessary after DML operation in Function/Procedure?

22 votes
Accepted

How to list all users that have grants over a package

22 votes

Professor told us to store serialized Java objects as blobs instead of defining relational tables

21 votes
Accepted

How is LIKE implemented?

18 votes

Oracle - Any way to view uncommited changes to a particular table?

17 votes

Reason to not use nullable number in Oracle?

16 votes

Why use explicit cursors instead of regular loops?

16 votes
Accepted

Why am I getting nondeterministic results with the deterministic function STDEV()?

15 votes
Accepted

Estimate a Database Size

15 votes
Accepted

Materialized views in oracle

15 votes
Accepted

Oracle SQL - CASE in a WHERE clause

15 votes

If you don't rollback a transaction will the change still be made?

13 votes

Is Oracle DB licensing needed for a test environment?

13 votes
Accepted

min(column) with nulls?

13 votes
Accepted

sqlnet.ora or tnsnames.ora changes require reboot?

13 votes

Join condition vs. WHERE...does it make a performance difference?

12 votes
Accepted

Is Oracle DB immune to the InnoDB deadlocks found in MySQL?

12 votes
Accepted

MySQL: Why is auto_increment limited to just primary keys?

12 votes
Accepted

Oracle insert max from two date

12 votes
Accepted

What is a "partitioned view"?

11 votes

A database trigger is an alternative for?

11 votes
Accepted

What is the difference between ROLE and PRIVILEGE for Oracle?

11 votes
Accepted

What is the difference between terminating an Oracle sql statement with semicolon or with a slash on the next line?

11 votes

Are there any fully declarative implementations of SQL

11 votes
Accepted

I want to know about the IOPS (I/O Per Second) and How it influences the DB CRUD operation

10 votes
Accepted

Is it safe to delete dummy tables Oracle 11g XE

10 votes

Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?

1
2 3 4 5
12