User Hector

6 votes

1 answer

1k views

Converting CHAR to DATETIME so I can use DATEADD()

asked Sep 10, 2015 at 18:57

3 votes

3 answers

34k views

Printing comments or statements when executing script to a output file using TOAD/ORACLE

asked Jun 26, 2015 at 14:52

3 votes

1 answer

2k views

DECODE or CASE STATEMENT for PARAMETER in WHERE CLAUSE [closed]

asked Jul 16, 2015 at 20:20

1 vote

1 answer

67 views

Parsing out date_entered field to capture TIME 'hh:mm:ss' based on time range

asked Aug 10, 2015 at 19:16

1 vote

1 answer

2k views

SQL Spool FILE SQLPLUS BATCH FILE

asked Jul 14, 2015 at 15:49

1 vote

2 answers

399 views

SQL Server 2008 having issues with HAVING clause

asked Sep 22, 2015 at 20:26

1 vote

1 answer

53 views

How to filter out sales to find customers who have not purchased in the last 2 years

asked Sep 29, 2015 at 21:46

1 vote

1 answer

46 views

ORACLE: Changing the grouping of a data to be based on month breakdowns

asked May 19, 2016 at 15:58

0 votes

1 answer

1k views

HAVING STATEMENT error SQL command not properly ended

asked Sep 30, 2015 at 18:43

0 votes

1 answer

298 views

Prioritizing values in select statement in ORACLE

asked Oct 1, 2015 at 16:14

0 votes

1 answer

7k views

How to load Excel file into temp table in ORACLE

asked Oct 2, 2015 at 18:52

0 votes

1 answer

132 views

Multiple criteria for including / excluding rows

asked Nov 30, 2015 at 21:50

Stack Exchange Network

12 Questions

Converting CHAR to DATETIME so I can use DATEADD()

Printing comments or statements when executing script to a output file using TOAD/ORACLE

DECODE or CASE STATEMENT for PARAMETER in WHERE CLAUSE [closed]

Parsing out date_entered field to capture TIME 'hh:mm:ss' based on time range

SQL Spool FILE SQLPLUS BATCH FILE

SQL Server 2008 having issues with HAVING clause

How to filter out sales to find customers who have not purchased in the last 2 years

ORACLE: Changing the grouping of a data to be based on month breakdowns

HAVING STATEMENT error SQL command not properly ended

Prioritizing values in select statement in ORACLE

How to load Excel file into temp table in ORACLE

Multiple criteria for including / excluding rows