User peterh - Database Administrators Stack Exchange

peterh

Member for 9 years, 11 months
Last seen more than a month ago

13 Questions

Score Activity Newest Views

14 votes

3 answers

13k views

How to get the last not-null value in an ordered column of a huge table?

asked Mar 31, 2019 at 17:19

10 votes

4 answers

38k views

Dump Oracle database into a textual SQL script

asked Mar 9, 2016 at 15:37

9 votes

3 answers

10k views

Best table name instead of "user", if the DB doesn't like that [closed]

asked Jul 10, 2014 at 17:07

6 votes

2 answers

13k views

Is there a way to order a PostgreSQL table by its primary key automatically?

asked Jul 10, 2018 at 9:55

4 votes

2 answers

30k views

What is the best practice when creating boolean columns in Oracle?

asked Sep 16, 2014 at 12:52

4 votes

2 answers

7k views

How does SQL*Plus connect to Oracle without a listener?

asked Apr 7, 2014 at 9:10

4 votes

3 answers

5k views

How to completely "reset" an Oracle instance?

asked Apr 8, 2014 at 16:02

3 votes

1 answer

2k views

How to make sqlplus prompt longer than 50 chars?

asked May 6, 2014 at 8:35

1 vote

2 answers

2k views

How to index for multiple inequality WHERE search conditions?

asked May 28, 2014 at 8:47

1 vote

1 answer

2k views

How to generate current Oracle timestamp in perl?

asked Apr 28, 2014 at 14:10

1 vote

0 answers

736 views

Multiple handler entries in lsnrctl services output

asked Apr 4, 2014 at 8:04

0 votes

1 answer

965 views

How to change the output encoding of Oracle command line tools to UTF8?

asked Mar 31, 2014 at 8:53

0 votes

2 answers

216 views

Oracle: how to query a table if I know only its (non-default) tablespace?

asked Feb 19, 2016 at 11:38