jpmc26's user avatar
jpmc26's user avatar
jpmc26's user avatar
jpmc26
  • Member for 10 years, 11 months
  • Last seen more than 1 year ago
14 votes
2 answers
11k views

Use LDAP for name look up with Oracle Instant Client

13 votes
1 answer
8k views

How do I reraise an exception in a PL/pgSQL EXCEPTION block?

12 votes
1 answer
18k views

How to relate two rows in the same table

8 votes
2 answers
8k views

Should I disable autovacuum on a table while I do a bulk update?

6 votes
4 answers
2k views

Does inserting in order have the same effect as clustering?

6 votes
2 answers
9k views

Cummulative Sum with Reset Value

5 votes
1 answer
19k views

What is a base64 RAW? How do I use it?

4 votes
1 answer
4k views

Filter is applied after DISTINCT ON

4 votes
3 answers
853 views

How can I safeguard against SQL injection where parameterizing my query is not an option?

3 votes
1 answer
6k views

Reset search_path to the global, cluster default

3 votes
1 answer
2k views

Why is DBMS_CRYPTO inaccessible for most users by default?

2 votes
1 answer
376 views

Does bool_and short-circuit function calls with arguments?

2 votes
1 answer
1k views

Why won't Oracle use the spatial index when JOINing tables? (Or: Why is my query with a spatial JOIN so slow in Oracle?)

2 votes
1 answer
189 views

Update the current session's default parameter value to reflect a new default

2 votes
1 answer
905 views

Create a grouping based on chains of pairs

2 votes
3 answers
1k views

Oracle Equivalent of PostgreSQL CLUSTER

1 vote
0 answers
101 views

Oracle - Mysterious indexes

1 vote
1 answer
101 views

Determine structure of out cursor

1 vote
1 answer
604 views

How does TIMESTAMP WITH LOCAL TIME ZONE behave when exporting data?

1 vote
1 answer
3k views

Error granting SELECT on view that uses ALL_OBJECTS

0 votes
1 answer
2k views

How can I get all of a few users' roles?

0 votes
1 answer
649 views

Error "In a grant or revoke statement, the user attempted to grant a tablespace quota above the upper limit." when trying to increase user quota

0 votes
1 answer
61 views

Get data type by ID

0 votes
1 answer
758 views

How to relate 2 tables to a third when the first 2 tables have a relationship?

0 votes
2 answers
7k views

Delete rows in parent table based on criteria in child table - Oracle

0 votes
1 answer
5k views

How do I find gaps between ranges of numbers?

0 votes
2 answers
692 views

Is there any disadvantage to using Oracle's Easy Connect syntax?