User bernd_k

13 votes

2 answers

144k views

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

asked Nov 27, 2011 at 9:21

271 votes

7 answers

144k views

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

asked Jan 4, 2011 at 10:32

23 votes

7 answers

99k views

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

asked Jan 17, 2011 at 16:40

20 votes

4 answers

90k views

Can I change the SID of an Oracle database?

asked Jan 6, 2011 at 9:30

10 votes

4 answers

89k views

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

asked Jul 10, 2011 at 20:56

23 votes

2 answers

74k views

How to catch and handle only specific Oracle exceptions?

asked Dec 20, 2011 at 6:56

48 votes

10 answers

73k views

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

asked Jan 26, 2011 at 16:28

9 votes

4 answers

47k views

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

asked Sep 6, 2013 at 9:17

7 votes

1 answer

40k views

How to query given grants on Oracle?

asked Sep 20, 2011 at 10:45

12 votes

4 answers

36k views

Oracle Import problem caused by different character sets

asked May 16, 2011 at 10:10

19 votes

2 answers

29k views

Can I enable SQLCMD mode from inside a script?

asked Sep 7, 2011 at 5:59

5 votes

3 answers

26k views

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

asked Sep 19, 2011 at 13:48

20 votes

4 answers

25k views

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

asked Feb 17, 2011 at 17:58

12 votes

1 answer

25k views

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

asked Mar 8, 2011 at 17:09

7 votes

2 answers

24k views

What is the meaning of Microsoft Compatibility Level?

asked Aug 29, 2011 at 13:06

3 votes

2 answers

18k views

How is localhost resolved by Oracle listener?

asked Dec 3, 2011 at 18:40

4 votes

3 answers

17k views

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

asked Mar 31, 2011 at 13:03

24 votes

1 answer

16k views

How to use transactions with SQL Server DDL?

asked Aug 5, 2011 at 6:20

15 votes

5 answers

16k views

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

asked Jan 5, 2011 at 14:18

14 votes

1 answer

14k views

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

asked Mar 8, 2011 at 11:40

4 votes

2 answers

14k views

How to export a single huge table from SQL Server?

asked Jul 23, 2011 at 16:13

7 votes

1 answer

10k views

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

asked Dec 21, 2011 at 15:25

6 votes

1 answer

9k views

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

asked Feb 25, 2011 at 12:36

3 votes

1 answer

8k views

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

asked Oct 27, 2011 at 8:27

7 votes

3 answers

8k views

How to handle multiple Oracle homes?

asked Jun 6, 2011 at 17:43

4 votes

2 answers

8k views

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

asked Jan 12, 2011 at 14:10

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]?

asked Feb 19, 2011 at 15:16

18 votes

1 answer

7k views

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

asked Dec 20, 2011 at 12:08

3 votes

3 answers

7k views

Login Problem as SYSDBA ORA-01031

asked Sep 29, 2011 at 10:26

7 votes

2 answers

7k views

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

asked May 12, 2011 at 12:36

Stack Exchange Network

88 Questions

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

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

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

Can I change the SID of an Oracle database?

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

How to catch and handle only specific Oracle exceptions?

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

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

How to query given grants on Oracle?

Oracle Import problem caused by different character sets

Can I enable SQLCMD mode from inside a script?

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

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

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

What is the meaning of Microsoft Compatibility Level?

How is localhost resolved by Oracle listener?

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

How to use transactions with SQL Server DDL?

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

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

How to export a single huge table from SQL Server?

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

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

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

How to handle multiple Oracle homes?

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

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

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

Login Problem as SYSDBA ORA-01031

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