User bernd_k

4 votes

Is there a concept of an "include file" in SQL Server?

answered Feb 25, 2012 at 10:40

0 votes

NULLs in a composite primary key - SQL Server

answered Dec 27, 2011 at 8:20

0 votes

Is Using Execute Immediate Bad Practice in Oracle?

answered Dec 19, 2011 at 17:14

1 vote

Oracle bitand inconsistent behaviour

answered Nov 14, 2011 at 18:49

8 votes

Should I use SQL JOIN or IN Clause?

answered Oct 29, 2011 at 9:15

3 votes

What are the minimum matching criteria recommended for reliable demographic based patient matching?

answered Oct 20, 2011 at 11:08

5 votes

How to move data from big table

answered Oct 20, 2011 at 4:53

4 votes

Accepted

Restore Database from Network Drive

answered Oct 11, 2011 at 11:56

4 votes

How do I create a database+tablespace+user in Oracle 11gR2?

answered Oct 11, 2011 at 5:13

3 votes

Accepted

Where to put glogon.sql in 32-bit ODAC (11.2.0.2.1)?

answered Aug 21, 2011 at 11:16

6 votes

Does NULL have a type?

answered Aug 6, 2011 at 12:56

3 votes

Accepted

Cartesian Product SQL / Inserts with multiple Values Clauses

answered Jun 23, 2011 at 14:51

3 votes

What are the consequences of setting varchar(8000)?

answered Jun 5, 2011 at 6:21

4 votes

create incremental number in oracle sql query

answered Jun 3, 2011 at 5:16

3 votes

SELECT statement with an explicit list of columns and then an asterisk (*)

answered May 30, 2011 at 11:58

0 votes

What could be the reason for disallowing a sub query in the values clause?

answered May 29, 2011 at 7:14

11 votes

Accepted

In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?

answered May 27, 2011 at 12:11

4 votes

Accepted

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

answered May 16, 2011 at 9:56

4 votes

Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?

answered May 15, 2011 at 11:11

2 votes

Accepted

Should SQL full text search match the value test2 when searching for test?

answered May 14, 2011 at 17:59

6 votes

Accepted

MAX for each subset

answered Apr 25, 2011 at 12:25

1 vote

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

answered Apr 20, 2011 at 17:22

2 votes

How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?

answered Mar 31, 2011 at 5:17

2 votes

How do long columns impact performance and disk usage?

answered Mar 16, 2011 at 14:16

5 votes

Multidimensional indices in databases

answered Mar 15, 2011 at 16:23

5 votes

What standard should I follow when naming tables and views?

answered Mar 8, 2011 at 21:32

27 votes

How do you document your databases?

answered Mar 4, 2011 at 21:04

1 vote

Multiple Oracle Instances -- is this a good practice?

answered Mar 1, 2011 at 6:04

2 votes

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

answered Feb 19, 2011 at 20:56

4 votes

Group data by non-unique keys by distinct time range

answered Feb 19, 2011 at 12:36

Stack Exchange Network

51 Answers

Is there a concept of an "include file" in SQL Server?

NULLs in a composite primary key - SQL Server

Is Using Execute Immediate Bad Practice in Oracle?

Oracle bitand inconsistent behaviour

Should I use SQL JOIN or IN Clause?

What are the minimum matching criteria recommended for reliable demographic based patient matching?

How to move data from big table

Restore Database from Network Drive

How do I create a database+tablespace+user in Oracle 11gR2?

Where to put glogon.sql in 32-bit ODAC (11.2.0.2.1)?

Does NULL have a type?

Cartesian Product SQL / Inserts with multiple Values Clauses

What are the consequences of setting varchar(8000)?

create incremental number in oracle sql query

SELECT statement with an explicit list of columns and then an asterisk (*)

What could be the reason for disallowing a sub query in the values clause?

In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?

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

Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?

Should SQL full text search match the value test2 when searching for test?

MAX for each subset

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

How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?

How do long columns impact performance and disk usage?

Multidimensional indices in databases

What standard should I follow when naming tables and views?

How do you document your databases?

Multiple Oracle Instances -- is this a good practice?

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

Group data by non-unique keys by distinct time range