Skip to main content
bernd_k's user avatar
bernd_k's user avatar
bernd_k's user avatar
bernd_k
  • Member for 13 years, 6 months
  • Last seen more than 10 years ago
280 votes
7 answers
155k views

When should I use a unique constraint instead of a unique index?

13 votes
2 answers
145k views

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

24 votes
7 answers
104k views

How to get rid of ORA-28002 message the password will expire within 6 days?

10 votes
4 answers
101k views

ORA-01502: index or partition of such index is in usable state problem

21 votes
4 answers
94k views

Can I change the SID of an Oracle database?

24 votes
2 answers
77k views

How to catch and handle only specific Oracle exceptions?

48 votes
10 answers
75k views

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

9 votes
4 answers
48k views

How to drop SQL Server database currently in use and in Single user mode

7 votes
1 answer
41k views

How to query given grants on Oracle?

12 votes
4 answers
36k views

Oracle Import problem caused by different character sets

19 votes
2 answers
30k views

Can I enable SQLCMD mode from inside a script?

5 votes
3 answers
27k views

How to replace a CLOB column by a varchar2(4000) column?

12 votes
1 answer
26k views

How can I assign different random values to each row in a SELECT statement?

20 votes
4 answers
26k views

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

7 votes
2 answers
24k views

What is the meaning of Microsoft Compatibility Level?

3 votes
2 answers
18k views

How is localhost resolved by Oracle listener?

25 votes
1 answer
17k views

How to use transactions with SQL Server DDL?

4 votes
3 answers
17k views

How to convert a Top 1 subquery using outer table alias to Oracle?

15 votes
5 answers
16k views

Does it make sense to use SQL Server's bracket notation in hand written code?

4 votes
2 answers
14k views

How to export a single huge table from SQL Server?

14 votes
1 answer
14k views

Why does SQL*PLUS need a slash after CREATE TYPE?

7 votes
1 answer
10k views

How to write a check constraint to disallow empty varchar fields?

6 votes
1 answer
9k views

How to combine date and time to datetime in SQL Server?

4 votes
2 answers
8k views

How to return a CTE as REFCURSOR from an Oracle stored procedure?

7 votes
3 answers
8k views

How to handle multiple Oracle homes?

3 votes
1 answer
8k views

How can I query the SQL Server Compatibility Level into a variable?

4 votes
2 answers
8k views

How can I catch the output of DBMS_OUTPUT.PUT_LINE when executing a block using [Oracle.DataAccess.Client]?

7 votes
2 answers
8k views

I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

19 votes
1 answer
8k views

Empty Strings: Why or when is '' equal to ' '?

3 votes
3 answers
7k views

Login Problem as SYSDBA ORA-01031