Jack Douglas
  • Member for 10 years, 9 months
  • Last seen more than a week ago
difference between oracle 11.2.0.1 to 11.2.0.2
1 votes

You should probably start with the New Features Guide and in particular the section on 11.2.0.2. Note that: 11.2.0.2 is a minor release so for most purposes it will not be much different to 11.2.0....

View answer
PostgreSQL archive_command on Windows
1 votes

Have you considered Robocopy? It is able to copy NTFS ACLs. I guess you might need to have postgres running under the same Domain Account on source and target if possible but I'm probably out of my ...

View answer
Oracle: Physically reorganizing rows of a huge table by a different key
0 votes

If you find that a simple covering index (which will solve all your query performance problems immediately) has an unacceptable impact on INSERT performance, you can introduce an artificial '...

View answer
Selecting row grouped by an "add-on" indicator
0 votes

I'm assuming from your example data that you can tell if a row is an 'addon' by checking if the kind field is null. If that's the case you can use a windowing count on kind to group the rows into '...

View answer
Best way to update list of rows in oracle database
0 votes

Another approach could be a series of update statements UPDATE mytable set mycolumn = 'X' where id = 1; UPDATE mytable set mycolumn = 'X' where id = 2; UPDATE mytable set mycolumn = 'X' where id = 3; ...

View answer
cant access both phone numbers in my nested table type
0 votes

Please take a look at http://www.orafaq.com/wiki/NESTED_TABLE. When you include the nested table it is like a join, so if you want a single row per customer, you will need to do some sort of unpivot (...

View answer
Is there any way to temporarily enforce columnar uniqueness on items currently being inserted?
0 votes

from comments: I suppose I could add an extra field for unique identification, but I that still leaves a problem for non import-related items (day to day use of the system). If I understand ...

View answer
How do I row count into groups?
0 votes

Based on the following assumptions: You already know what order you want your data in and how to do it - in particular, your ordering does not allow ties You have 1 bit field in each row You want to ...

View answer
1
9 10 11 12
13