meta user
network profile
| bio | website | google.com |
|---|---|---|
| location | Peak District National Park, United Kingdom | |
| age | 35 | |
| visits | member for | 1 year, 4 months |
| seen | 3 hours ago | |
| stats | profile views | 606 |
Oracle DBA, Unix admin.
Available for employment.
|
May 10 |
answered | How to remove all hidden parameters from Oracle Database |
|
May 10 |
reviewed | Approve suggested edit on Select records that do not have associations outside a certain list |
|
May 10 |
comment |
Select records that do not have associations outside a certain list What RDBMS are you using? Have you tried writing a query? |
|
May 10 |
comment |
What's the most appropriate NLS_SORT parameter to cover all/most European languages? This is a good starting read for NLS stuff orafaq.com/node/999 |
|
May 10 |
comment |
Built-in XML functions Edit your answer with the full error messages when run through sqlplus. Cut and paste the query and EVERYTHING up to where the SQL> prompt returns after the message. |
|
May 10 |
comment |
Built-in XML functions Does it not give an object name in the ORA-04023 message? It should do. |
|
May 10 |
comment |
Built-in XML functions Actually, not sure you're allowed a WITH clause inside an IN |
|
May 10 |
comment |
Built-in XML functions Can you at least try and execute it in SQL developer or sql plus? It'll tell you where the error is |
|
May 10 |
comment |
Built-in XML functions What oracle version? |
|
May 9 |
comment |
Load different date formats in mysql @user2118349 That's ok. If you found the answer helpful, please mark it as accepted by clicking the "tick" at the top-left. |
|
May 9 |
comment |
DELETE failed because the following SET options have incorrect settings: 'ANSI_NULLS' What happens if you just remove ANSI_NULLS , from the SET command? |
|
May 9 |
reviewed | Approve suggested edit on Load different date formats in mysql |
|
May 9 |
answered | Load different date formats in mysql |
|
May 8 |
comment |
How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2? Is a database link and a local job a better idea, or isn't that an option? |
|
May 7 |
answered | Do I need to use NVARCHAR rather than VARCHAR to properly store UTF8 characters in Oracle? |
|
May 7 |
answered | Oracle 10XE: Stop schemas seeing the all_users table? |
|
May 7 |
comment |
Is it possible to validate DML statements? @kyooryu the question is RDBMS dependant as there is nothing in the SQL standard that enforces this kind of functionality |
|
May 6 |
comment |
Oracle Connection Manager cman.ora startup Looking at your previous history on this site, I know you've seen this blog: arup.blogspot.co.uk/2011/08/… as you used an image from it! Why not follow the troubleshooting steps listed on the blog? it tells you how to enable support level tracing etc.... |
|
May 6 |
comment |
Oracle Connection Manager cman.ora startup What's in the trace file that you've enabled? |
|
May 6 |
answered | Testing AFTER INSERT Trigger |
