User Philᵀᴹ

4 votes

Accepted

Oracle: Casting timestamp as date and comparing result

answered May 16, 2019 at 14:00

2 votes

Accepted

How to specify column positions in insert statements generated by pg_dump?

answered May 16, 2019 at 12:02

5 votes

Accepted

When is the AS keyword required?

answered May 14, 2019 at 16:59

0 votes

Accepted

Oracle XE 18c connects with sqlplus, but not DB GUI apps

answered May 14, 2019 at 11:36

1 vote

Change mariadb's log directory

answered May 13, 2019 at 15:38

6 votes

Why does Oracle consider a larger number to be smaller?

answered May 12, 2019 at 18:54

2 votes

Column name or number of supplied values does not match table definition. What shoul I do?

answered May 11, 2019 at 10:47

5 votes

Accepted

How to tell whether mysql was built with libedit or readline?

answered May 11, 2019 at 13:54

4 votes

Accepted

get postgreSQL client computer name

answered May 8, 2019 at 17:42

2 votes

Accepted

postgres notifications from inside stored procedures/triggers not immediately received by node.js listener client

answered Apr 24, 2019 at 12:10

7 votes

Accepted

Show current row "win streak"

answered Apr 20, 2019 at 14:29

2 votes

Accepted

GCP MySQL query logging

answered Apr 18, 2019 at 19:32

2 votes

Overlap of group of scripts

answered Apr 18, 2019 at 15:24

1 vote

Accepted

update older records in each group

answered Apr 16, 2019 at 15:48

26 votes

Accepted

PostgreSQL 9.3.13, How do I refresh Materialised Views with different users?

answered Apr 25, 2017 at 13:28

0 votes

Accepted

SQL Admission Count using row_number

answered Mar 28, 2019 at 16:13

1 vote

Syntax Error on Create Trigger

answered Mar 15, 2019 at 10:39

19 votes

Accepted

Set a column's default value to the concatenation of two other columns' values?

answered Aug 2, 2012 at 19:45

3 votes

Accepted

Fiscal Year dynamic function (Oracle SQL)

answered Nov 15, 2018 at 15:55

1 vote

How to execute AFTER INSERT TRIGGER with an auto-incremented (seq.NEXTVAL) column value in Oracle PL/SQL?

answered Aug 1, 2017 at 13:59

2 votes

Accepted

Convert Date format into bigint format in postgresql

answered Aug 20, 2018 at 7:54

2 votes

Accepted

Why does this query not return records where both fields using CASE WHEN are zero?

answered Aug 16, 2018 at 14:25

1 vote

Aggregate a JSON doing an average on values without defining keys

answered Aug 16, 2018 at 10:08

1 vote

How to swap array values in PostgreSQL.?

answered Aug 15, 2018 at 15:34

1 vote

Return a value only when conditions satisfy for entire column

answered Aug 13, 2018 at 7:47

1 vote

Accepted

0kb backup using mysqldump

answered Aug 12, 2018 at 7:52

1 vote

mySQL - Cannot add Foreign Key Constraint

answered Aug 8, 2018 at 15:02

1 vote

Parameterized Queries in PostgreSQL using PHP fail to handle null values

answered Aug 4, 2018 at 8:44

5 votes

Difference of two columns with possible NULL cells

answered Aug 1, 2018 at 15:45

2 votes

Accepted

Upgrading MariaDB 10.1.32 version to 10.3.7

answered Aug 1, 2018 at 9:19

Stack Exchange Network

576 Answers

Oracle: Casting timestamp as date and comparing result

How to specify column positions in insert statements generated by pg_dump?

When is the AS keyword required?

Oracle XE 18c connects with sqlplus, but not DB GUI apps

Change mariadb's log directory

Why does Oracle consider a larger number to be smaller?

Column name or number of supplied values does not match table definition. What shoul I do?

How to tell whether mysql was built with libedit or readline?

get postgreSQL client computer name

postgres notifications from inside stored procedures/triggers not immediately received by node.js listener client

Show current row "win streak"

GCP MySQL query logging

Overlap of group of scripts

update older records in each group

PostgreSQL 9.3.13, How do I refresh Materialised Views with different users?

SQL Admission Count using row_number

Syntax Error on Create Trigger

Set a column's default value to the concatenation of two other columns' values?

Fiscal Year dynamic function (Oracle SQL)

How to execute AFTER INSERT TRIGGER with an auto-incremented (seq.NEXTVAL) column value in Oracle PL/SQL?

Convert Date format into bigint format in postgresql

Why does this query not return records where both fields using CASE WHEN are zero?

Aggregate a JSON doing an average on values without defining keys

How to swap array values in PostgreSQL.?

Return a value only when conditions satisfy for entire column

0kb backup using mysqldump

mySQL - Cannot add Foreign Key Constraint

Parameterized Queries in PostgreSQL using PHP fail to handle null values

Difference of two columns with possible NULL cells

Upgrading MariaDB 10.1.32 version to 10.3.7