Database Administrators
Mat's user avatar
Mat's user avatar
Mat's user avatar
Mat
  • Member for 12 years, 3 months
  • Last seen this week
Profile Activity

120 Answers

Score Activity Newest
195 votes
Accepted

How to properly format sqlite shell output?

111 votes
Accepted

Difference between database vs user vs schema

31 votes
Accepted

How to transfer data using expdp and impdp commands?

29 votes
Accepted

How to see list of databases in Oracle?

22 votes

Locking issue with concurrent DELETE / INSERT in PostgreSQL

16 votes
Accepted

Why is truncate DDL?

15 votes
Accepted

Why did PostgreSQL choose an elephant as it's logo?

13 votes
Accepted

Why I don't need to COMMIT in database trigger?

12 votes
Accepted

What is the difference between ON SCHEMA and ON DATABASE triggers?

12 votes
Accepted

does last_insert_id() returns correct result when writes from multiple sessions?

12 votes

Can a table belong to multiple tablespaces?

11 votes
Accepted

Does creating View cause an overhead to DB?

11 votes
Accepted

Export table without BLOB column

10 votes
Accepted

Bad Design or Complicated Query?

9 votes
Accepted

Using Oracle12C Client with Oracle11.g database

9 votes

What does enable mean in Oracle DDL constraint?

8 votes
Accepted

MySQL single table static and dynamic pivot

7 votes
Accepted

Using Inteval Datatype to store result of calculation

7 votes
Accepted

Table name with special character in the end

6 votes

Oracle ROWID, can we assume it is sequential in a insert-only scenario?

6 votes
Accepted

Duration of adding versus dropping a column

6 votes

Instance Startup Modes & Shutdown Modes

6 votes
Accepted

Why is DBA_SEGMENTS presenting twice the amount of data than the DBA_TABLES?

6 votes
Accepted

After truncating a single partition its Primary key's index becomes unusable and all inserts/updates into that partition fail

6 votes
Accepted

INSERT succeeds but all inserted values become NULL

6 votes
Accepted

jdbc: does setAutoCommit(true) commits past executions?

6 votes
Accepted

Is it possible to monitor role and privilege grant/revoke using triggers?

6 votes

What are the criteria for a sql staying in the V$SQLAREA?

6 votes
Accepted

How do I specify a timeout in sqlite3 from the command-line?

6 votes
Accepted

Oracle database created whats next? Create Schema or Create Tablespace?

1
2 3 4

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.