meta user
network profile
| bio | website | google.com |
|---|---|---|
| location | Peak District National Park, United Kingdom | |
| age | 35 | |
| visits | member for | 1 year, 5 months |
| seen | May 30 at 20:54 | |
| stats | profile views | 623 |
Inactive, retired.
|
Oct 19 |
awarded | Custodian |
|
Oct 19 |
reviewed | Close How do I monitor which Windows user is logging in as SA? |
|
Oct 19 |
reviewed | Close How to convert data from XML format into Excel workbook or database table |
|
Oct 19 |
reviewed | Close count(id) on Char(0) column does not work! |
|
Oct 19 |
reviewed | Close How can I track the last modified user of a file in an SQL Server 2012 FileTable |
|
Oct 19 |
reviewed | Close Could not start the SQL Server Agent (SQLEXPRESS) |
|
Oct 19 |
reviewed | Close query optimization delete nested query |
|
Oct 19 |
reviewed | Close Restore a SQL Server database to an offline copy |
|
Oct 19 |
revised |
Add an additional listener to Oracle Database Appliance edited tags |
|
Oct 19 |
revised |
Network design considerations for Oracle Database Appliance edited tags |
|
Oct 18 |
comment |
Using the same sequence twice in a PL/SQL statement @Michael-O I'll counter your question by asking how you would implement the use of nextval when splattered liberally throughout a 1000 line query that consists of all manner of complicated SQL. What order would be enforced when selecting each nextval? It really is impossible to do. |
|
Oct 17 |
comment |
SQL Query for the following structure So basically you want to know if a btree is broken, and therefore a gap in select val from (select treeleft as val from treetable union all select treeright as val from treetable) order by val ? |
|
Oct 17 |
comment |
GROUP_CONCAT with ORDER BY , but results are not orderd The ORDER BY is in the inline view, not the outermost query. That's why. |
|
Oct 16 |
comment |
How to detect when did ocurre ORA-00604? As @Mat said, ORA-00604 usually has associated errors which should be under the ORA-00604 report. Where did you see the ORA-00604 error report? |
|
Oct 16 |
answered | SHOW FULL PROCESSLIST for some host does not show `Client port` |
|
Oct 15 |
revised |
Why an object became invalid in oracle databse. added 46 characters in body |
|
Oct 15 |
answered | Why an object became invalid in oracle databse. |
|
Oct 15 |
answered | Trigger to automatically add values to a table in Oracle |
|
Oct 15 |
comment |
ORA-01562: failed to extend rollback segment number 11 This solution won't be faster - it might be significantly slower, as it could quite easily result in the same blocks being written back to disk multiple times. |
|
Oct 14 |
comment |
Database design: where do I put this data? This highlights one of the big problems these days. There is a massive gulf between the likes of Hibernate/random OR library and traditional database design. Would I create an extra table for a 1-1 mapping that adds 2 extra columns of data and forces a join every time? Probably not in this case [given the limited information given]. |
